PHP MySQL Insert Into usage

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }
mysql_select_db("my_db", $con);
mysql_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Peter', 'Griffin', '35')");
mysql_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Glenn', 'Quagmire', '33')");
mysql_close($con);
?>

from the form Insert data into database

Now, create an HTML form that will insert new records into the "Persons" table. HTML form:

Firstname:
Lastname:
Age:

 .php". The "insert.php" file connects to the database and retrieves values ​​from the form through the $_POST variable.

Then, the mysql_query() function executes the INSERT INTO statement, and a new record will be added to the database table.

/**

* insert into insert data

* edit: bbs.it-home.org

 {
 die('Could not connect: ' . mysql_error());
 }
mysql_select_db("my_db", $con);
$ sql="INSERT INTO Persons (FirstName, LastName, Age)
VALUES
('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";
< ;p>if (!mysql_query($sql,$con))
 {
 die('Error: ' . mysql_error());
 }
echo "1 record added";
 mysql_close($con)
?>



Copy code