OS: Mac OSX
Language: PHP w/ MySQL database
I've created an insert page where a user inputs his info, which then goes to four different tables in a MySQL database. The tables are all linked with the field 'member_id', which is an auto-increment field in the parent table ('members').
I've been able to input multiple records into the other three tables 'specialty_groups', 'committee_interest' and 'committee_member' until recently.
After creating this insert page, I had to add an auto-increment key field to the 'specialty_groups' table so that users could go in and delete or make updates to their specialty choices (in the update pages).
The trouble is, now when I go to insert specialty records into the 'specialty_group' table, I can only insert one record. The 'committee_interest' and 'committee_member' tables are still inputting multiple records just fine.
So, I figured it was because I added the auto-increment key field to the 'specialty_group' table. But the confusing thing is that when a user is updating his info, he/she can add as many 'specialty_group' fields as he/she wants - on the update page. (However, on that page, the 'member_id' field is taken from a session variable 'username' from the 'member' table).
My code for the insert page is below:
Expand|Select|Wrap|Line Numbers
- <?php require_once('../Connections/connection.php'); ?>
- <?php
- function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
- {
- $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
- switch ($theType) {
- case "text":
- $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
- break;
- case "long":
- case "int":
- $theValue = ($theValue != "") ? intval($theValue) : "NULL";
- break;
- case "double":
- $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
- break;
- case "date":
- $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
- break;
- case "defined":
- $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
- break;
- }
- return $theValue;
- }
- //code here for inserting fields into the 'member' table.
- $editFormAction = $_SERVER['PHP_SELF'];
- if (isset($_SERVER['QUERY_STRING'])) {
- $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
- }
- // loop through array of commmbr[] and write each instance to db
- @reset($commmbr);
- mysql_select_db($database_connection, $connection);
- if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "memberinfo"));
- while (list($key, $val) = @each ($commmbr)) {
- $insertSQL = sprintf("INSERT INTO committee_member (commmbr, member_id) VALUES (%s,LAST_INSERT_ID())",
- GetSQLValueString($val, "text"),
- GetSQLValueString($_REQUEST['member_id'], "int"));
- mysql_select_db($database_connection, $connection);
- $Result1 = mysql_query($insertSQL, $connection) or die(mysql_error());
- }
- $editFormAction = $_SERVER['PHP_SELF'];
- if (isset($_SERVER['QUERY_STRING'])) {
- $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
- }
- @reset($commint);
- mysql_select_db($database_connection, $connection);
- if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "memberinfo"));
- while (list($key, $val) = @each ($commint)) {
- $insertSQL = sprintf("INSERT INTO committee_interest (commint, member_id) VALUES (%s,LAST_INSERT_ID())",
- GetSQLValueString($val, "text"),
- GetSQLValueString($_REQUEST['member_id'], "int"));
- mysql_select_db($database_connection, $connection);
- $Result1 = mysql_query($insertSQL, $connection) or die(mysql_error());
- }
- $editFormAction = $_SERVER['PHP_SELF'];
- if (isset($_SERVER['QUERY_STRING'])) {
- $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
- }
- // loop through array of specialty[] and write each instance to db
- @reset($specialty);
- mysql_select_db($database_connection, $connection);
- if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "memberinfo"));
- while (list($key, $val) = @each ($specialty)) {
- $insertSQL = sprintf("INSERT INTO specialty_group (specialty, member_id) VALUES (%s,LAST_INSERT_ID())",
- GetSQLValueString($val, "text"),
- GetSQLValueString($_REQUEST['member_id'], "int"));
- mysql_select_db($database_connection, $connection);
- $Result1 = mysql_query($insertSQL, $connection) or die(mysql_error());
- }
- $colname_rs_member = "-1";
- if (isset($_GET['recordID'])) {
- $colname_rs_member = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
- }
- mysql_select_db($database_connection, $connection);
- $query_rs_member = sprintf("SELECT * FROM member WHERE member_id = %s", $colname_rs_member);
- $rs_member = mysql_query($query_rs_member, $connection) or die(mysql_error());
- $row_rs_member = mysql_fetch_assoc($rs_member);
- $totalRows_rs_member = mysql_num_rows($rs_member);
- $colname_rscommitteemember = "-1";
- if (isset($_GET['recordID'])) {
- $colname_rscommitteemember = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
- }
- mysql_select_db($database_connection, $connection);
- $query_rscommitteemember = sprintf("SELECT * FROM committee_member WHERE member_id = %s", $colname_rscommitteemember);
- $rscommitteemember = mysql_query($query_rscommitteemember, $connection) or die(mysql_error());
- $row_rscommitteemember = mysql_fetch_assoc($rscommitteemember);
- $totalRows_rscommitteemember = mysql_num_rows($rscommitteemember);
- $colname_rscommitteeinterest = "-1";
- if (isset($_GET['recordID'])) {
- $colname_rscommitteeinterest = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
- }
- mysql_select_db($database_connection, $connection);
- $query_rscommitteeinterest = sprintf("SELECT * FROM committee_interest WHERE member_id = %s", $colname_rscommitteeinterest);
- $rscommitteeinterest = mysql_query($query_rscommitteeinterest, $connection) or die(mysql_error());
- $row_rscommitteeinterest = mysql_fetch_assoc($rscommitteeinterest);
- $totalRows_rscommitteeinterest = mysql_num_rows($rscommitteeinterest);
- $colname_rsspecialty = "-1";
- if (isset($_GET['recordID'])) {
- $colname_rsspecialty = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
- }
- mysql_select_db($database_connection, $connection);
- $query_rsspecialty = sprintf("SELECT * FROM specialty_group WHERE member_id = %s", $colname_rsspecialty);
- $rsspecialty = mysql_query($query_rsspecialty, $connection) or die(mysql_error());
- $row_rsspecialty = mysql_fetch_assoc($rsspecialty);
- $totalRows_rsspecialty = mysql_num_rows($rsspecialty);
- ?>
Charity