I'm having trouble passing information from one form to another.
The order of passing info is:
login.php => order.php => confirmorder.php
The error messages I get on confirmorder.php are (there are lots of them, but they are the same as these, for different variables):
There are 2 database tables:Notice: Undefined index: order_no in /home/michigan/www/www/confirmorder.php on line 56
Notice: Undefined variable: lendname in /home/michigan/www/www/confirmorder.php on line 61
- Login_users
- Orders
When a customer registers, he/she enters name & company information into the Login-users table on the registration page, and when they place an order the details of that go into the orders table. The database is updating properly. After a customer is registered, they access the area with a login page.
After the customer logs in, they can choose to logout or place an order. When they choose to order, the company information appears at the top of the order.php page (this works so far, but without sessions), and there is a form below for them to fill in the order information.
What I haven't been able to achieve with sessions is passing the company and order information into a confirmation page.
Where do I need to start sessions? At the login page or the order page? Currently I have started them on order.php and confirmorder.php. While I have tried several variations on the code, it currently is as follows:
Code for login.php:
Code: Select all
<?php
$login_real_path = "./";
include($login_real_path . "common.php");
include($login_real_path . 'includes/page_header.php');
$template->getFile(array(
'login' => 'login.tpl')
);
$template->addVar("login", array(
)
);
$template->parse("login");
include($login_real_path . 'includes/page_footer.php');
?>Code: Select all
<?php session_start();
header("Cache-control: private");
?>
<?php require_once('Connections/mfm.php'); ?>
<?php error_reporting(E_ALL); ?>
<?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;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "orderform")) {
$insertSQL = sprintf("INSERT INTO orders (order_date, collateral_owner, collateral_address, collateral_city, collateral_state, collateral_zip, collateral_county, collateral_twp, legal_descr, loan_no) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['order_date'], "date"),
GetSQLValueString($_POST['collateral_owner'], "text"),
GetSQLValueString($_POST['collateral_address'], "text"),
GetSQLValueString($_POST['collateral_city'], "text"),
GetSQLValueString($_POST['collateral_state'], "text"),
GetSQLValueString($_POST['collateral_zip'], "int"),
GetSQLValueString($_POST['collateral_county'], "text"),
GetSQLValueString($_POST['collateral_twp'], "text"),
GetSQLValueString($_POST['legal_descr'], "text"),
GetSQLValueString($_POST['loan_no'], "int"));
mysql_select_db($database_mfm, $mfm);
$Result1 = mysql_query($insertSQL, $mfm) or die(mysql_error());
$insertGoTo = "confirmorder.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_mfm, $mfm);
$query_rsUsers = "SELECT * FROM Login_users WHERE username = '$username'";
$rsUsers = mysql_query($query_rsUsers, $mfm) or die(mysql_error());
$row_rsUsers = mysql_fetch_assoc($rsUsers);
$totalRows_rsUsers = mysql_num_rows($rsUsers);
//mysql_select_db($database_mfm, $mfm);
//$query_rsOrders = "SELECT * FROM orders";
//$rsOrders = mysql_query($query_rsOrders, $mfm) or die(mysql_error());
//$row_rsOrders = mysql_fetch_assoc($rsOrders);
//$totalRows_rsOrders = mysql_num_rows($rsOrders);
?>
<html>
<head>
<title>Michigan Flood Maps</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="michmaps.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="50"> </td>
<td height="50"><img src="images/rowone1.gif" width="170" height="50"></td>
<td height="50"><img src="images/rowone2.gif" width="430" height="50"></td>
<td height="50"><img src="images/rowone3.gif" width="160" height="50"></td>
<td height="50"> </td>
</tr>
<tr>
<td height="70" align="left"> </td>
<td width="170" align="left"><img src="images/rowtwo1.gif" width="170" height="90"></td>
<td width="430" align="left"><img src="images/rowtwo2.gif" width="430" height="90"></td>
<td width="160" align="left"><img src="images/rowtwo3.gif" width="160" height="90"></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td width="170" align="left" valign="top" background="images/leftside_bkgd.gif"><!--#include virtual="menu.html" --></td>
<td width="430" align="left" valign="top"><p class="heading">Online Order Form </p>
<p class="navtext">Hello, <b><?php echo $row_rsUsers['f_name']; ?> <?php echo $row_rsUsers['l_name']; ?></b>. We appreciate your business! <br>
Please fill in your order details below.<br>
<input name="order_no" type="hidden" id="order_no" value="<?php echo $row_rsOrders['order_no']; ?>">
</p>
<form action="<?php echo $editFormAction; ?>" name="orderform" method="POST">
<table width="425" border="0" align="center" cellpadding="1" cellspacing="2">
<tr class="navtext">
<td width="200" class="navtext"><b class="heading">Order Date</b></td>
<td><input name="order_date" type="text" class="navtext" id="order_date">
<span class="smallbodytext"><br>
yyyy-mm-dd</span><span class="smallbodytext"> </span></td>
</tr>
<tr class="navtext">
<td colspan="2"><b class="heading">Lender Information</b></td>
</tr>
<tr valign="top" class="navtext">
<td colspan="2" class="navtext"><table width="380" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td class="navtext">
Lender ID: <?php echo $row_rsUsers['lender_id']; ?><br>
<?php echo $row_rsUsers['lender_name']; ?><br>
<?php echo $row_rsUsers['lender_address']; ?><br>
<?php echo $row_rsUsers['lender_city']; ?>,
<?php echo $row_rsUsers['lender_state']; ?>
<?php echo $row_rsUsers['lender_zip']; ?><br>
Phone: <?php echo $row_rsUsers['lender_phone']; ?><br>
Fax: <?php echo $row_rsUsers['lender_fax']; ?><br>
Email: <?php echo $row_rsUsers['email']; ?> </td>
</tr>
</table></td>
</tr>
<tr valign="top" class="navtext">
<td colspan="2"><hr width="70%" size="1" color="#666666"></td>
</tr>
<tr valign="top" class="navtext">
<td colspan="2"><b class="heading">Property Information</b></td>
</tr>
<tr valign="top" class="navtext">
<td>Loan ID # </td>
<td><input name="loan_no" type="text" class="navtext" id="loan_no"></td>
</tr>
<tr valign="top" class="navtext">
<td>Owner Name</td>
<td><input name="collateral_owner" type="text" class="navtext" id="collateral_owner"></td>
</tr>
<tr valign="top" class="navtext">
<td>Property Address </td>
<td><input name="collateral_address" type="text" class="navtext" id="collateral_address"></td>
</tr>
<tr valign="top" class="navtext">
<td>City</td>
<td><input name="collateral_city" type="text" class="navtext" id="collateral_city2"></td>
</tr>
<tr valign="top" class="navtext">
<td class="navtext">State</td>
<td>
<input name="collateral_state" type="text" class="navtext" id="collateral_state" value="MI" size="10" maxlength="10">
</td>
</tr>
<tr valign="top" class="navtext">
<td>Zip</td>
<td><input name="collateral_zip" type="text" class="navtext" id="collateral_zip" size="10" maxlength="10"></td>
</tr>
<tr valign="top" class="navtext">
<td>County</td>
<td><input name="collateral_county" type="text" class="navtext" id="collateral_county"></td>
</tr>
<tr valign="top" class="navtext">
<td>Township (if applicable)</td>
<td><input name="collateral_twp" type="text" class="navtext" id="collateral_twp"></td>
</tr>
<tr valign="top" class="navtext">
<td>Legal Description<span class="smallbodytext"> (optional)</span></td>
<td> </td>
</tr>
<tr valign="top" class="navtext">
<td colspan="2"><textarea name="legal_descr" cols="50" id="legal_descr"></textarea></td>
</tr>
<tr class="navtext">
<td> </td>
<td> </td>
</tr>
<tr class="navtext">
<td> </td>
<td> </td>
</tr>
<tr class="navtext">
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="Place_Order" type="submit" class="smallbodytext" id="Place_Order" value="Place Order">
</div></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="orderform">
</form> <p class="navtext"> </p>
</td>
<td width="160" align="center" valign="top" background="images/rightside_bkgd.gif"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="60"><img src="images/rightside_topbkgd.gif" width="160" height="60"></td>
</tr>
<tr>
<td><table width="150" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30"> </td>
<td><div align="center" class="smallbodytext">
<p class="navtext"> </p>
<p><br>
</p>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td height="40"> </td>
<td width="170"><img src="images/rowthree1.gif" width="170" height="40"></td>
<td width="430"> </td>
<td width="160" background="images/rightside_bkgd.gif"> </td>
<td> </td>
</tr>
<tr>
<td height="70"> </td>
<td width="170"><img src="images/rowfour1.gif" width="170" height="70"></td>
<td width="430" align="left" valign="middle" background="images/rowfour2.gif"><table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="270"><div align="center" class="smallbodytext">Copyright © 2004 Michigan Flood Maps </div></td>
<td><div align="center"><span class="smallbodytext">Site by <a href="http://www.harborspringswebdesign.com" target="_blank">HSWD </a></span></div></td>
</tr>
</table></td>
<td width="160" background="images/rowfour3.gif"> </td>
<td> </td>
</tr>
</table>
</body>
</html>
<?php
//mysql_free_result($rsLenders);
mysql_free_result($rsUsers);
//mysql_free_result($rsOrders);
?>Code: Select all
<?php session_start();
header("Cache-control: private");
$_SESSION['lender_name'] = $lendname;
$_SESSION['loan_no'] = $loanno;
?>
<?php require_once('Connections/mfm.php'); ?>
<?php error_reporting(E_ALL); ?>
<?php
mysql_select_db($database_mfm, $mfm);
$query_rsOrders = "SELECT * FROM orders WHERE order_no = '$order_no' ";
$rsOrders = mysql_query($query_rsOrders, $mfm) or die(mysql_error());
$row_rsOrders = mysql_fetch_assoc($rsOrders);
$totalRows_rsOrders = mysql_num_rows($rsOrders);
mysql_select_db($database_mfm, $mfm);
$query_rsLenders = "SELECT * FROM Login_users WHERE userid = 'userid' ";
$rsLenders = mysql_query($query_rsLenders, $mfm) or die(mysql_error());
$row_rsLenders = mysql_fetch_assoc($rsLenders);
$totalRows_rsLenders = mysql_num_rows($rsLenders);
?>
<html>
<head>
<title>Michigan Flood Maps</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="michmaps.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="50"> </td>
<td height="50"><img src="images/rowone1.gif" width="170" height="50"></td>
<td height="50"><img src="images/rowone2.gif" width="430" height="50"></td>
<td height="50"><img src="images/rowone3.gif" width="160" height="50"></td>
<td height="50"> </td>
</tr>
<tr>
<td height="70" align="left"> </td>
<td width="170" align="left"><img src="images/rowtwo1.gif" width="170" height="90"></td>
<td width="430" align="left"><img src="images/rowtwo2.gif" width="430" height="90"></td>
<td width="160" align="left"><img src="images/rowtwo3.gif" width="160" height="90"></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td width="170" align="left" valign="top" background="images/leftside_bkgd.gif"><!--#include virtual="menu.html" --></td>
<td width="430" align="left" valign="top"><p class="heading">Confirming Your Order</p>
<form name="confirmorder" method="GET">
<table width="425" border="0" align="center" cellpadding="1" cellspacing="2">
<tr class="navtext">
<td height="25" class="navtext"><b class="heading">Order Date </b></td>
<td><?php echo date('F d, Y',$_POST['order_date']); ?></td>
</tr>
<tr class="navtext">
<td height="25" class="navtext"><b class="heading">Order Number</b></td>
<td><?php echo $_POST['order_no'];
?></td>
</tr>
<tr class="navtext">
<td width="40%" valign="top" class="navtext"><b class="heading">Lender Information</b></td>
<td><p><?php echo $lendname;?><br>
<?php echo $row_rsLenders['lender_address']; ?><br>
<?php echo $row_rsLenders['lender_city']; ?>, <?php echo $row_rsLenders['lender_state']; ?> <?php echo $row_rsLenders['lender_zip']; ?><br>
<?php echo $row_rsLenders['lender_phone']; ?></p>
<p> </p></td>
</tr>
<tr class="navtext">
<td valign="top" class="navtext"><b class="heading">Property Information </b></td>
<td><?php echo $loanno; ?><br>
<?php echo $_POST['collateral_owner']; ?><br>
<?php echo $_POST['collateral_address']; ?><br>
<?php echo $_POST['collateral_city']; ?>, <?php echo $_POST['collateral_state']; ?> <?php echo $_POST['collateral_zip']; ?><br>
<?php echo $_POST['county']; ?><br>
<?php echo $_POST['collateral_twp']; ?><br>
<?php echo $_POST['legal_descr']; ?></td>
</tr>
<tr class="navtext">
<td class="navtext"> </td>
<td></td>
</tr>
<tr class="navtext">
<td class="navtext"> </td>
<td></td>
</tr>
<tr class="navtext">
<td class="navtext"> </td>
<td></td>
</tr>
</table>
</form> <p class="navtext"> </p>
</td>
<td width="160" align="center" valign="top" background="images/rightside_bkgd.gif"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="60"><img src="images/rightside_topbkgd.gif" width="160" height="60"></td>
</tr>
<tr>
<td><table width="150" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30"> </td>
<td><div align="center" class="smallbodytext">
<p class="navtext"> </p>
<p><br>
</p>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td height="40"> </td>
<td width="170"><img src="images/rowthree1.gif" width="170" height="40"></td>
<td width="430"> </td>
<td width="160" background="images/rightside_bkgd.gif"> </td>
<td> </td>
</tr>
<tr>
<td height="70"> </td>
<td width="170"><img src="images/rowfour1.gif" width="170" height="70"></td>
<td width="430" align="left" valign="middle" background="images/rowfour2.gif"><table width="430" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="270"><div align="center" class="smallbodytext">Copyright © 2004 Michigan Flood Maps </div></td>
<td><div align="center"><span class="smallbodytext">Site by <a href="http://www.harborspringswebdesign.com" target="_blank">HSWD </a></span></div></td>
</tr>
</table></td>
<td width="160" background="images/rowfour3.gif"> </td>
<td> </td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsOrders);
mysql_free_result($rsLenders);
?>