Get specific MySQL data from array within value?

Question

I want to get a specific value out of a MySql database.

I have:

SELECT option_value 
FROM wp_options 
WHERE option_name = 'DevloungePluginSeriesAdminOptions'

Which outputs:

a:4:{s:11:"add_content";s:4:"true";s:7:"content";s:45:"155000009-9a5sg2t42q2k0159ko8hkdo85hjlu69j";s:11:"show_header";s:4:"true";s:14:"comment_author";s:4:"true";}

I think this is some sort of array. I don't know how handle it. I only want the 155000009-9a5sg2t42q2k0159ko8hkdo85hjlu69j part of the string.

How can I get just 155000009-9a5sg2t42q2k0159ko8hkdo85hjlu69j?

Unsewialize that string and grab it from the array. Then fix your software not to store data in serialized strings. — John Conde
– John Conde, Commented Apr 25, 2013 at 20:36

Sumoanand · Accepted Answer · 2013-04-25 21:08:00Z

1

This data is in serialized format. You need to unserialize it before extracting the array value.

Suppose result object is $result, then following code will work:

$option_value = unserialize( $result->option_value );
$output = $option_value['content'];

answered Apr 25, 2013 at 21:08

Sumoanand

8,9293 gold badges50 silver badges46 bronze badges

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

Comments

diggy · Accepted Answer · 2013-04-25 21:00:02Z

0

put the value in a variable and unserialize:

$val = unserialize( $val );

You'll get a PHP array as a result, inspect it with

print_r( $val );

answered Apr 25, 2013 at 21:00

diggy

6,8482 gold badges20 silver badges24 bronze badges

Collectives™ on Stack Overflow

Get specific MySQL data from array within value?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related