insert query in php ~ Online tutorial

insert query in php

PHP MySQL Insert Into

The INSERT INTO statement is used to insert new records into a database table.
Insert Data Into a Database Table The INSERT INTO statement is used to add new records to a database table.

Syntax

INSERT INTO table_name
VALUES (value1, value2,....)

You can also specify the columns where you want to insert the data:

INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)

Note:
SQL statements are not case sensitive. INSERT INTO is the same as insert into. To get PHP to execute the statements above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.

Example

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
mysql_query("INSERT INTO person (FirstName, LastName, Age)
VALUES ('kanna', 'kumar', '15')");
mysql_query("INSERT INTO person (FirstName, LastName, Age)
VALUES ('senthil', 'godwin', '13')");
mysql_close($con);
?>

Buy it 40%discount

Please Give Us Your 1 Minute In Sharing This Post!

SOCIALIZE IT →

Online tutorial