please some help with this functions set up I think I am missing some brackets help!!

Discussion in 'PHP' started by co.ador, Sep 4, 2009.

0
  1. #1 
    function AddItem($itemId, $qty)
$result = mysql_query("SELECT COUNT(*) FROM cart WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");
$row = mysql_fetch_row($result);

$numRows = $row[0];
if($numRows == 0)

{

// This item doesn't exist in the users cart,

// we will add it with an insert query
@mysql_query("INSERT INTO cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");

}

else

{

// This item already exists in the users cart,

// we will update it instead
function UpdateItem($itemId, $qty);
mysql_query("UPDATE cart SET qty = $qty WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");
}
function RemoveItem($itemId) {
mysql_query("DELETE FROM cart WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");

}
    PHP:

     
    co.ador, Sep 4, 2009 IP
  2. cherrysmart23

    cherrysmart23 Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    how to print a string in this format
    r
    ara
    garag
    hgaragh
    uhgaraghu
     
    cherrysmart23, Sep 4, 2009 IP
  3. basheer

    basheer Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    function UpdateItem($itemId, $qty);
    there is may be error i think...
    please remove ; (semicolon) and put ( (open bracket) there..:cool::)
     
    basheer, Sep 5, 2009 IP
  4. ads2help

    ads2help Peon

    Messages:
    2,142
    Likes Received:
    67
    Best Answers:
    1
    Trophy Points:
    0
    #4
    Your syntax is all wrong.

    I think this is what you want:

    
function AddItem($itemId, $qty) {
$result = mysql_query("SELECT COUNT(*) FROM cart WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");
$row = mysql_fetch_row($result);

$numRows = $row[0];
if($numRows == 0) {
  // This item doesn't exist in the users cart,
  // we will add it with an insert query
  @mysql_query("INSERT INTO cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");
} else {
  // This item already exists in the users cart,
  // we will update it instead
  mysql_query("UPDATE cart SET qty = $qty WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");
}
}

function RemoveItem($itemId) {
mysql_query("DELETE FROM cart WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");
}
    PHP:
     
    ads2help, Sep 5, 2009 IP
  5. Martinoes

    Martinoes Peon

    Messages:
    110
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5 
    function AddItem($itemId, $qty) {
	$result = mysql_query("SELECT COUNT(*) FROM cart WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");
	$row = mysql_fetch_row($result);

	$numRows = $row[0];
	
	if($numRows == 0) {
		// This item doesn't exist in the users cart,
		// we will add it with an insert query
		@mysql_query("INSERT INTO cart(cookieId, itemId, qty) values('" . GetCartId() . "', $itemId, $qty)");
	} else {
		// This item already exists in the users cart,
		// we will update it instead
		@mysql_query("UPDATE cart SET qty = $qty WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");	
	}
}
function UpdateItem($itemId, $qty) {
	mysql_query("UPDATE cart SET qty = $qty WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");
}
function RemoveItem($itemId) {
	mysql_query("DELETE FROM cart WHERE cookieId = '" . GetCartId() . "' AND itemId = $itemId");
}
    PHP:
     
    Martinoes, Sep 5, 2009 IP