How to convert MySQL data to JSON using PHP

Question

How to encode JSON in below format:

{
  "jobs": [
    {
     "JobID":"1",
     "JobTitle":"CEO"
    }
  ]
}

This is what I achieved:

[
  {
    "JobID":"1",
    "JobTitle":"CEO"
  }
]

Here is my PHP script using to mysql data to JSON:

<?php
    ......

    $strSQL = "SELECT * FROM jobs WHERE 1 ";

    $objQuery = mysql_query($strSQL);
    $intNumField = mysql_num_fields($objQuery);
    $resultArray = array();
    while($obResult = mysql_fetch_array($objQuery))
    {
        $arrCol = array();
        for($i=0;$i<$intNumField;$i++)
        {
            $arrCol[mysql_field_name($objQuery,$i)] = $obResult[$i];
        }
        array_push($resultArray,$arrCol);
    }

    mysql_close($objConnect);

    echo json_encode($resultArray);
?>

I am not a native PHP developer, that's why not so strong in web development and i tried some tutorials and blogs but did not get any solution !

(Finding duplicates is difficult for such trivial questions, because nobody bothers with even remotely descriptive question titles.) — mario, Feb 06 '15 at 05:24
Change your echo to: echo json_encode(array('jobs' =>$resultArray)); and you have what you're looking for exactly! — Jacob Topping, Aug 12 '15 at 03:43

score 2 · Accepted Answer · answered Feb 06 '15 at 05:02

2

try this it should work ..

$jobarray = array();

$jobarray['jobs'] = $resultArray;

echo json_encode($jobarray);

answered Feb 06 '15 at 05:02

Tariq hussain

614
5
11

thanks for solution, i already ticked your answer as well and after 7 minutes i will accept this – Sun Feb 06 '15 at 05:04

How to convert MySQL data to JSON using PHP

1 Answers1

Linked