Access array data from SQL column in PHP

Question

I have some SQL code that returns the a result {"agreetotos":"1","number":"0412345678","signupip":"123.456.789.10"}

I can access this data using PHP and output it as it appears above.

How can I, using PHP, access just the value for the key"number"
the result { } contains varying amounts of data, hence I need to search for the key "number" and return the value "0412345678" (etc)

user1646111 · Accepted Answer · 2013-09-01 07:59:59Z

1

The output is json, you can decode it and convert it to an array:

$json = '{"agreetotos":"1","number":"0412345678","signupip":"123.456.789.10"}';
$array = json_decode($json, true); //convert it to an array
//then

$number = $array['number']; //0412345678

answered Sep 1, 2013 at 7:59

user1646111

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

1 Comment

RozzA Over a year ago

doh! json_decode, of course. I even said to myself at one point 'it looks like json' -- thanks :)

Maciej Radzikowski · Accepted Answer · 2013-09-01 08:01:09Z

1

http://php.net/manual/en/function.json-decode.php json_deconde will convert this string to PHP table, and then you can simply do

echo $table['number'];

answered Sep 1, 2013 at 8:01

Maciej Radzikowski

2,4875 gold badges30 silver badges40 bronze badges

Collectives™ on Stack Overflow

Access array data from SQL column in PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related