0

I have no trouble at all outputting MySQL data to an array then encoding in json.

What I am trying to understand is how can I add to this json output other pieces of non-dynamic data.

if (mysql_num_rows($result) > 0) {
    while($obj = mysql_fetch_object($result)) {
        $arr[] = $obj;      
    }
    echo $_GET['callback'].'('.json_encode($arr).')';
}else{

}

What I need for example is to add something like

"firstnumber":"0"
"secondnumber":"10"

Is there a way to successfully add this form of data with the array of results and encode it all?

Improve this question
2
  • The $_GET['callback'] makes this code vulnerable to a form of cross site scripting attack. The client can inject javascript code into your system. You must validate/sanitize $_GET['callback'] before echoing it back to the client. Commented Feb 15, 2012 at 14:33
  • Thanks for letting me know, I shall do this right away! Commented Feb 15, 2012 at 14:47

2 Answers 2

Reset to default
1

You can mix/match PHP arrays. The array you build with the database fetch loop will be given numeric keys (0, 1, 2, ...), and then you can add the 'firstnumber' and 'secondnumber' keys yourself afterwards.

however, this makes iterating the loop a bit tricky later, as you'll have to differentiate between the key types. However, nothing stops you from doing a nested structure:

$data = array();
while(...) {
   $data['stuff_from_db'][] = $obj;
}
$data['other_stuff']['first_number'] = 0;
$data['other_stuff']['second_number'] = 10;

which allows you to keep the database results and the "other stuff" in parallel separate branches of the array.

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

Comments

0

I would create an array with my other data, and then append it to the end:

  if (mysql_num_rows($result) > 0) {

   while($obj = mysql_fetch_object($result)) {
       $arr[] = $obj;      
   }

   // Add other data
   $otherData = Array('firstnumber'=>0, 'secondnumber'=>10);

   // Append other data to end of array
   $arr[] = $otherData;

   echo $_GET['callback'].'('.json_encode($arr).')';

}else{

}
Improve this answer

Comments