I have the following form in a page called "View my Order" and I want when the user places his order in a page called "Place my Order" to show this on the View my Order and also to show the data retrieved from the db.Does anybody know?
Thank you in advance for your response.
<form name="ViewOrder" id="ViewOrder" method="POST" action="<? echo $PHP_SELF; ?>">
<p> </p>
<table width="100%" border="2" cellpadding="5" cellspacing="15" bgcolor="#DDDDDD">
<tr>
<td width="39%">Product Name :
</td>
<td width="61%">
<?php
$query = mysql_query("SELECT ProductName FROM products", $conn) or die('Query failed: ' . mysql_error());;
$query_row = mysql_fetch_array($query);
echo ($query_row[ProductName]);
?>
</td>
</tr>
<tr>
<td>Category Name :
</td>
<td>
<?php
$query = mysql_query("SELECT categoryname FROM categories", $conn) or die('Query failed: ' . mysql_error());;
$query_row = mysql_fetch_array($query);
echo ($query_row[categoryname]);
?>
</td>
</tr>
<tr>
<td>Insurance:</td>
<td>
<?php
$query = mysql_query("SELECT InsuranceType FROM insurancecharges", $conn) or die('Query failed: ' . mysql_error());;
$query_row = mysql_fetch_array($query);
echo ($query_row[InsuranceType]);
?>
</td>
</tr>
<tr>
<td>Packaging Type: </td>
<td>
<?php
$query = mysql_query("SELECT PackagingType FROM packaging", $conn) or die('Query failed: ' . mysql_error());;
$query_row = mysql_fetch_array($query);
echo ($query_row[PackagingType]);
?>
</td>
</tr>
<tr>
<td><p>Product Units : </p></td>
<td>
<?php
$ProductUnits= $_POST[ProductUnits]';
?>
</td>
</tr>
<tr>
<td>Order ID :</td>
<td>
<?php
$query = mysql_query("SELECT OrderID FROM orders", $conn) or die('Query failed: ' . mysql_error());;
$query_row = mysql_fetch_array($query);
echo ($query_row[OrderID]);
?>
</td>
</tr>
<tr>
<td>Kilometer Distance: </td>
<td>
<?php
$query = mysql_query("SELECT TransportationUnit FROM transportationcharges", $conn) or die('Query failed: ' . mysql_error());;
$query_row = mysql_fetch_array($query);
echo ($query_row[TransportationUnit ]);
?>
</td>
</tr>
<tr>
<td>Order Date :</td>
<td>
<?php
date_default_timezone_set('UTC');
echo date('l dS \of F Y h:i:s A');
?>
</td>
</tr>
<tr>
<td>Shipper Name : </td>
<td>
<?php
$query = mysql_query("SELECT ShipperName FROM shippers", $conn) or die('Query failed: ' . mysql_error());;
$query_row = mysql_fetch_array($query);
echo ($query_row[ShipperName]);
?>
</td>
</tr>
<tr>
<td>Estimated Time of Arrival : </td>
<td>
<?php
$order_date = date('Y-m-d');
$ETA_date = date('Y-m-d', strtotime($order_date . "+ 50 days"));
echo $ETA_date;
?>
</td>
</tr>
<tr>
<td>Cancel Date : </td>
<td> </td>
</tr>
<tr>
<td>Estimated Time of Backorder : </td>
<td> </td>
</tr>
<tr>
<td>Price of Grade: </td>
<td>
</td>
</tr>
</table>
<p> </p>
</form>
