Insert one , multiple rows in mysql db using php

by Preetha 2012-09-14 09:54:19

Let's imagine for this example that my table name is "people" and inside this table i have 3 columns "id", "first_name" and " last_name".

This way to insert a single row with the person "Chuck Norris" i need to execute the following query:

$validation = mysql_query("INSERT INTO platform_types
(id, first_name, last_name)
VALUES ('1', 'Chuck', 'Norris')"
,$db_con);

if (!$validation) //test query for errors
{
echo("Error in query: " . mysql_errno($apbl_db_con) . ": "
. mysql_error($apbl_db_con) . '
');
}
//Closing connection (don't forget to close the connection
//when you don't want to query stuff to the db)
apbl_db_close($apbl_db_con);

The $db_con variable is the one returned by mysql_connect when you connect to the database. If you need to insert multiple rows at same time the procedure is the same but you add more values at the end like this:

$validation = mysql_query("INSERT INTO platform_types
(id, first_name, last_name) VALUES
('1', 'Chuck', 'Norris'),
('2', 'Jackie', 'Chan')",$db_con);

//the rest of the code it's the same. Notice that if your "id" column is set to auto-increment (usually is) you don't need to give a value to the "id" in the query because it will auto-increment by him self. Then your query will look like this:

$validation = mysql_query("INSERT INTO platform_types
(first_name, last_name) VALUES
('Chuck', 'Norris'),
('Jackie', 'Chan')",$db_con);

//the rest of the code it's the same.

Tagged in:

444
like
0
dislike
0
mail
flag

You must LOGIN to add comments