shadowline
Include << INSERT >> SELECT
The INSERT command is used to enter new information into a database. A common way to gather information is using a form.

form_page.php
<form method="post" action="enter_it.php">
First Name : <input type="text" name="first_name" /><br />
Last Name : <input type="text" name="last_name" /><br />
Phone Number : <input type="text" name="phone_number" /><br />
<input type="submit" name="submit" value="submit" />
</form>

Once the SUBMIT button is clicked on, the information entered will pass over to the "enter_it.php" page through the $_POST[ ] variable.

enter_it.php
<?php

// connect to server, database, table.
include ("db_connect.inc");

// add the new information into the database
$query="INSERT INTO address_book (first_name,last_name,phone_number) VALUES ('$_POST[first_name]','$_POST[last_name]','$_POST[phone_number]')";
if(!mysql_db_query($dbname,$query,$link_id)) die(mysql_error());
echo "success in database entry.";

echo "<br />";
echo "<a href=\"form_page.php\">Click here to return to the form page.</a>";
?>

To explain the new coding snippit :

$query="INSERT INTO address_book (first_name,last_name,phone_number) VALUES ('$_POST[first_name]','$_POST[last_name]','$_POST[phone_number]')";

We are using a variable $query to contain the command information we want to perform. This keeps our coding easy to maintain.

$query="INSERT INTO address_book (first_name,last_name,phone_number) VALUES ('$_POST[first_name]','$_POST[last_name]','$_POST[phone_number]')";

INSERT INTO prepares the database for new incoming data. address_book is stating which table is going to receive the new information and what columns (by name) will be affected.

$query="INSERT INTO address_book (first_name,last_name,phone_number) VALUES ('$_POST[first_name]','$_POST[last_name]','$_POST[phone_number]')";

The VALUES of the following variables contain the new information to be entered into the specified columns.

if(!mysql_db_query($dbname,$query,$link_id)) die(mysql_error());

IF the following value is not true, the script will stop (die) and print out the error.

mysql_db_query is a command used to perform the actual insert command. it uses the database name, query command, and server link to make it all happen.
Include << INSERT >> SELECT
shadow

Advertise in the banner along the top, Click here!

Valid XHTML 1.0 Transitional Valid CSS! Text Link Ads
shadow
shadow