Skip to content

MySQL INSERT

To insert a record in a table,

<?php

/* Connect the database
$con =.......
select the database then, */

$insert_sql = "INSERT INTO `table_name` (`name`,`gender`,`age`)
VALUES ('personX','male','20')";

if(mysql_query($insert_sql,$con))
{
    echo "record inserted successfully";
}
else
{
    echo "Error in inserting:".mysql_error();
}
?>

Here table_id is primary key, it will be auto incremented.

<< Back

MySql Select

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: