June 22nd, 2003, 04:32 AM
|
|
Junior Member
|
|
Join Date: Jun 2003
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Hi,
Dunno what acture problem on you script....sorry can't help..
anyway, i post the checkout script here for you, and hope this will help..
PHP Code:
<?php
include("db.php");
global $dbServer, $dbUser, $dbPass, $dbName;
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
$result = mysql_query("select * from cart inner join items on cart.itemId
= items.itemId where cart.cookieId = '". GetCartId() . "' order by
items.itemName asc");
?>
<html><body>
<?php
$row = mysql_fetch_assoc($result);
$numRows = mysql_num_rows($result);
if($numRows == 0)
{
echo "Your shopping cart is currently empty.";
}
else
echo "Here's is your order status...<br>";
{
do
{
?>
<table width="600" border="1"><tr><td>Item Name</td><td>Qty</td><td>Price</td></tr>
<tr> <td><?php echo $row["itemName"]; ?></td>
<td><?php echo $row["qty"]; ?></td>
<td><?php echo number_format($row["itemPrice"], 2, ".", ","); ?></td></tr></table>
<?php
} while($row = mysql_fetch_assoc($result));
}
mysql_query("delete from cart where cart.cookieId = '". GetCartId() . "'");
?>
<form name="form1" method="post" action="">
<table width="500">
<tr>
<td width="25%">Name</td>
<td width="75%"> </td>
</tr>
<tr>
<td>Email</td>
<td> </td>
</tr>
<tr>
<td>Address</td>
<td> </td>
</tr>
<tr>
<td>City</td>
<td> </td>
</tr>
<tr>
<td>Zip</td>
<td> </td>
</tr>
<tr>
<td>State</td>
<td> </td>
</tr>
<tr>
<td>Country</td>
<td> </td>
</tr>
<tr>
<td>Telphone</td>
<td> </td>
</tr>
</table>
</form>
<p><a href="products.php">Back</a></p>
</body></html>
And so sorry i hav'nt complete the buyer form to write to the database...........and one important thing is i'm not a expert. is great if you could modify and let the script run better...
Thank you,
Kelvin.
|
Dev Articles Community Forums Sponsor:
Help Please!!!!!!!!!!!!!!
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
