VB (VBA) function for PHPs serialize

18 May 2009 5:12 AM

Miha Abrahamsberg

Hello!

Does anyone know how to "unpack" data in VB (VBA) that PHP stores using it's
"serialize" function?

Syntax for serialize: http://si2.php.net/serialize

Note: I need this to use some data stored in a MySQL database that was
entered via web-shop (PHP) and "packed" with the serialize function

Some examples of data stored in a table by the serialize function:

- a:1:{i:1;a:4:{s:8:"shipping";s:27:"Dostava preko GLS
SLovenija";s:5:"rates";a:1:{i:0;d:0;}s:15:"tracking_number";s:0:"";s:7:"carrier";s:0:"";}}
- a:1:{i:1;a:2:{s:8:"shipping";s:27:"Dostava preko GLS
SLovenija";s:5:"rates";a:1:{i:0;d:3.5;}}}
-
a:2:{s:15:"product_options";a:1:{i:761;s:4:"3409";}s:8:"discount";s:5:"27.82";}
- a:2:{s:15:"product_options";a:0:{}s:8:"discount";s:5:"35.10";}

Thank you in advance!

Miha

18 May 2009 5:29 AM

Cor Ligthert[MVP]

Miha,

VBA is a complete different animal then VB for Net.
You can say they both are mammals but for the rest there is very much
difference.

Try your question in a VBA newsgroup. VBA (Visual Basic for Applications) is
typical MS Office like MS-Access

Cor

Show quoteHide quote

"Miha Abrahamsberg" <m***@krik.si> wrote in message
news:OFMCxc31JHA.1900@TK2MSFTNGP04.phx.gbl...
> Hello!
>
> Does anyone know how to "unpack" data in VB (VBA) that PHP stores using
> it's "serialize" function?
>
> Syntax for serialize: http://si2.php.net/serialize
>
> Note: I need this to use some data stored in a MySQL database that was
> entered via web-shop (PHP) and "packed" with the serialize function
>
> Some examples of data stored in a table by the serialize function:
>
> - a:1:{i:1;a:4:{s:8:"shipping";s:27:"Dostava preko GLS
> SLovenija";s:5:"rates";a:1:{i:0;d:0;}s:15:"tracking_number";s:0:"";s:7:"carrier";s:0:"";}}
> - a:1:{i:1;a:2:{s:8:"shipping";s:27:"Dostava preko GLS
> SLovenija";s:5:"rates";a:1:{i:0;d:3.5;}}}
> -
> a:2:{s:15:"product_options";a:1:{i:761;s:4:"3409";}s:8:"discount";s:5:"27.82";}
> - a:2:{s:15:"product_options";a:0:{}s:8:"discount";s:5:"35.10";}
>
>
> Thank you in advance!
>
> Miha
>