[RESOLVED] database & sessions

thekidscareya

A user runs the following page...it is run from custom_quote.php?id=1 (you'll get what I'm talking about down the page)

<?php
	if(isset($_POST['Submit']))
		{
		$pages = $_POST['pages'];
		$details = $_POST['details'];

	if(empty($pages)) { $error = "<li>The page field was left blank.</li>"; }
	if(empty($details)) { $error .= "<li>The details field was left blank.</li>"; }

	if(isset($error))
		{
		?><ul><?php echo $error; ?></ul><?php
		}else{
		$sql = "INSERT INTO `tbl_web_design` (`id`, `pages`, `details`) VALUES(DEFAULT, '$pages', '$details');";
		mysql_query($sql) or die("ERROR: ".$sql."<br>".mysql_error());

		$_SESSION['web_design'][] = mysql_insert_id(); 
		?><p align="center">The <a href="quote.php?id=<?php echo mysql_insert_id(); ?>&order=<?php echo $id; ?>">web design project</a> has been added to your <a href="<?php echo $PHP_SELF; ?>">shopping cart</a>.<br>
		<a href="<?php echo $PHP_SELF; ?>">View Shopping Cart</a><br>
		<a href="<?php echo $_POST['previous']; ?>">Go back to previous page</a><br>
		<a href="<?php echo $_SERVER['REQUEST_URI']; ?>">Add another web design project</a></p>
		<?php
		}
	}else{ ?>
	<h3>Web Design</h3>
	<form method="post" action="<?php echo $PHP_SELF; ?>?id=<?php echo $id; ?>">
	  <table width="670" border="0">
        <tr>
          <td width="111"><strong>Number of Pages</strong>s</td>
          <td width="549"><input type="text" name="pages">
          <input name="previous" type="hidden" value="<?php echo $_SERVER['HTTP_REFERER']; ?>"></td>
        </tr>
        <tr>
          <td valign="top"><strong>Details</strong></td>
          <td><textarea name="details" cols="50" rows="5"></textarea></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td><strong>Bold indicated required</strong></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td><input type="submit" name="Submit" value="Add to Cart">
              <input type="reset" name="Reset" value="Reset"></td>
        </tr>
      </table>
	</form>
<?php
	}
?>

Everything works out fine...the user fills out the form and the php server processes it by inserting it into the database and creating a session based on the id generated from the database.

Now the user goes to $PHP_SELF (let's call it custom_quote.php):

<?php include "includes/top.php"; ?>
<div id="content"> 
  <h2 id="pageName">Custom Quote</h2> 
  <div class="story"> 
	<?php 
	if(isset($_GET['id']))
		{
		include "custom_quote/".$_GET['id'].".php"; 
		}else{
		switch($_GET['act'])
			{
			case "clear" :
			session_unregister($_SESSION) or die("Cannot clear cart.  Please contact technical support.");
			?><p align="center">Your <a href="<?php echo $PHP_SELF; ?>">cart</a> has been cleared successfully.<br>
			<a href="javascript:history.back(1)">Go back</a></p><?php
			break;
			case "remove" :
			foreach($product[$_GET['order']] as $name=>$table)
				{
				$sql = "DELETE FROM tbl_".$table." WHERE `id` = '".$_GET['oid']."' LIMIT 1";
				mysql_query($sql) or die(mysql_error());
				foreach($_SESSION[$table] as $index=>$val)
					{
					if($_GET['oid'] == $val)
						{
						session_unset($_SESSION[$table][$index]) or die("Error");
						}
					}
				if(!$unset)
					{
					?><p>The <?php echo $name; ?> quote in your cart could not be removed.  Please contact technical support.</p><?php
					}else{
					?><p>The <?php echo $name; ?> quote in your cart has been successfully removed.</p><?php
					}
				}
			break;
			case "modify" :
			include "custom_quote/modify.php";
			break;
			case "checkout" :
			include "custom_quote/checkout.php"; 
			break;
			default :
			include "custom_quote/default.php"; 
			break;
			}
		}
		?>
  </div>
</div> 
<?php include "includes/left.php"; ?>
<?php include "includes/bottom.php"; ?>

For some reason, when the user runs custom_quote.php?act=clear - the $_SESSION variable is not cleared. Also, when the user runs custom_quote.php?act=remove&order=1&oid=5 (OID is hypothetical...it is based on the database), the session that corresponds to the OID should be cleared, but is not cleared.

WHat is going wrong?
Thanks for your help in advance.

tomhath

You can unregister and unset session variables by name, not the whole superglobal variable:

http://us2.php.net/session_unregister

thekidscareya

Thanks for that info. Appreciate it.

How do I have PHP return false for any value for $_SESSION[$table][$index], where $table and $index can be any possible value?

I want it to return false even for something like Array ( [CEO] => Array ( ) ).

I was using this: !count($_SESSION) == 0, but that statement returns true for Array ( [CEO] => Array ( ) )

How do I do that?

Roger_Ramjet

tomhath wrote:
You can unregister and unset session variables by name, not the whole superglobal variable:

http://us2.php.net/session_unregister

But you can set the superglobal equal to an empty array

$_SESSION = array();

and should do that before using session_destroy() anyway.

thekidscareya

I used session_destroy() instead of session_unregistered().

But that doesn't help my 2nd question.

Roger_Ramjet

I don't understand your second question 😕

The count of session elements would not be zero if it contained ( [CEO] => Array ( ) )

CEO would contain an empty array, but it would still be there to count.

thekidscareya

How do I write a statement that reads teh $_SESSION variable and if there is nothing in it, it executes some code, but if there is something in it, it executes antoher piece of code.

I was using:

if(count($_SESSION) == 0)
{

}else{

}

How do I get that to work if the $_SESSION variable looks like Array ( [CEO] => Array ( ) )

Roger_Ramjet

isset() tells you if the var exists

is array tells you if it is an array

and of course count() then tells you if it is an empty array or not.

So work your way through them. Now if the array can contain arrays then you'll need to make your function recursive.

thekidscareya

How do I do that?

Roger_Ramjet

How do you test to see if an element in $_SESSION is an empty array?


if (isset($_SESSION['var']) and is_array($_SESSION['var']) and (count($_SESSION['var']) == 0)) {
// do this
} else {
// do that
}

It will only do this if it is set and is an empty array, otherwise it will do that

thekidscareya

That doesn't work if $SESSION = Array ( [CEO] => Array ( ) )

if (!isset($_SESSION) || !is_array($_SESSION) || count($_SESSION) == 0)
	{

?><p>Nothing in the session.</p><?php
}else{
?><p>Something in the session.</p><?php
    }
?>

I changed the AND to an OR. Either way, it still executes the code after the }else{ and before the last }.

btw, i changed the code a little bit - i switched the statements

Roger_Ramjet

Ah, well, $_SESSION is already an array, so what you are doing is to add an element call 'CEO' with a value of an empty array().

Now, your IF is asking is $SESSION does NOT exist, and of course it does so the ELSE gets processed. Try using it as I posted it, substituting your own variable name. If you want to test just whether the $SESSION array is empty use count($SESSION). If you want to test elemenst whose names are not known in advance then use foreach($SESSION as $key->$val) and test the $key.

thekidscareya

Thanks...that solved the problem. I really appreciate your help.

Here's what I used:

foreach($_SESSION as $key=>$val)
	{
	if(count($_SESSION[$key]) == 0)
		{
		$quotes = false;
		}
	}
if(!isset($_SESSION) || !is_array($_SESSION) || count($_SESSION) == 0)
    {
	$quotes = false;
    }

if(!$quotes)
    {
    ?><p>Nothing in the session.</p><?php
    }else{
    ?><p>Something in the session.</p><?php
        }
    ?>