Why is the Session not registering

[davieboy]

I am making a shopping cart app(small) and have run into a problem

The add to Cart Page

<?php echo "". $_SESSION['products'] .""?><?php 
$id = $_GET['id'];
$products=$_SESSION['products'];
$products="$id"; //Load session variable to a regular page variable
$products['']="". $_SESSION['products'] .""; //Add a new product ID to the array
$_SESSION['products']=$products; //Put the new updated array back into the session.
$product="$id";
echo $products;
?>

the veiwcart page

<?php
// viewCart.php
include 'config.php';
// Using cranial-bore's suggestion of array in session
// $_SESSION["products"] = array(145, 193, 223);
$_SESSION["products"] = array("". $_SESSION['products'] ."");
// Loop through and get all ids
for($item = 0; $item < count($_SESSION['products']); $item++){

// Get data for current item id
$sql = "SELECT * FROM products WHERE id = ". $_SESSION["products"][$item];
$query = @mysql_fetch_array(@mysql_query($sql)) or die(print mysql_error());
// Set you fields here
list($id, $price) = $query;

// Display the product information
echo $id. "--". $price. "--". "<a href=\"remove.php?id=$id\" onClick=\"return popitup('remove.php?id=$id')\"><img src=\"i_delete.gif\" alt=\"Remove $pid From Cart\" width=\"16\" height=\"16\" border=\"0\"><br></a>";
}
echo "hi $products";
?>

With the echo $products in both of the pages all i get is Array.
Therfor in teh $sql query on veiwcart page it cannot find the tcolumn 'array', as it should be the product ID(the variable set)

Unknown column 'Array' in 'where clause'

Can anyone show me why this is not working?

Cheers

[The_Chancer]

Try cycling through the array and see whats in it - then you can make an informed decision as to where to go and what the next step should be...

e.g.

foreach ($_SESSION['products'] as $key=>$val)
{
echo $key." - ".$val;
}

will let you see what is in there and their position / key

Should set you on your way...

[davieboy]

i have tried putting in

$arraySession = array("". $_SESSION['products'] ."");
// Loop through and get all ids
for($item = 0; $item < count($_SESSION['products']); $item++){
    // Get data for current item id
    $sql = "SELECT * FROM products";
    $query = @mysql_fetch_array(@mysql_query($sql)) or die(print mysql_error());
    // Set you fields here
}
print $arraySession[0];
print $arraySession[1];

But the only thing it give is Array

[davieboy]

the bit you just suggested only gives

-

Leading me to belive that addtocart.php is not setting the sessions

Can you see why its wouldnt be?

David

[The_Chancer]

Have a look at this sequence...

$array=array();
array_push($array, "oranges");
array_push($array, "apples");
echo $array; //should echo Array
foreach ($array as $key=>$val)
{
echo $key." - ".$val."<br>";
}

Note the array_push to add items to the end of the array...

If you know what you have to add, and in which order, set the array, add to the array, then

session_register("array");
$_SESSION['array']=$array;

http://uk2.php.net/array_push might also be of help...

[davieboy]

would that work dynamically with the product id's created and stored in the sessions?

[The_Chancer]

Yes, there is no reason why it shouldn't.

If you are using a created ID, then

array_push($array, $id);

[davieboy]

it doint look like the session is registering, all i get is

Array

[The_Chancer]

Just a little question...

have you used session_start() ??

[davieboy]

even in teh add to cart page, the

echo $products

just give the Array word

[davieboy]

Originally posted by The Chancer
Just a little question...

have you used session_start() ??

yes its at the very top of the page

was the firt thig i thought of

I can change the products session request to username and it gives the username fine

just not the product id

🙁

[The_Chancer]

OK...

Starting from scratch... I get:

<?php
session_start();
session_register("products");
$_SESSION['products']=array();
array_push($_SESSION['products'], session_id());
?>

That starts the session, registers the products var, and sets it to be an array.

Pushes the session_id onto the end of the array.

Do you have the product ID in any var - or was it in the session var products before ?

If you post all the code for the first page, I'll have a look....

[davieboy]

the full first page is

<?php 
session_start();

require_once 'update.php';
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<link href="stylesheet.css" rel="stylesheet" type="text/css">
<title>DwsComputers.com -- Creativity Through Technology</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1" class="tablebord1">
  <tr>
    <td><table width="500" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><?php include'header.php'?></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td><table width="500" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr>
          <td><table width="100%" border="0" cellspacing="1" cellpadding="1">
              <tr>
                <td align="left" valign="top"><table width="100%"  border="0">
                  <tr>
                    <td width="18%" valign="top">&nbsp;</td>
                    <td width="82%" valign="top"><p><strong>Cart Contents:<br></strong>
<?php 
$id = $_GET['id'];

$products=$_SESSION['products'];
$products="$id"; //Load session variable to a regular page variable
$products['']="". $_SESSION['products'] .""; //Add a new product ID to the array
$_SESSION['products']=$products; //Put the new updated array back into the session.
echo "Test Echo $products";


?><br>
                          <strong><br>
                          </strong><br>
                      </p>                      

                      </td>
                  </tr>
                </table>
                <br>
                <br><?php include 'footer.php'?></td>
              </tr>
            </table>

      </td>
    </tr>
  </table></td>
  </tr>
</table>
</body>
</html>

The product ID is generated dynamically,. when a user goes to a page called full details.

fulldetails.php

<?php 
session_start();

require_once 'update.php';
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<link href="stylesheet.css" rel="stylesheet" type="text/css">
<title>DwsComputers.com -- Creativity Through Technology</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1" class="tablebord1">
  <tr>
    <td><table width="500" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><?php include'header.php'?></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td><table width="500" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr>
          <td><table width="100%" border="0" cellspacing="1" cellpadding="1">
              <tr>
                <td align="left" valign="top"><table width="100%"  border="0">
                  <tr>
                    <td width="18%" valign="top">&nbsp;</td>
                    <td width="82%" valign="top"><p><?php include 'config.php';
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die (mysql_error());
$id = $_GET['id'];
$query = "SELECT * FROM products WHERE id = '$id'";
$result = mysql_query($query);
$num = mysql_num_rows($result); 
while ($r=mysql_fetch_array($result))
{    

    $id=$r["id"];
    $price=$r["price"];
    $dateadded=$r["dateadded"];
	$dateremoved=$r['dateremoved'];
	$productname=$r['productname'];
$description=$r["description"];
$component=$r["component"];
}
echo "Product: $productname<br>";
echo "dateadded: $dateadded<br>";
echo "Description:<br> $description<br>";
echo "Price: <b>$price</B><br>";
echo "Add to Cart: <a href=\"addtocart.php?id=$id\">Yes</a>";
?><br> 
                          <strong><br>
                          </strong><br>
                      </p>                      

                      </td>
                  </tr>
                </table>
                <br>
                <br><?php include 'footer.php'?></td>
              </tr>
            </table>

      </td>
    </tr>
  </table></td>
  </tr>
</table>
</body>
</html>

The id number from fulldetails is passed to add to cart

Cheers

David

[The_Chancer]

OK - the addtocart.php?id=$id...

<?php  

session_start();
session_register("products");
$_SESSION['products']=array();
array_push($_SESSION['products'], session_id(), $_GET['id']);
//gives you the array (sessid, productid)
echo "Test Echo $products"; //should read echo test array
foreach($_SESSION['products'] as $key=>$val)
{
echo $key." - ".$val."<br>";
}
//that should read
//0 - session id value
//1 - product id
?>

then the viewcart.php

<?php 
// viewCart.php 
include 'config.php'; 
// Using cranial-bore's suggestion of array in session 
// $_SESSION["products"] = array(145, 193, 223); 
// Loop through and get all ids 
for($item = 0; $item < count($_SESSION['products']); $item++){ 

// Get data for current item id 
$sql =mysql_query("SELECT * FROM products WHERE id = ". $_SESSION["products"][$item]"); //assuming that ID column is for the product ID
$query = @mysql_fetch_array($sql) or die(print mysql_error()); 
// Set you fields here 
list($id, $price) = $query; 

// Display the product information 
echo $id. "--". $price. "--". "<a href=\"remove.php?id=$id\" onClick=\"return popitup('remove.php?id=$id')\"><img src=\"i_delete.gif\" alt=\"Remove $id From Cart\" width=\"16\" height=\"16\" border=\"0\"><br></a>"; 
} 
echo "hi $products"; //will echo hi - as $products is a session var - unless you have register_globals as on
?> 

Try that out for size....

[davieboy]

Add to Cart

gives
Test Echo Array0 - 3055d22b86045e5813868e256c6e1f65
1 -

Once you click on the add link

veiwcart

Parse error: parse error in /home/dwscompu/public_html/v2/members/veiwcart.php on line 58

thats

$sql =mysql_query("SELECT * FROM products WHERE id = ". $_SESSION["products"][$item]");

Would i not want veiw cart just to SELECT * FROM products? So i can get all the details for all the product ID's?

[davieboy]

i got the session going now,

just discovered another prob though

stupid products page displays one product, (id=1) then when you add the product to cart the thing adds product Id=2 to the cart

<?

include 'config.php';
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die (mysql_error());
$query = "SELECT * FROM products LIMIT 100";
$result = mysql_query($query);
while ($r=mysql_fetch_array($result))
{    

    $idnum=$r["id"];
    $price=$r["price"];
    $dateadded=$r["dateadded"];
    $dateremoved=$r['dateremoved'];
    $productname=$r['productname'];
$description=$r["description"];
$component=$r["component"];
}
echo "$productname -- ";
echo "$price -- ";
echo "<a href=\"fulldetails.php?id=$idnum\">Full Details</a> -- ";
echo "<a href=\"addtocart.php?idnum=$idnum\">Buy</a>";
?>

[The_Chancer]

There seems to be a slight problem with the product ID getting through - elseyou would have got it in the echoing of the products array.

When you click on the link to add to cart, does it give you the addtocart.php?id=2 (including the product ID ?)

As to the parse error I should have seen it - but use:

 $sql =mysql_query("SELECT * FROM products WHERE id = '". $_SESSION['products'][$item]."'"); 

But if the id number isn't being placed in the link - it won't come through in the array...

[The_Chancer]

OK - if you have that going ignore my last post....

The code you have given will load the vars again and again but only echo out the last option...

Change it as follows:

<?

include 'config.php';
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die (mysql_error());
$query = "SELECT * FROM products LIMIT 100";
$result = mysql_query($query);
while ($r=mysql_fetch_array($result))
{    

    $idnum=$r["id"];
    $price=$r["price"];
    $dateadded=$r["dateadded"];
    $dateremoved=$r['dateremoved'];
    $productname=$r['productname'];
$description=$r["description"];
$component=$r["component"];
echo "$productname -- ";
echo "$price -- ";
echo "<a href=\"fulldetails.php?id=$idnum\">Full Details</a> -- ";
echo "<a href=\"addtocart.php?idnum=$idnum\">Buy</a>";
}
?>

Might help..

[davieboy]

thats got the product page working, but in the veiwcart page it shows 2 of product id=1 where it should be one of 1 and one of 2

??

I think, it might be a crossing of the sessions/variables??

[The_Chancer]

Could well be - I haven't seen a session_unregister() anywhere, so anything that comes along will get pushed onto it.

Incidentally, I have made a shopping cart also (slightly bigger than this with shipping / stock control as well) but I would advise the use of database tables instead of pure session vars...

To try from the start - close browser and try again - see what you get.

If you only get two of product 1 - check what the id number is in the url each time you click the add to cart link.

If there is one for the product 1 and 1 for product 2 - then you'll need to look at the viewcart.php and how it cycles through the array.
If this is the case, then using a delimiter to split the specific orders up could be a way forward.