Shopping cart application question
in [Databases]
|
From: "Ron Piggott" on 3 Apr 2010 19:48 I am writing a shopping cart application. I am expanding the application to have a store membership component. Right now I am saving the customers selections in one of two ways: - In the session variable "$_SESSION['order']" if they aren't logged in - For those who have logged into their account I am saving their selections in the table "membership_shopping_carts" I have ran into trouble trying to output their choices under the "cart contents" heading. I want to invoke one of two loops --- A 'while' loop for the session variable and a mySQL query for the logged in users. The " } else { " confuses PHP. I am not sure what I should be doing. $_SESSION['user_reference'] stores the value of the logged in user. This is how I tell if s/he is logged in or not --- and which loop I want to invoke. Suggestions? Ron if ( $_SESSION['user_reference'] > 0 ) { $user_reference = $_SESSION['user_reference']; $query = "SELECT `store_product_profile`.`reference` FROM `membership_shopping_carts` INNER JOIN `store_product_profile` on `store_product_profile`.`reference` = `membership_shopping_carts`.`store_product_profile_reference` WHERE `membership_shopping_carts`.`member_reference` = $user_reference ORDER BY `store_product_profile`.`product_name` ASC"; $shopping_cart_content_result=mysql_query($query); $cart_records_found=mysql_numrows($shopping_cart_content_result); $i=0; while ( $i < $cart_records_found ) { } else { foreach ($_SESSION['order'] AS $key => $value ) { }
From: Nilesh Govindarajan on 3 Apr 2010 21:27 <Quote snip> I didn't understand your problem. Explain clearly. -- Nilesh Govindarajan Site & Server Administrator www.itech7.com मेरा भारत महान ! मम भारत: महत्तम भवतु !
From: chris smith on 3 Apr 2010 23:36 > The " } else { " confuses PHP. I am not sure what I should be doing. You're missing at least one brace. If the code you supplied is a copy of what you have, you're missing a } for the end of the while loop and one for the end of the else condition. So it's treating } else { as part of the while construct (and while() doesn't have anything like an else condition). > if ( $_SESSION['user_reference'] > 0 ) { <snip> > $i=0; > while ( $i < $cart_records_found ) { > } // end while > } else { > > foreach ($_SESSION['order'] AS $key => $value ) { > > } > } // end else condition -- Postgresql & php tutorials http://www.designmagick.com/
From: Ron Piggott on 4 Apr 2010 00:44 I have done something like you have said below Chris. I put the code which is common to be loops in it's own file and I did an INCLUDE Ron -----Original Message----- From: chris smith <dmagick(a)gmail.com> To: ron.piggott(a)actsministries.org Cc: php-db(a)lists.php.net Subject: Re: [PHP-DB] Shopping cart application question Date: Sun, 4 Apr 2010 13:36:05 +1000 > The " } else { " confuses PHP. I am not sure what I should be doing. You're missing at least one brace. If the code you supplied is a copy of what you have, you're missing a } for the end of the while loop and one for the end of the else condition. So it's treating } else { as part of the while construct (and while() doesn't have anything like an else condition). > if ( $_SESSION['user_reference'] > 0 ) { <snip> > $i=0; > while ( $i < $cart_records_found ) { > } // end while > } else { > > foreach ($_SESSION['order'] AS $key => $value ) { > > } > } // end else condition
|
Pages: 1 Prev: ANN: PHP Generators 10.3 released Next: include_path in appache.conf |