Use of json_encode

[sepoto]

 <?php$link = mysql_connect('localhost', 'root', '');if (!$link) {	die('Connection error: ' . mysql_error());} $result = mysql_query('use `mydatabase`');if(!result) {die('Query error:' . mysql_error());} $result = mysql_query('select * from locations'); mysql_close($link); echo json_encode($result);?>

I have a sample I prepared that I am working on to get it functional. I see that in the reference for json_encode that the parameter is not allowed to be of the type resource. This leads to the problem of what to do with $result. I suppose I could use a for loop and populate an array and then pass that array to json_encode. I guess the real reason why I post this is to see if someone has some trick to do this that I may not be aware of. Thoughts?

[sepoto]

while($row = mysql_fetch_assoc($table)){ foreach($row as $key => $value) { $arr[$key] = $value; } $main_arr[] = $arr;}$json = json_encode($main_arr); I found this above which is a great example! Is there another way?

[boen_robot]

I believe that if you use MySQLi in PHP 5.4, the result is a serializable object (=> should be compatible with json_encode).

[birbal]

also mysqli has a function which you can use directly to encode http://in3.php.net/manual/en/mysqli-result.fetch-all.php Pleas dont use mysql extension it is obsolete now. use mysqli instead or more better http://php.net/pdo