PHP MySQL Insert Into data insertion usage analysis

PHP MySQL Insert Into data insertion usage analysis_php skills

WBOY

Release： 2016-05-16 20:07:19

Original

1090 people have browsed it

The example in this article describes the usage of Insert Into data insertion in PHP MySQL. Share it with everyone for your reference. The details are as follows:

The INSERT INTO statement is used to insert new records into the database table.

Insert data into database table

INSERT INTO statement is used to add new records to the database table.

Grammar:

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

Copy after login

You can also specify the columns into which you wish to insert data:

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

Copy after login

Note: SQL statements are not case sensitive. INSERT INTO is the same as insert into.

In order for PHP to execute this statement, we must use the mysql_query() function. This function is used to send a query or command to the MySQL connection.

Example:

In the previous chapter, we created a table named "Persons" with three columns: "Firstname", "Lastname" and "Age". We will use the same table in this example. The following example adds two new records to the "Persons" table:

<&#63;php
$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);
&#63;>

Copy after login

Insert data from form into database:

Now, we create an HTML form that inserts new records into the "Persons" table.
Here is this HTML form:

<html>
<body>
<form action="insert.php" method="post">
Firstname: <input type="text" name="firstname" />
Lastname: <input type="text" name="lastname" />
Age: <input type="text" name="age" />
<input type="submit" />
</form>
</body>
</html>

Copy after login

When the user clicks the submit button in the HTML form in the example above, the form data is sent to "insert.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 is added to the database table.

The following is the code of the "insert.php" page:

<&#63;php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
 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]')";
if (!mysql_query($sql,$con))
{
 die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
&#63;>

Copy after login

I hope this article will be helpful to everyone’s PHP programming design.