Return JSON from MySQL with Column Name Return JSON from MySQL with Column Name arrays arrays

Return JSON from MySQL with Column Name


php mysql arrays json

Use mysqli_fetch_assoc()

Here you go 

$jsonData = array();if(mysqli_num_rows($result) > 0){while ($array = mysqli_fetch_assoc($result)) {    $jsonData[] = $array;}$json = json_encode($jsonData);echo stripslashes($json);}

php mysql arrays json

You should try while($row = mysqli_fetch_assoc($result)).

It should return the result with the respective fieldnames.

You can find the manual page here.

php mysql arrays json

You should use mysqli_fetch_assoc here instead so that it returns the key as the column names. mysqli_fetch_row returns numeric array keys instead.

Try this:

if (mysqli_num_rows($result) > 0) {   $jsonData[] =  mysqli_fetch_assoc($result);}$json = json_encode($jsonData, JSON_PRETTY_PRINT);

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last