In PHP, I encoded a JSON array from mySQL, how do I use it? decode?

Question

$sql = "SELECT * FROM `scripts` LIMIT 0, 30 ";   
$result = mysql_query($sql) or die ('Error updating database: ' . mysql_error()); 
$json = array(); 
if(mysql_num_rows($result)) { 
    while($row=mysql_fetch_row($result)) { 
        $json['table data'][]=$row;
    } 
 } 
$encoded = json_encode($json); 
echo $encoded;

This is my output:

{"table data":[["1","test","30","13"],["2","test2","40","14"]]}

How do I access an individual piece of the array, its an array of arrays? do i decode it first?

Welcome to Stack Overflow! On a side note; please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use pdo or mysqli. — hjpotter92
– hjpotter92, Commented Apr 11, 2013 at 21:48

Pierre Lebon · Accepted Answer · 2013-04-11 21:48:37Z

1

Try to decode

$json = '{"foo-bar": 12345}';

$obj = json_decode($json);
print $obj->{'foo-bar'}; // 12345

Bye Bye

answered Apr 11, 2013 at 21:48

Pierre Lebon

4731 gold badge5 silver badges12 bronze badges

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

Comments

exussum · Accepted Answer · 2013-04-11 21:48:43Z

0

you use

 $json['table data'][$id]

where $id is the row you want to access

so for example

$json['table data'][0][1]  == "test"
$json['table data'][1][1]  == "test2"

answered Apr 11, 2013 at 21:48

exussum

18.6k8 gold badges35 silver badges67 bronze badges

Comments

bvarga · Accepted Answer · 2013-04-11 21:58:20Z

0

Create an array, when you add data into array.

$json['table data'][] = array($row);

answered Apr 11, 2013 at 21:58

bvarga

7237 silver badges12 bronze badges

Collectives™ on Stack Overflow

In PHP, I encoded a JSON array from mySQL, how do I use it? decode?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related