basket contents display doesnt update

[SeenGee]

Right, i've got a functions page that i use to create a page template for my site, a function for the top and a function for the bottom of the page. In between the functions is a div tag which the body of the site loads into. Within the top function i call an external script, basketStatus.php, that queries the database to see how many items the user(recognised by session_id) has in their basket:

<?
$sessionid=session_id();
include 'db.php';

$bsql = "SELECT * from `basket` where `sessionid`='$sessionid' ";
$doCheck=mysql_query($bsql);
$rowsFound=mysql_num_rows($doCheck);

if ($rowsFound == 1)
{
	echo 'There is 1 item in your basket';
}
else if ($rowsFound > 1)
{
	echo 'There are '.$rowsFound.' '.' items in your basket'; 
}
else
{
	echo 'basket is empty';
}
?>

The problem i'm having though is this, when u select to add and item from products.php and you are taken to basket.php, although your basket shows the new item, the display above still does not recognise it is there, e.g. there will be 3 rows with 3 items in the basket but in the display section above it will continue to say "you have 2 items" until you navigate away, as soon as you move page the display updates.

Any ideas?

[batman]

Could you provide a URL.

[SeenGee]

sorry man, still on Localhost at the moment. anything else you need to know?

[batman]

Can you paste the code to the products.php, basket.php, and basketstatus.php pages?

[SeenGee]

basketstatus.php is at the top,

basket.php:

<?
session_start();
$sessionid=session_id();

if (isset($_SESSION['username'])) {
	$accepted='4';
}
else {
	$accepted='0';
}

require "functions.php";
include "db.php";
$pagename='Your Basket';
pagetop($pagename, $accepted, $username);

$action=$_GET['action'];
$productid=$_GET['id'];

if ($action!=''){
	if ($action=='add'){

	$findsql="SELECT * from `basket` where productid='$productid' and `sessionid`='$sessionid'";
	$dofind=mysql_query($findsql);
	$rowsfound=mysql_num_rows($dofind);

	if ($rowsfound>=1) {
		echo 'This item was already found in your basket.  To add more of the same item, please use the \'edit\' button within the basket itself.';

		// update basket code:
		$findcontent="SELECT basket.sessionid, basket.qty, basket.productid, products.productid, products.code, products.price, products.brand, products.rrp, products.productsort from basket, products where basket.sessionid='$sessionid' and products.productid=basket.productid";
		$getcontent=mysql_query($findcontent);
		$contentrows=mysql_num_rows($getcontent);
		if ($contentrows>0) {
			echo '
			<table>
				<tr>
					<td class="basketHeader">
						Code
					</td>
					<td class="basketHeader">
						Price
					</td>
					<td class="basketHeader">
						Qty
					</td>
					<td class="basketHeader">
						Total
					</td>
					<td class="basketHeader">
						Edit
					</td>
				</tr>
			';
			while ($contentrow = mysql_fetch_array($getcontent))
				{				
					$code= $contentrow["code"];
					$price= $contentrow["price"];
					$qty= $contentrow["qty"];
					$id= $contentrow["productid"];
					$total=$qty*$price;
					$grandtotal+=$total;

					echo '
					<tr>
						<td>
							'.$code.'
						</td>
						<td>
							'.$price.'
						</td>
						<form name="update" method="post" action="basket.php?action=edit">';

						if ($id==$productid) {
						echo '
						<td>
						<input type="text" name="newqty" value='.$qty.' maxlength="3" size="3">
						</td>
						';
						}
						else {
							echo '
							<td>
							'.$qty.'
							</td>
							';
						}

						echo'
						<td>
							'.$total.'
						</td>
						<td>
							<input type="submit" value="update" name="update">
						</td>
						<input type="hidden" name="productid" value="'.$id.'">
						</form>
					</tr>
					';
				}
				echo '
					<tr>
						<td>
							&nbsp;
						</td>
					</tr>
					<tr>
						<td colspan="3" align="left">
							Grand Total
						</td>
						<td colspan="" align="left">
							'.$grandtotal.'
						</td>
						<td>
							&nbsp;
						</td>
					</tr>
					<tr>
						<td colspan="10" align="right">
							<a href="checkout.php">go to checkout</a>
						</td>
					</tr>
				</table>';
		}

		else {
			echo 'Your basket is currently empty. <a href="products.php">Click here to view our products.</a>';
		}
		// end update basket code

	}
	else {
	$addsql="INSERT into `basket` (`sessionid`, `productid`, `qty`) values ('$sessionid','$productid','1')";
	$doadd=mysql_query($addsql);
	include "showbasket.php";
	}

}
else if ($action=='edit') {
	if (isset($_POST['newqty'])) {
		$newqty=$_POST['newqty'];
		$productid=$_POST['productid'];

		/*
		$findcontent="SELECT basket.sessionid, basket.qty, basket.productid, products.productid, products.code, products.price, products.brand, products.rrp, products.productsort from basket, products where basket.sessionid='$sessionid' and products.productid=basket.productid";
		$getcontent=mysql_query($findcontent);
		$contentrows=mysql_num_rows($getcontent);
		if ($contentrows>0) {
			while ($contentrow = mysql_fetch_array($getcontent))
				{				
					$code= $contentrow["code"];
					$price= $contentrow["price"];
					$qty= $contentrow["qty"];
				}
		}
		else {}
		*/
		$updatesql="UPDATE `basket` set `qty`='$newqty' where `sessionid`='$sessionid' and `productid`='$productid'";
		$doupdate=mysql_query($updatesql);
		include "showbasket.php";
	}
	else {
		$productidrequired=$_GET['productid'];

		// update basket code:
		$findcontent="SELECT basket.sessionid, basket.qty, basket.productid, products.productid, products.code, products.price, products.brand, products.rrp, products.productsort from basket, products where basket.sessionid='$sessionid' and products.productid=basket.productid";
		$getcontent=mysql_query($findcontent);
		$contentrows=mysql_num_rows($getcontent);
		if ($contentrows>0) {
			echo '
			<table>
				<tr>
					<td class="basketHeader">
						Code
					</td>
					<td class="basketHeader">
						Price
					</td>
					<td class="basketHeader">
						Qty
					</td>
					<td class="basketHeader">
						Total
					</td>
					<td class="basketHeader">
						Edit
					</td>
				</tr>
			';
			while ($contentrow = mysql_fetch_array($getcontent))
				{				
					$code= $contentrow["code"];
					$price= $contentrow["price"];
					$qty= $contentrow["qty"];
					$id= $contentrow["productid"];
					$total=$qty*$price;
					$grandtotal+=$total;

					echo '
					<tr>
						<td>
							'.$code.'
						</td>
						<td>
							'.$price.'
						</td>
						<form name="update" method="post" action="basket.php?action=edit">';

						if ($id==$productidrequired) {
						echo '
						<td>
						<input type="text" name="newqty" value='.$qty.' maxlength="3" size="3">
						</td>
						';
						}
						else {
							echo '
							<td>
							'.$qty.'
							</td>
							';
						}

						echo'
						<td>
							'.$total.'
						</td>
						<td>
							<input type="submit" value="update" name="update">
						</td>
						<input type="hidden" name="productid" value="'.$id.'">
						</form>
					</tr>
					';
				}
				echo '
					<tr>
						<td>
							&nbsp;
						</td>
					</tr>
					<tr>
						<td colspan="3" align="left">
							Grand Total
						</td>
						<td colspan="" align="left">
							'.$grandtotal.'
						</td>
						<td>
							&nbsp;
						</td>
					</tr>
					<tr>
						<td colspan="10" align="right">
							<a href="checkout.php">go to checkout</a>
						</td>
					</tr>
				</table>';
		}

		else {
			echo 'Your basket is currently empty. <a href="products.php">Click here to view our products.</a>';
		}
		// end update basket code

	}

}
else if ($action=='delete') {
	$productid=$_GET['productid'];
	$deletesql="delete from `basket` where `sessionid`='$sessionid' and `productid`='$productid'";
	$dodelete=mysql_query($deletesql);
	include "showbasket.php";
}
else {}
}

else {
	include "showbasket.php";
	}

pagebottom();
?>

[SeenGee]

products.php:

<?
session_start();
require "functions.php";
include "db.php";
if (isset($_SESSION['username'])) {
	$accepted='4';
}
else {
	$accepted='0';
}

$brand= $_GET['brand'];

if ($brand!='') {
	$pagename=''.$brand.' Products';
	$extra = "and `brand` = '$brand'";
}
else {
	$pagename = 'Products';
	$extra='';
}

pagetop($pagename, $accepted, $username);

if (isset($brand)) {		
		echo '
		<div align="center"><img src="logos/'.$brand.'.jpg" border="0" height="75" width="150"></div>
		<table border="0" class=mainBox width="100%">
		';

		// DISPLAY ANY INK PRODUCTS FOUND (IF ANY)

		$sql="SELECT * FROM `products` WHERE `category` = 'Ink'".$extra."  and `view`='on'";
		$doinksql=mysql_query($sql);
		$numink=mysql_num_rows($doinksql);
		if ($numink>0) {
			echo '
			<tr>
				<td align="center" width="10%">
					Code
				</td>
				<td width="30">&nbsp;</td>
				<td>
					Printer
				</td>
				<td align="center">
					RRP
				</td>
				<td align="center">
					Our Price
				</td>
				<td align="center">
					You Save
				</td>
				<td align="center">
					Qty
				</td>
				<td></td>
			</tr>

			';
			while ($inkrow = mysql_fetch_object($doinksql))
					{

						$productid=$inkrow->productid;
						$rrp=$inkrow->rrp;
						$price=$inkrow->price;
						$imagename=$inkrow->type;
						$image='<img src="icons/'.$imagename.'.gif" alt="'.$imagename.'" />';
						$class=$inkrow->availability;
						echo '<tr class="'.$class.'">';

						?>
							<td>
								<? echo $inkrow->code; ?>
							</td>
							<td align="center">
								<? echo  $image; ?>
							</td>
							<td>
								<? echo $inkrow->printer; ?>
							</td>
							<td align="center">
								<? echo $rrp; ?>
							</td>
							<td align="center">
								<? echo $price; ?>
							</td>
							<td align="center">
								<?

								$portion=($price/$rrp);
								$percentage=round((100*(1-$portion)), 1);
								echo ''.$percentage.'%<br />';							

								 ?>
							</td>
							<td align="center">
								<? 
								if ($class=='out') {
									echo '<a href="outofstock.php" title="Out of Stock.  Click for more info">*</a>';
								}
								else {
									echo '<a href="basket.php?action=add&id='.$productid.'">add</a>'; 
								}

								?>
							</td>					
						</tr>

						<?
					}
		}
		else {
			echo '';
		}

		// DISPLAY PAPER PRODUCTS (IF ANY)

		$papersql="SELECT * FROM `products` WHERE `category` = 'Paper'".$extra."  and `view`='on'";
		$dopapersql=mysql_query($papersql);
		$numpaper=mysql_num_rows($dopapersql);
		if ($numpaper>0) {
			echo '
			<tr>
				<td colspan="7">
					Paper
				</td>
			</tr>
			<tr>
				<td align="center" width="10%">
					Code
				</td>
				<td width="30">&nbsp;</td>
				<td>
					Description
				</td>
				<td align="center">
					RRP
				</td>
				<td align="center">
					Our Price
				</td>
				<td align="center">
					You Save
				</td>
				<td></td>
			</tr>

			';
			while ($paperrow = mysql_fetch_object($dopapersql))
					{

						$productid=$paperrow->productid;
						$rrp=$paperrow->rrp;
						$price=$paperrow->price;
						$imagename=$paperrow->type;
						$image='<img src="icons/'.$imagename.'.gif" alt="'.$imagename.'" />';
						$class=$paperrow->availability;
						echo '<tr class="'.$class.'">';
						?>

							<td>
								<? echo $paperrow->code; ?>
							</td>
							<td align="center">
								<? echo  $image; ?>
							</td>
							<td>
								<? echo $paperrow->productsort; ?>
							</td>
							<td align="center">
								<? echo $rrp; ?>
							</td>
							<td align="center">
								<? echo $price; ?>
							</td>
							<td align="center">
								<?

								$portion=($price/$rrp);
								$percentage=round((100*(1-$portion)), 1);
								echo ''.$percentage.'%<br />';	

								 ?>
							</td>
							<td align="center">
								<? 
								if ($class=='out') {
									echo '<a href="outofstock.php" title="Out of Stock.  Click for more info">*</a>';
								}
								else {
									echo '<a href="basket.php?action=add&id='.$productid.'">add</a>'; 
								}

								?>
							</td>					
						</tr>

						<?
					}
		}
		else {
			echo '';
		}			
		echo '</table>';

}
else {
	echo '
			Welcome to Products<br />Select a Brand name.
			<table width="500"  border="0" height="460" align="center">
			  <tr>
				<td><div align="center"><a href="products.php?brand=brother"><img src="logos/brother.jpg" width="150" height="75" border="0"></a></div></td>
				<td><div align="center"><a href="products.php?brand=canon"><img src="logos/canon.jpg" width="150" height="75" border="0"></a></div></td>
			  </tr>
			  <tr>
				<td><div align="center"><a href="products.php?brand=epson"><img src="logos/epson.jpg" width="150" height="75" border="0"></a></div></td>
				<td><div align="center"><a href="products.php?brand=Hewlett-Packard"><img src="logos/Hewlett-Packard.jpg" width="150" height="75" border="0"></a></div></td>
			  </tr>
			  <tr>
				<td><div align="center"><a href="products.php?brand=lexmark"><img src="logos/lexmark.jpg" width="150" height="75" border="0"></a></div></td>
				<td><div align="center"><a href="products.php?brand=oki"><img src="logos/OKI.jpg" width="150" height="75" border="0"></a></div></td>
			  </tr>
			  <tr>
				<td><div align="center"><a href="products.php?brand=panasonic"><img src="logos/panasonic.jpg" width="150" height="75" border="0"></a></div></td>
				<td><div align="center"><a href="products.php?brand=xerox"><img src="logos/xerox.jpg" width="150" height="75" border="0"></a></div></td>
			  </tr>
			</table>
		';
}

pagebottom();
?>

[batman]

Ok...so I understand the error its giving you when you try and add a product. Does it give you the same error when you try and edit the basket?

[SeenGee]

as soon as i click the edit button(which changes the quantity to an input type="text"), the basket display updates. Dont have a 'remove from basket button yet, in the process of adding it now.

[SeenGee]

yeah, its the same thing when i remove items from the basket

[batman]

It's kinda hard to tell whats wrong here. Your saying that everything updates just fine except the quantity doesnt update until you change pages? How long do you think until you can give a URL?

[SeenGee]

thats exactly it, everything works except that the data from basketStatus.php is not updated until the page has changed. gonna be at least 2 or 3 days before it goes online tho i'm afraid. Is there any php function that recognises url changes that i could use to explicitly tell the sql query to run, i was thinking of setting some kind of timer against the sql query but this would just slow things down, its just one of those strange problems i suppose.

[batman]

I think what your problem is is that you are trying to do the query for the basket status, before you update it. So ofcourse its gonna give you the old status until you refresh it. I think what you should try is... make sure you do all the updating to the database before the basket status query is done.

If this doesn't make any sense let me know,

[SeenGee]

makes perfect sense, just got no idea how i can cause it to check its status after the sql. any ideas?

[batman]

What I would suggest would take some work on your part. What you would need to do is make all the queries that update the database into a seperate page. So like when you add an item or update an item, it should go to update.php then in that page you would want to have an include to the basket page. In short make it to where the updateing stuff doesnt run off the same page, make it it's own.

[SeenGee]

seems that might be the only option, thanks for taking the time to help.

[batman]

No problem bro. Let me know what you come up with and if it works.