I want to be able to select a favorite product from a shopping cart. This is my code (it is from IBKCart modified):
<?php
function ShowCartWtPrd(){
global $fav_id;
$itemClass = ($this->getCartItems() > 2) ? "insideContMainArea2": "insideContMainArea";
$plural = ($this->getCartItems() > 1)? 's': '' ;
if (isset($_SESSION['favourites']) && !$_SESSION['favourites'] == "False") {
$this->updFavourites();
unset($_SESSION['favourites']);
}
$Out =
'<div id="theOverlay">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="20%"><div align="right"><img name="" src="./imgs/wait.gif" width="32" height="32" alt="" /></div></td>
<td width="50%"><div align="left"> <strong>Updating...Please Wait</strong> </div></td>
</tr>
</table>
</div>
<div id="Cart_Container">
<div id="Car_top_bg"></div>
<div id="Cart_middle">
<div id="'. $itemClass. '">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr bgcolor="#E6EDD2">
<td width="55%" height="21" bgcolor="#E6EDD2"><div align="center"><strong>Item Description </strong>
</div>
</td>
<td width="11%"><div align="center"><strong>Qty</strong></div></td>
<td width="11%"><div align="center"><strong>Prc/Qty</strong></div></td>
<td width="11%"><div align="center"><strong>Fav</strong></div></td>
<td width="11%"><div align="center"><strong>Del</strong></div></td>
</tr>' ;
$cnt=1;
foreach($this->cart as $itemId=>$Qty){
++$cnt;
$ans = fmod($cnt,2);
if($ans == 0){$bg = '#ECF9FF';}else{$bg='';};
$ProdDts = $this->getProdDts($itemId);
$this->totAmt += $ProdDts[$this->prodPrc] * $Qty ;
$fav_id = $ProdDts[$this->prod_id];
$Out .= '<tr bgcolor="'. $bg .'">
<td valign="top">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td width="60%" valign="top">
' . $ProdDts[$this->prodNm] .'
<br />
</td>
</tr>
</table>
</td>
<td valign="top"><div align="center">' . $Qty .'</div></td>
<td valign="top">' . $ProdDts[$this->prodPrc] .'</td>
<td valign="top">
<div align="center">
<a href="#?favourites=true">
<img src="./imgs/fav_trnsp_icon.png"
alt="Add to favourites" width="16" height="16" border="0"
title="Add to favourites" name="favourites"
onclick="document.write('. $this->updFavourites() .');"
/>
</a>
</div>
</td>
<td valign="top">
<div align="center">
<a href="#"
onclick="doCart(\'DelItem\', \'' . $ProdDts[$this->prodId] . '\', 0, \' \', \'Small\');">
<img src="./imgs/cart_remove.png" alt="Delete Item" width="16" height="16" border="0" title="Delete Item"/></a>
</div>
</td>
</tr>
<tr>
<td colspan="4" valign="top"><div class="clear"></div></td>
</tr>';
}
$Out .= '
</table>
</div>
</div>
<div id="Cart_gtotal">
<div class="theCont">Grand Total => '. $this->ShowCurSymbol() .' '. $this->toMoney($this->totAmt) . '</div>
</div>
</div>' ;
echo $Out;
}
function updFavourites() {
global $username;
global $password;
global $database;
global $fav_id;
$conn = mysqli_connect("localhost",$username,$password, $database);
// Check connection
if (mysqli_connect_errno($conn))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// mysql_connect("localhost","$username","$password") or die("Error: ".mysqlerror());
// mysql_select_db("$database");
if (isset($_SESSION['fav_id'])) {
$fav_id = $_SESSION['fav_id'];
}
$dealer_id = $_SESSION['dealer_id'];
$ProdDts = $this->getProdDts($fav_id);
$part_id = $ProdDts[$this->prod_id];
$sql = "INSERT INTO favourites VALUES (0,'$dealer_id','$part_id')";
$result = $conn->query($sql) or exit("Error code ({$conn->errno}): {$conn->error}");
/* close up */
//$conn->close();
}
?>
}
If I step through the code with a debugger, I get as far as the line
$Out .= '<tr bgcolor="'. $bg .'">
and it goes straight into the updFavourites()
function, Which I wanted to do on the onclick event "favourites"
near the end of the ShowCartWtPrd
function. I have been trying to debug this but can't see what is causing it. Perhaps someone has an idea.