Introduction to php database processing for beginners. Learn php insert stateemnt basics

  :: Home

PC Topics

  :: Build A PC

  :: Windows XP

  :: PC Help

Tutorials

  :: HTML

  :: JavaScript

  :: ASP

  :: PHP

  :: VBScript

  :: SQL

Miscellaneous

  :: Code/Scripts

  :: Forum

  :: Links

  :: Contact us

  :: Tell A Friend

  :: In Somali

  ::

Web Articles

Top Web Hosting
Reviews

Processing
Online Card Payment Guide

Domain name
registration & buying guide

Getting
a website online guide

Search Engine
submission & optimization tips

Quality business correspondence.

Insert Record to a Database with PHP

To add data to a database table, you need an existing database plus the table to add the data to. Let us assume that you have mysql database with the following table:

feeds
Field Name	Data Type	Field Size
user_id	Autonumber	--
Name	Text	45
Comments	Text	200

To add a data to the table feeds, first we will have to create a form to enter the data and then open the database and make the connection.
Here is the form to enter the data before adding to the database:

HTML PHP Form Example
<html> <head> <title> Adding to database example </title> </head> <body> <form name="form" method="post" action="save.php"> Name: <input type="text" name="name" maxlength="45"> <br> Comments: <textarea cols="20" rows="8" name="comments" maxlength="200"> </textarea><br> <input type="submit" name="Save" value="Submit"> </form> </body> </html> Execution Result Name: Comments:

This form stright forward, html form that submits it's information to another file save.php for process.

Now, we will create connection file and call it connect.inc.
<?php $dbh=mysql_connect ("localhost", "root", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("feeds");
?>
It's good programming practise to seperate your connection file to include any php file that will require connection to your sql database.

The following example checks if the form fields are empty, checks if the comment with the same name already exists in the database and inserts a record if the both cases are false:

save.php

<?php
include("connect.inc");
$msg="";
$save="";
if (isset($_POST['submit']))
{
 $name=$_POST['name'];
 $comments=$_POST['comments'];
 if(trim($name)=="")
 { $msg=$msg."Name is missing. ";
 }
 if(trim($comments)=="")
 {
 $msg=$msg."No comment provided. ";
 }
 if(!get_magic_quotes_gpc())
 {
 $comments = addslashes($comments);
 }
 if(trim($msg) =="")
 {
 $check_record=mysql_query("SELECT name, comments FROM feed WHERE name='".$name."' AND comments='".$comments."'",$dbh);
 $num_rows = mysql_num_rows($check_record);
 if($num_rows !=0)
 {
 $msg=$msg."* Name and the comment entered already exists. Record was not added due to duplication. ";
 }
 else
 {
 $query="INSERT INTO feed (name, comments) VALUES ('$name', '$comments')";
 $result = mysql_query($query);
 $save=$save."* Record was sucessfully entered* <a href='view.php'>View Feeds</a> ";
 mysql_close($dbh);
 }
 }
 }
 if(trim($msg)!=""){
 print "$msg";}
 if(trim($save)!=""){
 print "$save";}
?>

The third field (user_no) of our table is auto generated and sequentially will accommulate it self on each addition of new record.
Test the form above to see the result.

After the data is added to the database, the next thing you may want do is view to see what is added.
This code bellow displays records from the feed table..

View.php

<?php
include("connect.inc");
$query="SELECT * FROM feed";
$result=mysql_query($query);
$records=mysql_numrows($result);
echo "Database Records Output ";
$i=0;
while ($i < $records)
{
 $name=mysql_result($result,$i,"name");
 $comments=stripslashes(mysql_result($result,$i,"comments"));
 $id=mysql_result($result,$i,"user_id");
 echo "<hr size='3' color='red' width='65%' align='left'>";
 echo "User No: $id Name: $name Comment:$comments ";
 $i++;
}
?>

Form Process

Update Database

Your Ad Here

Listed @ ConsumerVote.com - The Consumer Rated Web Directory

PC Articles

Computer Safety
prevent viruses & Spyware