Problem with variable declaration in switch statement

Posted on 16th Feb 2014 07:03 pm by admin

Hello, I am having some trouble assigning a value to a variable inside a switch statement. What I am trying to do here is trip an error if the user has already added an item in the shopping cart. The While and Foreach loops work perfectly fine. The problem is that the value of variable $error does not get passed outside of the case. As a result, I cannot get the error message to display. I really need to get this to work and any help is appreciated. The code looks something like this:

Code: switch ($action) {
case 'add' :
{
if ($_SESSION['CartID'] == "")
{

$query = 'INSERT INTO ShopCart( UserID )VALUES("' . $UserID . '")';
mysql_query($query, $db) or die(mysql_error($db));

$Shop = 'SELECT ShopCartID FROM ShopCart WHERE UserID = "' . $UserID . '" ORDER BY ShopCartID ASC LIMIT 1';
$Cart = mysql_query($Shop);
$ShopCart = mysql_fetch_row($Cart);
$_SESSION['CartID'] = $ShopCart[0];
}
$query = 'SELECT ProductID FROM ShopCartLine WHERE ShopCartID = "' . $_SESSION['CartID'] . '"';
$result=mysql_query($query, $db) or die(mysql_error($db));

//$row = mysql_fetch_row( $result );
while($var = mysql_fetch_array($result))
{
foreach ($var as $i) {
if ($i == $ProductID) {
$error = 1; //TRIP THE ERROR HERE!
echo "<script type='text/javascript'>window.top.location='http://amarcy2.db-class.ids.uic.edu/shopcart.php';</script>";
}
}
}
}


The code being used to display the error message is as follows:

Code:
if ($error == 1) {
echo '<p>You already have this item in your basket!</p>';
}

Your Answer:

Login to answer

Other forums

Ten Operator Syntax
Hi Guys,

I can't figure out why i am getting a parse error with this basic ten op code:

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Insert Failing.
Hey,
I am making a Sign up page for a website, but the insert query into the Database does not se

square instead of number
Hello
I do not know why but this code seems to work fine only in my xampp local insallation but n

mails going in spam??
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho

Find only certain URLs from page ... regex (semi-complete script)
Hi guys,

What I need to do is take a page & extract all the URLs from the page &a

Simple email form - Newbie
Hello all,

First time poster!

I've been asked to create a simple HTML form that submit

Help with setcookie()
Merry Xmas to those on this foruum
Older guy here with some experience but not allot so please be