remove item from paypal shop

[rutin]

Hi there,

I need the help with my shop.
The problem is !

If item added to catalog, is fine. I go back to main categories.
I add same item, now i have two same items.

I click on the remove button, script removes both items.

How can i have to remove only one iitem wchich is selected ?

Please help, here is my script.

Thank you....

<?php
  session_start();
 include "vars.php";

<?

<?php


// sql connection

include ("shop/includes/db.conf.php");
include ("shop/includes/connect.inc.php");
$ses=session_id();


// if add to catalog is called

if (isset($_GET['product'])){
$queryp=mysql_query("insert into catalog set session='$ses', product='$_GET[product]' ");
}


// if remove action is called

if (isset($_GET['remove'])){
$queryp=mysql_query("delete from catalog where session='$ses' and product='$_GET[remove]' ");
echo mysql_error();
}


// just main thing from setup sql table, here is my email info and stuff

$queryset=mysql_query("select * from setup ");
$rowset=mysql_fetch_array($queryset);

echo "<center><table border=0 width=100%><tr><td colspan=3 align='center'>\n";

echo "</td></tr>\n";
//middle




echo '<tr><td width="216"  style="padding-left: 8px; padding-top: 8px; padding-bottom: 8px;" valign="top" align="left">';





 echo '<table border="0" cellpadding="0" cellspacing="0" width="216">

  <tr>
   <td width="4%"><img name="box_upleft" src="prazan/box_upleft.gif" width="10" height="30" border="0" alt=""></td>
   <td width="94%" align="center" valign="middle" background="prazan/box_r1_c2.gif"><div align="left"><b>Categories</b></div></td>
   <td width="2%"><img name="box_upright" src="prazan/box_upright.gif" width="6" height="30" border="0" alt=""></td>
  </tr>
  <tr>
   <td background="prazan/box_left.gif"><img name="box_left" src="prazan/box_left.gif" width="10" height="48" border="0" alt=""></td>
   <td bgcolor="#6A5B5B"><p>';   

/// left, categories of the computer shop

$query2 = "SELECT * from categories ";
$mysqlresult2 = mysql_query($query2);

 while($row2 = mysql_fetch_array($mysqlresult2)){
echo "<a href='index.php?cat=$row2[id]'>$row2[name]</a><br> \n";
}


   echo ' 


   </p>
    <p>&nbsp;</p>    </td>
   <td background="prazan/box_right.gif"><img name="box_right" src="prazan/box_right.gif" width="6" height="48" border="0" alt=""></td>
  </tr>
  <tr>
   <td><img name="box_downleft" src="prazan/box_downleft.gif" width="10" height="5" border="0" alt=""></td>
   <td background="prazan/box_down.gif"><img name="box_down" src="prazan/box_down.gif" width="79" height="5" border="0" alt=""></td>
   <td><img name="box_downright" src="prazan/box_downright.gif" width="6" height="5" border="0" alt=""></td></tr>
</table>';








//body
echo "<td align='center' width=100% valign='top'>\n";


// calculation, listing....


$query=mysql_query("select * from catalog where session='$ses'");
	echo "<table width=100% >\n";
	echo "<tr><td ><div>Remove</div></td><td colspan=2><div>Product </div></td><td ><div>Total</div></td></tr>";
while ($row=mysql_fetch_array($query)){
	$query2=mysql_query("select * from products where id='$row[product]'");


while ($row2=mysql_fetch_array($query2)){

	echo "<tr><td align='left'><a href='catalog.php?remove=$row2[id]'><b>Remove</b></a></td><td align='left'> <a href='index.php?product=$row2[id]'><img src='shop/images/$row2[photo]' border=0></a></td>";
	echo "<td align='left'>$row2[name]</td><td align='left'>$row2[price]</td></tr>\n";
$cat=$row2['category'];
$subtotal=$subtotal+$row2['price'];
$shipping=$shipping+$rowset['shipping'];
}

}
$total=$shipping+$subtotal;
echo "<tr><td colspan=3 align='right'>Subtotal:</td><td align='left' >$$subtotal</td></tr>\n";
echo "<tr><td colspan=3 align='right'>Shipping:</td><td align='left' >$$shipping</td></tr>\n";
echo "<tr><td colspan=3 align='right'>Total:</td><td align='left' >$$total</td></tr>\n";


echo "<tr><td colspan=2 valign='top'><a href='index.php?cat=$cat'><img src='$rowset[main]/images/continue.gif' border=0></a></td>";
echo "<td   colspan=2 valign='center'>";


?>



<form name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="<?PHP echo $rowset['email'] ?>">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="item_name" value="<?PHP echo $rowset['store'] ?>">
<input type="hidden" name="item_number" value="1">
<input type="hidden" name="notify_url" value="<?PHP echo $rowset['main'] ?>/payipn.php">
<input type="hidden" name="return" value="<?PHP echo $rowset['main'] ?>/thanks.php">
<input type="hidden" name="cancel_return" value="<?PHP echo $rowset['main'] ?>canceled.php">
<input type="hidden" name="cn" value="<?PHP echo $ses?>">
<input type="hidden" name="amount" value="<?PHP echo $total ?>">
<input type="image" src="<?PHP echo $rowset['main'] ?>/images/checkout.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form> 





<?PHP
echo "</table>\n";




echo "</td></tr>\n";
echo "</center></table>\n";

?>


<table width="100%"  border="0" cellpadding="0" cellspacing="0" background="tablic.gif">
  <tr>
    <td height="36"><span class="dno">Copyright My Firm 2004. Ver. 2</span></td>
  </tr>
</table>

</body>
</html>

[bpat1434]

Well, if you don't already have a quantity field, add one. Then just when they click remove, remove one. If there is only one in the database, delete the row:

<?php

// All your top code here

if(isset($_GET['remove'])){
    $queryp = mysql_query("SELECT * FROM `catalog` WHERE session='$ses' AND product = '$_GET['remove']'");
    $item = mysql_fetch_array($queryp);
    if($item['quantity'] >=2){
        $queryq = mysql_query("UPDATE `catalog` SET quantity = '$item['quantity']-1' WHERE session = '$ses' AND product = '$_GET['remove']' ");
    }
    else{
        $queryq = mysql_query("DELETE FROM `catalog` WHERE session = '$ses' AND product = '$_GET['remove']'");
    }
    if(!$queryq){
        // echo error
    }
    else{
        // Show your updated stuff, or jsut skip this
    }
}

// Rest of your code

?>

~Brett

[rutin]

thank you very much for your help.
i tried to put this code, but it give me an error.

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in

Is there are problem with my varible ?

should i use something linke this ?

' ".$element['value']." '

If yes, how ?

Thank you !

<?php 

// All your top code here 

if(isset($_GET['remove'])){ 

// at this line give me an eror. i put the comment.
// than error goes at the next line

$queryp = mysql_query("SELECT * FROM `catalog` WHERE session='$ses' AND product = '$_GET['remove']'"); 
$item = mysql_fetch_array($queryp); 
if($item['quantity'] >=2){ 

// than error is here

    $queryq = mysql_query("UPDATE `catalog` SET quantity = '$item['quantity']-1' WHERE session = '$ses' AND product = '$_GET['remove']' "); 
} 
else{ 
    $queryq = mysql_query("DELETE FROM `catalog` WHERE session = '$ses' AND product = '$_GET['remove']'"); 
} 
if(!$queryq){ 
    // echo error 
} 
else{ 
    // Show your updated stuff, or jsut skip this 
} 
} 

// Rest of your code 

?> 

[bpat1434]

If you are referencing values in arrays, then you need to reference them via:
$array_name['key']

Now, you didn't give a line number reference so not sure where it is. One idea is to escape from a string, and then go back in so you know you're getting the values.

<?php
// All your top code here
if(isset($_GET['remove'])){
    $queryp = mysql_query("SELECT * FROM `catalog` WHERE session='$ses' AND product = '".$_GET['remove']."' LIMIT 1");
    $item = mysql_fetch_array($queryp);
    if($item['quantity'] >=2){
        $queryq = mysql_query("UPDATE `catalog` SET quantity = '".$item['quantity']-1."' WHERE session = '$ses' AND product = '".$_GET['remove']."'");
    }
    else{
        $queryq = mysql_query("DELETE FROM `catalog` WHERE session = '$ses' AND product = '".$_GET['remove']."'");
    }
    if(!$queryq){
        // echo error
    }
    else{
        // Show your updated stuff, or just skip this
    }
}
// Rest of your code
?>

~Brett

[rutin]

hi there,

thank you once more for you help.i understand what you said.
thanks for a lesson.

i tried to use it in my code, it did not help.
i got parse error. at line 225. I have put comment where the error is.

Could it be the problem cause i am not posting to catalog a quantity.

here is the structure of my sql table: as you can see from table quantity = qty

how can i insert quantity here ?
how can i solve this ? please help...

CREATE TABLE `catalog` (
  `session` varchar(200) NOT NULL default '',
  `product` int(11) NOT NULL default '0',
  `qty` int(11) NOT NULL default '0',
  `member` int(11) NOT NULL default '0',
  `price` decimal(10,2) NOT NULL default '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Izvoz <i>(dump)</i> podataka tablice `catalog`
-- 

INSERT INTO `catalog` VALUES ('ff964f3aa890361e3b5bc4618111465a', 2, 0, 0, 0.00);
INSERT INTO `catalog` VALUES ('ff964f3aa890361e3b5bc4618111465a', 2, 0, 0, 0.00);

if(isset($_GET['remove'])){ 
    $queryp = mysql_query("SELECT * FROM `catalog` WHERE session='$ses' AND product = '".$_GET['remove']."' LIMIT 1"); 
    $item = mysql_fetch_array($queryp); 
    if($item['qty'] >=2){ 


 //   Parse error: parse error on line 225
 // this is line 225


$queryq = mysql_query("UPDATE `catalog` SET qty = '".$item['qty']-1."' WHERE session = '$ses' AND product = '".$_GET['remove']."'"); 
    } 




else{ 
    $queryq = mysql_query("DELETE FROM `catalog` WHERE session = '$ses' AND product = '".$_GET['remove']."'"); 
} 
if(!$queryq){ 
    // echo error 
} 
else{ 
    // Show your updated stuff, or just skip this 
} 
} 

[bpat1434]

Well, instead of the first 0 in your insert, change it to the quantity. Then you can figure out the rest (you know, price and such).

The parse error, not sure. Can I get a link to where it is being tested so I can see it?

But, your code looks okay for now.

~Brett

[rutin]

hi there,

please check you pm. link is there.
thank you.

[bpat1434]

Wow, it took me a bit, but I got it figured out in how you're actually doing it.

What you might want to do is add a quantity text box for people to add or subtract the quantity at their leisure in the cart view page.

Then, you can write the sql queries to update the quantity to what that text-box is.

~Brett

EDIT

If you need the zip file, just ask.

~Brett