probs displayin items in shopping cart

Thu, 24 Apr 2003 04:30:17 -0700

Hi, the following code is supposed to display the contents of the shopping cart in a table, however it is not working. all i am getting as output is the header 'your shopping basket'. before i added in the code which gets the unit price, it was all working.

The code is:-
#!/usr/local/bin/php
<?php
session_start();

//connecting to database
$conn = mysql_connect("mysql", "***", "***");

//selecting the database
mysql_select_db("***", $conn);

$display_block = "<h3>Your Shopping Basket</h3>";

//check for basket items based on user session id
$get_basket = "SELECT id, sel_frame_id, sel_frame_size, sel_quantity, date_added FROM order_track WHERE session_id = '$PHPSESSID'";

$get_basket_res = mysql_query($get_basket) or die(mysql_error());

if (mysql_num_rows($get_basket_res) < 1) {
//print message
$display_block .= "<p>You have no items in your basket.
Please <a href=\"frames.cgi\">continue to shop</a>!</p>";

}else{

$get_unit_price = "SELECT UnitPrice FROM main WHERE frame_id = '".$sel_frame_id."' AND size = '".$sel_frame_size."'";

$get_unit_price_res = mysql_query($get_unit_price) or die(mysql_error());

if (mysql_num_rows($get_unit_price_res) == 1 ){

//get info and build table
$display_block .= "
<table celpadding=3 cellspacing=2 border=1 width=98% >

<tr>
<th>Frame ID</th>
<th>Size</th>
<th>Unit Price</th>
<th>Quantity</th>
<th>Total Price</th>
<th>Action</th>
</tr>";

while ($basket = mysql_fetch_array($get_basket_res)) {
$id = $basket['id'];
$sel_frame_id = $basket['sel_frame_id'];
$sel_frame_size = $basket['sel_frame_size'];
$sel_quantity = $basket['sel_quantity'];
$unit_price = $basket['unit_price'];

$total_item_price = sprintf("%.02f", $unit_price * $sel_quantity);

$display_block .="<tr>
<td align=center>$sel_frame_id <br></td>
<td align=center>$sel_frame_size <br></td>
<td align=center>$unit_price <br></td>
<td align=center>$sel_quantity <br></td>
<td align=center>$total_item_price</td>
<td align=center><a href=\"removefrombasket.php?id=$id\">remove</a></t d>
</tr>";

}

$display_block .= "</table>";
}
}

?>
<html>
<body bgcolor="#FFFF99">
<h1>P & M TRADING & SONS</h1>

<style type = "text/css">
h1 {text-align: center;
font-size: 36pt}
</style>
<? print $display_block; ?>
</body>
</html>

Re: probs displayin items in shopping cart

Tue, 06 May 2003 16:31:38 -0700

I'm not sure where you get all your syntax from but I think there is a problem with your second sql statement specified as:
$get_unit_price = "SELECT UnitPrice FROM main WHERE frame_id = '".$sel_frame_id."' AND size = '".$sel_frame_size."'";
I'm not sure that sytax such as '".$sel_frame_id."' is valid. It should be '$sel_frame_id'. Also, maybe even more important, you never defined the $sel_frame_id variable in your source code. Just because it was a field name defined in a previous sql statement does not mean it is defined at the php level. You will need to do a mysql_fetch_array() of your previous sql call and then define $sel_frame_id using the fetched array contents such as:
$sel_frame_id = $basket['sel_frame_id'];

As your $get_unit_price sql statement currently stands I believe it will always return zero rows. Since all the rest of your code then depends on the test: if (mysql_num_rows($get_unit_price_res) == 1 ) none of the rest of the code will be executed.

: Hi, the following code is supposed to display the contents of the shopping cart in a table, however it is not working. all i am getting as output is the header 'your shopping basket'. before i added in the code which gets the unit price, it was all working.
:
: The code is:-
: #!/usr/local/bin/php
: <?php
: session_start();
:
: //connecting to database
: $conn = mysql_connect("mysql", "***", "***");
:
: //selecting the database
: mysql_select_db("***", $conn);
:
: $display_block = "<h3>Your Shopping Basket</h3>";
:
: //check for basket items based on user session id
: $get_basket = "SELECT id, sel_frame_id, sel_frame_size, sel_quantity, date_added FROM order_track WHERE session_id = '$PHPSESSID'";
:
: $get_basket_res = mysql_query($get_basket) or die(mysql_error());
:
: if (mysql_num_rows($get_basket_res) < 1) {
: //print message
: $display_block .= "<p>You have no items in your basket.
: Please <a href=\"frames.cgi\">continue to shop</a>!</p>";
:
: }else{
:
: $get_unit_price = "SELECT UnitPrice FROM main WHERE frame_id = '".$sel_frame_id."' AND size = '".$sel_frame_size."'";
:
: $get_unit_price_res = mysql_query($get_unit_price) or die(mysql_error());
:
:
: if (mysql_num_rows($get_unit_price_res) == 1 ){
:
: //get info and build table
: $display_block .= "
: <table celpadding=3 cellspacing=2 border=1 width=98% >
:
: <tr>
: <th>Frame ID</th>
: <th>Size</th>
: <th>Unit Price</th>
: <th>Quantity</th>
: <th>Total Price</th>
: <th>Action</th>
: </tr>";
:
: while ($basket = mysql_fetch_array($get_basket_res)) {
: $id = $basket['id'];
: $sel_frame_id = $basket['sel_frame_id'];
: $sel_frame_size = $basket['sel_frame_size'];
: $sel_quantity = $basket['sel_quantity'];
: $unit_price = $basket['unit_price'];
:
: $total_item_price = sprintf("%.02f", $unit_price * $sel_quantity);
:
: $display_block .="<tr>
: <td align=center>$sel_frame_id </td>
: <td align=center>$sel_frame_size </td>
: <td align=center>$unit_price </td>
: <td align=center>$sel_quantity </td>
: <td align=center>$total_item_price</td>
: <td align=center><a href=\"removefrombasket.php?id=$id\">remove</a></t d>
: </tr>";
:
: }
:
: $display_block .= "</table>";
: }
: }
:
: ?>
: <html>
: <body bgcolor="#FFFF99">
: <h1>P & M TRADING & SONS</h1>
:
: <style type = "text/css">
: h1 {text-align: center;
: font-size: 36pt}
: </style>
: <? print $display_block; ?>
: </body>
: </html>
:
:
:

'probs displayin items in shopping cart' Thread RSS Feed

probs displayin items in shopping cart

Re: probs displayin items in shopping cart