Reader Level:
ARTICLE

Insert Statement With PHP Script

Posted by Mike Steward Articles | PHP December 27, 2011
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.
  • 0
  • 0
  • 5585

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 Table

Here 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 !
 

COMMENT USING