HI seniro


I try to insert partial of cookie into the column orderdetail , unfortunately it seems i am doing something wong

Could someone here help me a bit?

Many thanks.



my $cgi = new GT::CGI;
my $session = new CGI::Session(undef, $cgi, {Directory=>'c:/tmp/carttmp'});
my @partofcookie= @{$session->param('CART')};
$tab->insert( #######
{

ID => '2merchantID@merchantID.com' ,
orderdate => \"now()" ,
orderdetail => "@partofcookie" ,
Sname => '2testname' ,
Semail => 'test@test.com'
} )##############ended



After inserting colum of orderdetail show somethiinglike this (HASH(0x1c30450))

  


the @partofcookie look like this


{name => 'ddd',quantity => 6,price => '15',colour => 'red',size => 'xxl',itemID => 15},{quantity => '1',name => 'gmailoknow',price => '8',itemID => '34'}

If you want ALL the data from an array, you need something like:

orderdetail => join(" - ", @partofcookie"),

Otherwise, if you only want for example the color, you would use:

orderdetail => $partofcookie[3] ,

However, it looks like the value of the array is a hashref, so you probably need something like:


..and then a function :


Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

thanks Andy

i have settled insert funcation now

it should be
my $partofcookie = $session->param("CART") || [];

then i check the db. it insert the data correctly.



now i need to try how to get the array from the column for using.

thanks

Hi,

Ok NP - so what does the format look like in the DB (so you can read it) ?

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

andy


it looks like this

{name => 'ddd',quantity => 6,price => '15',itemID => 15},{quantity => '1',name => 'gmailoknow',price => '8',itemID => '34'}

exactly the same as session cart looks like

MMm, not really sure how you would convert that into a usable data, sorry.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

why i want the column looks like this
as i may try to add more key and value to it. let us say size. colour . weight........ it depends on the needs.

 here it is the code i used it before when i use the way of cgi::session::file



my @partofcookie= @{$session->param('CART')}; ### have to defined here or produce error:undefined value as an ARRAY reference
foreach my $product ( @partofcookie ) { ####tested ok sss

$product->{prod_subtotal} = $product->{price} * $product->{quantity};
$tags->{total_price} += $product->{prod_subtotal};
$tags->{itemmaxtemp}=$itemmaxtemp;
$tags->{itemID}=$itemID;
push @{$tags->{cart_loop}}, $product;
}

print $IN->header();
print Links::SiteHTML::display('8gtcart', $tags);
exit;
}


then it will print the correct cart content and total price.

but now i need to get data from mysql db and format it correctly for using
i still got headache on it.

output looks like this

Product ID Product Unit Price Qty Subtotal
1004 (product4name) 44 1 X 44
1002 (product2name) 22 1 X 22
1003 (product3name) 33 1 X 33


Total 99



X is a link when click it will delete this item from cart