Introduction
Hi guys, In this article we are going to have a
glance at the insert into statement through php. The INSERT INTO statement is
used to insert new records in a table. Here we are going to explore the concept thoroughly. You must have the required XAMPP server; if you do not have XAMPP server then go to the link
http://www.c-sharpcorner.com/UploadFile/c8aa13/installation-of-xampp-server-to-run-php-program/
Note : To create the database go to
http://www.c-sharpcorner.com/UploadFile/c8aa13/creation-of-database-table-through-php/
Insert Data Into a Database TableHere in this section, the INSERT INTO statement
is used to add new records to a database table.
Syntax
We can use the insert into command in two forms. It
is possible to write the INSERT INTO statement in two forms.
- In this it doesn't specify the column names where the data will be inserted, only their values.
INSERT INTO table_name VALUES (value1, value2, value3,..and so on.)
- The second form specifies both the column names and the values to be inserted.
INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)
PHP Script for inserting the data into table
<html>
<body
bgcolor="skyblue">
<center>
<h3>
Inserting data into database table !
<h3>
<hr>
<?php
$con
= mysql_connect("localhost","root","");
if
(!$con)
{
die('Could
not connect: '
.
mysql_error());
}
mysql_select_db("dwij",
$con);
mysql_query("INSERT
INTO PBL (FirstName, LastName, Age) VALUES ('DEEPAK', 'DWIJ', '25')");
mysql_query("INSERT
INTO PBL (FirstName, LastName, Age) VALUES ('Prerna', 'Kaul', '23')");
echo
"Record
inserted into table PBL ! ";
mysql_close($con);
?>
</center>
</body>
</html>
Save it by
insert.php
Output
To run the code, Open the XAMPP server and start the services like Apache and
MySQL. Open the browser type: http://localhost/yourfoldername/insert.php
![inserted1.gif]()
To show where the data is inserted, open the browser and type in the url:
http://localhost/phpmyadmin/index.php?db=dwij&token=6af47d988e2f11114a03bd72341e49c4
![ins2.gif]()
Insert Data From a Form Into a Database
Here in this section we will insert data into a database table from the front
end.
HTML Script
<html>
<body
bgcolor="Lightgreen">
<center>
<h2>
Inserting Data into PBL table !
<h2>
<hr>
<form
action="phppage.php"
method="post">
Firstname:
<input
type="text"
name="firstname"><br><br>
Lastname:
<input
type="text"
name="lastname"><br><br>
Age:
<input
type="text"
name="age"><br><br><br>
<input
type="submit">
</form>
</center>
</body>
</html>
Save it as Main.php.
PHP Script
<html>
<body
bgcolor="Skyblue">
<center>
<h3>
Data Inserted into PBL table !
<h3>
<hr>
<?php
$con
= mysql_connect("localhost","root","");
if(!$con)
{
die('Could
not connect: '
.
mysql_error());
}
mysql_select_db("dwij",
$con);
$sql="INSERT
INTO PBL (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)
?>
</center>
</body>
</html>
Save it as
phppage.php.
Output
To run the code, Open the XAMPP server and start the services like Apache and
MySQL. Open the browser type:
http://localhost/yourfoldername/Main.php
![ins3.gif]()
After clicking on the submit Query button the next page will be as follows:
![ins4.gif]()
To show where the data is inserted, open the browser and type in the url
http://localhost/phpmyadmin/
![ins5.gif]()
Select the database 'dwij'
from the left corner of the figure shown above.
![ins6.gif]()
Now click on the 'pbl' from
the left corner of the page shown above; you will get the final result.
![ins7.gif]()
Conclusion : Inserting data from the front end is an important task; now
you can easily work with Insert statement with php script.
Thanks !