PHP/MySQL: how to access an array value from a mysql field

Question

I have a field value in a mySQL table that I save into a variable called "$mp3".

If I echo this variable, I get this:

a:3:{s:4:"file";s:114:"/home/www/xxxxx/web/admin/wp-content/uploads/2014/05/table3_podcast_20141.mp3";s:3:"url";s:92:"http://www.xxxx.com/admin/wp-content/uploads/2014/05/table3_podcast_20141.mp3";s:5:"error";b:0;}

How should I complete my variable in order to only retrieve this part of the array (whatever its content):

http://www.xxxx.com/admin/wp-content/uploads/2014/05/table3_podcast_20141.mp3

Thank you!

This is a serialized string read unserialize

M Khalid Junaid
– M Khalid Junaid

2014-06-04 13:49:57 +00:00
Commented Jun 4, 2014 at 13:49 — M Khalid Junaid
– M Khalid Junaid, Commented Jun 4, 2014 at 13:49

Toote · Accepted Answer · 2014-06-04 13:49:52Z

1

That value is a serialized storage of a PHP array.

To reconstruct the array you need to use unserialize:

$data = unserialize($mp3);
$url = $mp3['url'];

answered Jun 4, 2014 at 13:49

Toote

3,4232 gold badges21 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Baylock Over a year ago

Thank you very much. I'll accept this answer in a few minutes (when the system allows me to do so)

Collectives™ on Stack Overflow

PHP/MySQL: how to access an array value from a mysql field

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related