Welcome to WebmasterWorld Guest from 54.205.75.60

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Set mysql value to a php variable

   
10:56 am on Feb 9, 2013 (gmt 0)

5+ Year Member



Hello,

I want to set php variable "$vatnumber" with the value "IT123456789" from the following mysql database.

Table: invoicedata
Column: customfields / Value:
a:1:{i:0;a:3:{s:2:"id";s:1:"7";s:9:"fieldname";s:3:"VAT";s:5:"value";s:13:"IT123456789";}}


Value "IT123456789" doesn't have always the same letters and numbers nor the same number of digits.

$vatnumber = $data["VAT"];
It's not working..

How can i do that?

Thanks!
12:14 pm on Feb 9, 2013 (gmt 0)

WebmasterWorld Senior Member swa66 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Seeing more and more of this kind of what I consider abuse of databases: storing arrays in serialized form instead of using the the database to allow it to work with the data.

Did you unserialize the string back into an array ?
[php.net...]
2:11 pm on Feb 9, 2013 (gmt 0)

5+ Year Member



No. I'm not sure if i can do that since my script is encoded with ioncube.