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
5 1953 Atli 5,058
Expert 4TB
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)
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.
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/
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
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
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Newbie |
last post by:
OK, this may be impossible since I'm using 3rd party shopping cart ASP
software, but I've been able to finagle a lot of other stuff I thought
wouldn't work, so here we go:
I'm using a form in...
|
by: Don Grover |
last post by:
I am retrieving costs and product id's from a sql db. and need to build a
shopping cart around it.
How do I store the selected items and qty req so I can move into another
catalog and total up as...
|
by: Jia Sun |
last post by:
hello , everybody , i need a similar program , just like
fancyimport.com
if possible, pls contact me ,thank you very much .
inchina@gmail.com
|
by: Penny |
last post by:
Hi all,
I've built an online shopping cart using ASP Classic(based on a 'WebThang'
tutorial). The shop cart page (with table showing customers selected items
and costs) has only 3 buttons/links....
|
by: MickG |
last post by:
I am trying to change the value of the variable "hard" according to
which radio button is pressed and I am having no joy. Could anyone
help me with this, the problematic section is marked with...
|
by: G.E.M.P |
last post by:
High Level Session Handling Design for a Shopping cart
0) What am I missing?
1) How does OSCommerce do it?
I'm thinking about building a shopping cart from scratch,
using a library of dynamic...
|
by: Vahehoo |
last post by:
Hi,
I have an ASP .Net e-business site that is built using DNN 2.0. I am
having troubles passing my shopping cart items to PayPal. I implemented
a total paynow button, but it was not good enough...
|
by: Travis1012 |
last post by:
Hi,
I require a shopping cart which gathers infomation from customers on what they wish to purchase (all products show a price with them). After they have created their list, they go to the cart...
|
by: Travis1012 |
last post by:
Hi,
I require a shopping cart which gathers infomation from customers on what they wish to purchase (all products show a price with them). After they have created their list, they go to the cart...
|
by: Harlan Messinger |
last post by:
The Doctor wrote:
A quandary? Hardly.
I would think that you'd address this question to the bank whose page
you are submitting the information to.
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |