Here is my update.
So I created a new php document, and used only an update query on the form, and created a secondary form that posts information for the insert command on a second page. The problem is that the update doesn't work on this form. Interestingly i've created a third page that just updates information and that works fine. Its when I use javascript to submit the form that it seems to fail altogether, its the only thing I can think of...
The code to the problem page.
<?php require_once('Connections/CustInfo_mySQL.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE custinfo SET LastName=%s, FirstName=%s, Address=%s, Address2=%s, City=%s, WHERE EnrollNumber=%s",
GetSQLValueString($_POST['LastName'], "text"),
GetSQLValueString($_POST['FirstName'], "text"),
GetSQLValueString($_POST['Address'], "text"),
GetSQLValueString($_POST['Address2'], "text"),
GetSQLValueString($_POST['City'], "text"),
GetSQLValueString($_POST['EnrollNumber'], "text"));
mysql_select_db($database_CustInfo_mySQL, $CustInfo_mySQL);
$Result1 = mysql_query($updateSQL, $CustInfo_mySQL) or die(mysql_error());
$updateGoTo = "AddFinalNote.php"; // If I change this to $updateGoTo = ""; then the Update will save
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
$colname_CustInfo = "-1";
if (isset($_GET['recordID'])) {
$colname_CustInfo = $_GET['recordID'];
}
mysql_select_db($database_CustInfo_mySQL, $CustInfo_mySQL);
$query_CustInfo = sprintf("SELECT * FROM custinfo WHERE EnrollNumber = %s", GetSQLValueString($colname_CustInfo, "text"));
$CustInfo = mysql_query($query_CustInfo, $CustInfo_mySQL) or die(mysql_error());
$row_CustInfo = mysql_fetch_assoc($CustInfo);
$totalRows_CustInfo = mysql_num_rows($CustInfo);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style>
.UpdateCust{
position:absolute;
left:0%;
top:75%;
}
.EditCust{
position:absolute;
left:33%;
top:75%;
}
.OrigCust{
position:absolute;
left:66%;
top: 75%;
}
</style>
<script src="DataBase_Scripts/Add_Note/WIPAN.js"></script>
</head>
<body>
<body>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<!--The forms are generic to the dreamweaver update query wizard-->
<!--Cutting unneeded code...the following is the end of the generic form code-->
<input type="hidden" name="MM_update" value="form1" />
<input type="hidden" name="EnrollNumber" value="<?php echo $row_CustInfo['EnrollNumber']; ?>" />
</form>
<!--I create my own form-->
<form method="post" id="AddNoteForm" name="AddNoteForm" action="<?php echo "AddFinalNote.php"; ?>">
<!--once again cutting unneeded code, the ending of this form is the following-->
<input type="button" onClick="ValidateNoteForm();" name="addnote" id="addnote" value="Save Note" >
</form>
<!--This points to a script that has the following-->
<script type="text/javascript">
function ValidateNoteForm();{
document.form1.submit(); //This is the generic update form that dreamweaver created, no changes were made to this form.
document.AddNoteForm.submit(); //This is my form that I created, assuming this works, it should submit both forms, and then direct the post to another //form that includes only the notes and then a final submission to go back to custhome.php
}
</script>
Now here are the errors i'm getting, running through the form with $UpdateGoTo pointing to the AddFinalNote.php, the page will "submit" with no errors, the AddFinalNote.php will load with my second forms post and then I click on submit and it will load to CustHome.php. The CustHome.php will show the new note added, but won't save the update information. If I change $UpdateGoTo=""; then the page will reload, and will save the Update, but won't allow me to complete my note for obvious reasons.
Here is the code to the stand alone update page that works perfectly, once again using the wizard from dreamweaver...
<?php require_once('Connections/CustInfo_mySQL.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE custinfo SET LastName=%s, FirstName=%s, Address=%s, Address2=%s, City=%s, `State`=%s, ZipCode=%s, WHERE EnrollNumber=%s",
GetSQLValueString($_POST['LastName'], "text"),
GetSQLValueString($_POST['FirstName'], "text"),
GetSQLValueString($_POST['Address'], "text"),
GetSQLValueString($_POST['Address2'], "text"),
GetSQLValueString($_POST['City'], "text"),
GetSQLValueString($_POST['State'], "text"),
GetSQLValueString($_POST['ZipCode'], "text"),
GetSQLValueString($_POST['EnrollNumber'], "text"));
mysql_select_db($database_CustInfo_mySQL, $CustInfo_mySQL);
$Result1 = mysql_query($updateSQL, $CustInfo_mySQL) or die(mysql_error());
$updateGoTo = "ss.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
$colname_CustInfo = "-1";
if (isset($_GET['recordID'])) {
$colname_CustInfo = $_GET['recordID'];
}
mysql_select_db($database_CustInfo_mySQL, $CustInfo_mySQL);
$query_CustInfo = sprintf("SELECT * FROM custinfo WHERE EnrollNumber = %s", GetSQLValueString($colname_CustInfo, "text"));
$CustInfo = mysql_query($query_CustInfo, $CustInfo_mySQL) or die(mysql_error());
$row_CustInfo = mysql_fetch_assoc($CustInfo);
$totalRows_CustInfo = mysql_num_rows($CustInfo);
$colname_EditCust = "-1";
if (isset($_GET['recordID'])) {
$colname_EditCust = $_GET['recordID'];
}
mysql_select_db($database_CustInfo_mySQL, $CustInfo_mySQL);
$query_EditCust = sprintf("SELECT * FROM custinfo WHERE EnrollNumber = %s", GetSQLValueString($colname_EditCust, "text"));
$EditCust = mysql_query($query_EditCust, $CustInfo_mySQL) or die(mysql_error());
$row_EditCust = mysql_fetch_assoc($EditCust);
$totalRows_EditCust = mysql_num_rows($EditCust);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit Customer</title>
<style>
.CustEdit{
position:absolute;
width: 50%;
left: 25%;
}
</style>
</head>
<body>
<div class="CustEdit">
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<!--Cutting unneccessary code once again -->
<table width="50%">
<tr valign="baseline">
<td nowrap="nowrap" align="center"><input type="submit" value="Update record" /></td>
</tr>
</table>
</tr>
</table>
</table>
<input type="hidden" name="EnrollNumber" value="<?php echo $row_EditCust['EnrollNumber']; ?>" />
</form>
</div>
</body>
</html>
<?php
mysql_free_result($CustInfo);
mysql_free_result($EditCust);
?>
Now the only thing I can think of that would cause the error is the javascript that is requesting the form submission. Is it possible that when javascript requests multiple submissions the only thing that is being done is the Post variables are being passed but the request to communicate with the server is failing, and therefore not being updated? Through my testing it seems like only one (update or insert) will happen, but refuses to do both. Is there anyway I can clarify the scripting for submission? The reason i'm using javascript is so that way the client can choose the type of note and the program will decide the appropriate changes to the customers data.
On a side note another failure is that when the Post variables do pass to the AddFinalNote.php, if I do a body onload submit form, the page will ignore inserting the data and load up CustHome.php and won't show ANY changes at all, no note, and no data change. Please help! I'm at my wits end.
3
Replies
AdChoices