Not passing correct value into shopping cart (wish list)

[whiskyman]

Hi all, New to posting on this forum and trying to get my add page to wish list working correctly.

Passing the code and type variables through to this page and echos fine. But when trying to add my database results into an array I am getting the Resource id #4. The code I am using is below without the dasebase password.

<?php
include 'session.php';
$con = mysql_connect("94.136.61.138", "xxxxx", "xxxx");
setcookie ('basket', $cart);

if (isset ($_POST["code"])) $code = mysql_real_escape_string($_POST["code"]);
if (isset ($_POST["type"])) $type = mysql_real_escape_string($_POST["type"]);

$dbcode = $_POST["code"];
$dbtable = $_POST["type"];
echo "table =" .$dbtable;
echo "<br>";
echo "code = ".$dbcode;

	$query = mysql_db_query("xxxxxxx", "select smalltitle, smallimage, alt_small_img, costprice from $dbtable where pagelocation = '$dbcode'");
	echo mysql_error();
	while ($row = mysql_fetch_row($query)){
	echo $row[0];

		for ($z=0; $z<count($code); $z++){
			$shoppinglist[] = array(($code[$z][1] /$row[1]) ,$row[0], $row[1], 0);
			
		}
	
}
for ($i=0; $i<count($shoppinglist); $i++){
	addel($shoppinglist[$i][0], $shoppinglist[$i][1], $shoppinglist[$i][2], $shoppinglist[$i][3]);
}

echo $query;
//echo $shoppinglist;



//header("location:wish_list.php"); 
?>

--------

Any help with this would be great.

To see the results of this you can look at the page

LINK REMOVED FOR USER SAFETY.

Many thanks and hope this is easy to sort as I have try changing lots of things, but always come out with this error or before an Array error.

Thanks

whiskyman

[Atli]

Hey.

The echo on line #30 is generating the "Resource id #" output. It is what you get when you echo the return values of functions that return resources, rather than actual variables. - These include functions like mysql_connect and mysql_query.

Those return values are not meant to be used directly, but to be used by other functions to fetch values from external resources.

P.S.
You should avoid using the mysql_db_query function. Using the mysql_select_db and mysql_query separately is recommended instead. (The mysql_db_query function is deprecated in 5.3, and removed in 6.0)

[whiskyman]

Sorted code by get just an Array value next page

Hi Atli and thank you for your message back.

I have changed that code and taken away the echos. I now get the cart going right through to the next page and displays the value Array now. you can see this by clicking the link below again. Nothing appears in the cart. Im sure my session.php code is correct, but I have listed it below and added the include session.php code to every page.

<?php
  	session_start(); 
    session_name('cartdetails');
    $private_id = session_id();
    $privateKey = $_SESSION['pr_key'];
    $IPADDRESS = $_SERVER['REMOTE_ADDR']; 


	if (!isset($_SESSION["cart"])){
		$_SESSION["cart"] = array();
		$_SESSION["partof"] = 0;
	}
	
	function wishlist($type, $code){
		$tmp = $_SESSION["cart"];
		$is = false;		
		for ($i=0; $i<count($tmp); $i++){
			if (($tmp[$i][1] == $code)){
				$is = true;
				$tmp[$i][0] = $tmp[$i][0] + $no;
				break;
			}
		}
		if ($is==false){
			$tmp[] = array($type, $code);
		}
		$_SESSION["cart"] = $tmp;
	}
		
?>

Any other help you have on this would be excellent.

[Markus]

Hey, Whiskeyman. Welcome to Bytes.com.

Firstly, in future could you, when posting code, wrap the code in [code] ... [/code] tags. This formats the code making it easier to read and, thus, debug.

Second, to your problem. The reason you see "Array" when trying to output the session data is because you need to access specific indexes of the array, just like you would any other array. As you are not using strings for your indexes, you'll access them numerically (in this case 0 for $type and 1 for $code).

printf('Type is: %s<br />Code is: %s', $_SESSION['cart'][0], $_SESSION['cart'][1]);

Marl/

[whiskyman]

Hi Markus and thanks for your help there. I am still struggling to get this working. We keep changing things and hopefully I will get there. Thanks again and any other suggestings would be great. It really the first time I have done a session cookie and just getting my head round it.

Thanks again and I will make sure next time I put code into this forum I will put the tags in.

Alan

[numberwhun]

Hello! I removed your link from your thread, but not for spam purposes. The reason is because if you go to the link, it seems that the site is questionable in the browsers I tried it in. This could be caused by the SSL cert being bad or that the site is an IP but resolves to a .ru URL.

Either way, please make sure the that links you post are safe and resolve correctly. Thank you!

Regards,

Jeff