Working With Related Tables

Submitted by:David Villa

Date added:12 January, 2014

Category:Other

This is a pretty simple little snippet, but it help understanding how to use relational tables w/in PHP.

Tags: related tables , relational tables

Code Snippet:

/* Substitute appropriately w/in your own code...
1st table is the table that contains a related field to the 2nd.
For example, the first table would have an auto increment
field like address_record_id, int(11), PRI, 0. The 2nd table would
have a field address_record_id, int(11), NULL. The mysql_insert_id
command gets the $addressid variable ready for the second INSERT. */

else
{
if (!($newresult = mysql_db_query($DB, "INSERT INTO your1sttable (address1,address2,city,state)
VALUES ('".addslashes($form_address_line1)."','".addslashes($form_address_line2)."','".addslashes($form_city)."','".addslashes($form_state)."')")))
// Displays error message if INSERT fails.
{
DisplayErrMsg(sprintf("internal error %d:%s\n",
mysql_errno(), mysql_error()));
exit();
}
/* Grabs last row from the above insert, uses that as
the related value. NOTE: If the value is an INT in
your table, dont use addslashes, as with the example
below. */

$addressid = mysql_insert_id($newresult);
if (!($newresult = mysql_db_query($DB, "INSERT INTO your2ndtable (user_name,login_name,password,email_id,address_record_id)
VALUES ('".addslashes($form_name)."','".addslashes($form_user_id)."','".addslashes($form_password)."','".addslashes($form_email_id)."','$addressid')")))
// Displays error message if INSERT fails.
{
DisplayErrMsg(sprintf("internal error %d:%s\n",
mysql_errno(), mysql_error()));
exit();
}

else
{
header("Location:http://$HTTP_HOST/$DOCROOT/success.htm");
exit();
}
}

// The last else just directs the user to a page confirming everything went ok.
 
 

Comments