How to encode mysql data in JSON format?

Question

code:

<?php
    session_start();
    error_reporting(0);
    include("config.php");
    $sql = "select * from category";
    $result = mysqli_query($con,$sql);
    while($row = mysqli_fetch_array($result))
    {
        $data[] = array(
                        'category' => $row['category_name'],
                        'image' => $row['file_s']
                    );
    } 
    echo json_encode($data);
?>

In this code I have convert mysql data in json format using json_encode function. It display look like as below:

[
  {
    "category": "cap",
    "image": "Cap-01.png"
  },
  {
    "category": "hair",
    "image": "Hair Color-01.png"
  }
]

But I want it another way like:

[
cap  {
       "image": "Cap-01.png"
     },
hair {
       "image": "Hair Color-01.png"
     }
]

So how can I do this? Please help me.

Thank You

Your desired output is not valid JSON, please edit. Check via e.g. jsonformatter.curiousconcept.com — lojza
– lojza, Commented Aug 18, 2018 at 8:31

urfusion · Accepted Answer · 2018-08-18 08:38:48Z

1

use category name as index

while ($row = mysqli_fetch_array($result)) {
    $data[$row['category_name']] = array(
        'image' => $row['file_s']
    );
}
echo json_encode($data);

edited Aug 18, 2018 at 8:38

answered Aug 18, 2018 at 8:30

urfusion

5,5015 gold badges56 silver badges91 bronze badges

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

2 Comments

urfusion Over a year ago

didn't get you? Please describe a bit more.

omkara Over a year ago

If I use $data[$row['category_name']] so what am I pass in json_encode function

Collectives™ on Stack Overflow

How to encode mysql data in JSON format?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related