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
In the previous chapter we created a table named "Person", 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 "Person" table:
<?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 person (FirstName, LastName, Age)
VALUES ('Peter', 'Griffin', '35')");
mysql_query("INSERT INTO person (FirstName, LastName, Age)
VALUES ('Glenn', 'Quagmire', '33')");
mysql_close($con);
?>
|
Insert Data From a Form Into a Database
Now we will create an HTML form that can be used to add new records to the
"Person" table.
Here is the 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>
|
When a 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 a database, and retrieves the values
from the form with the PHP $_POST variables. Then, the mysql_query() function
executes the INSERT INTO statement, and a new record will be added to the database table.
Below is the code in the "insert.php" page:
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$sql="INSERT INTO person (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)
?>
|
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
|
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
|
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |
|
Promote collaboration among coworkers in your organization through project workspaces where others can efficiently find information and work together |
|
Personalize your company profile by bookmarking and organizing favorite content, uploading assets, posting photos, blogging, and more |
|
Interact with features like tagging, flagging, wikis and ratings found in the Web 2.0 Toolbox |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
Request an
INSTANT DEMO or download a
FREE TRIAL today. |
|
HOME
Printer friendly page
