How to convert MySQL data to JSON using PHP [duplicate]

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
– mario, Commented Feb 6, 2015 at 5:24
Change your echo to: echo json_encode(array('jobs' =>$resultArray)); and you have what you're looking for exactly! — Jacob Topping
– Jacob Topping, Commented Aug 12, 2015 at 3:43

Tariq hussain · Accepted Answer · 2015-02-06 05:02:32Z

2

try this it should work ..

$jobarray = array();

$jobarray['jobs'] = $resultArray;

echo json_encode($jobarray);

answered Feb 6, 2015 at 5:02

Tariq hussain

6145 silver badges11 bronze badges

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

1 Comment

Sun Over a year ago

thanks for solution, i already ticked your answer as well and after 7 minutes i will accept this

Collectives™ on Stack Overflow

How to convert MySQL data to JSON using PHP [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related