unserialized array

aftal2002

Well, I got stuck with editing someone elses code after they dropped off a project and I can't figure out how to do this. This is part of a shopping cart system that allows multiple products and quantities.

The original serialized array in mysql looks like this:

a:3:{s:5:"owned";i:1;s:6:"leased";i:0;s:7:"install";i:0;}

In the 2checkout call back script it get's unserialized

$order['products'] = unserialize($order['products']);

then

$count = 0;

for ($i = 0; $i < ($order['products']['owned'] + $order['products']['leased']); $i ++) {

  $count ++;

then it's read and inserted into the database:

  $license['customerid'] = $customer['customerid'];
  $license['type'      ] = ($count > $order['products']['owned']) ? ('leased') : ('owned');
  $license['status'    ] = 1;
  $license['purchase'  ] = time();

  $DB->insert($license, 'license');

but here is my issue. I manually added additional products so now the serialized mysql bit looks like this:

a:4:{s:5:"owned";i:0;s:6:"leased";i:1;s:7:"product";i:0;s:7:"install";i:0;}

What do I need to change to the $count strings to let it choose this new item if it's greater than 0?

Thanks for any help.

aftal2002

hmm... Does my question make sense? I'm wondering how to pull something other than owned or lease out of the unserialized bit from mysql.

aftal2002

Somone on phphelp asked me to clear the post up over there so let me clarify here as well

I want to add extra variables ie products

Owned and Leased are already defined and processed from a mysql table field that looks like this:

a:3:{s:5:"owned";i:1;s:6:"leased";i:0;s:7:"install";i:0;}

The number equals the number of products purchased.
I've changed the order process to reflecta new product and now my serialized bit in mysql looks like this

a:4:{s:5:"owned";i:0;s:6:"leased";i:1;s:7:"product";i:0;s:7:"install";i:0

However the passback routine doesn't know what to do with the new data because there isn't a refeence for it on the count line. I'm not sure how to format it to allow it as a option.

Weedpacket

Have you tried letting PHP worry about it?

$var = unserialize($order['products']);
$var['product']=7;
$var = serialize($var);

But, taking your typo into account, the "manually adjusted" string unserialises fine for me, so are you sure that's even the problem?