Shopping Cart Code incomplete

dipeshedesign · June 12th, 2008, 05:24 PM

Hi,

Just to note I have tried the shopping cart example from chapter 08 and the cart.php code is incomplete and does not work. The <form> is not closed with a </form> and the select is also not closed with </select>.

But the main thing is that even after I fixed the code the 'update' cart does not post at all.

Wondering if you could provide any suggestions.

cheers.

tboronczyk · July 3rd, 2008, 12:15 PM

It looks like the sprintf() that creates the necessary query is missing a formatting specifier. Using the inventory_process.php script from the downloadable source files as a reference, the statement that starts on line 133 should read:

Code:

$query = sprintf('INSERT INTO %sSHOP_INVENTORY (ITEM_NAME, ' .
    'ITEM_DESCRIPTION, PRICE, ITEM_IMAGE, CATEGORY_ID) VALUES ' .
    '("%s", "%s", %02f, "%s", %d)',
    DB_TBL_PREFIX,
    mysql_real_escape_string($_POST['name'], $GLOBALS['DB']),
    mysql_real_escape_string($_POST['description'], $GLOBALS['DB']),
    $_POST['price'],
    mysql_real_escape_string($_POST['image'], $GLOBALS['DB']),
    $_POST['cat_id']);

-Tim

silomorgy · August 2nd, 2009, 10:39 AM

it is realy nice book.

michelmarquetaj · September 23rd, 2009, 12:06 PM

Firstly. apologice for my poor English, I'm from Spain.
And second:
I wonder If anyone of us has found any error in chapter 8, because I'm trying
but I' cant make it work.
I have fixed de </form>, the </select> and the query above. But I think there is something wrong in the matrix "qty", because: "foreach" loop don't make anything.
Any Idea?
Anybody found any extra error?
Please, help!!!!

Thanks a lot, and sorry for my English.