how to json encode format?

Question

i'm trying to get some json print. I have a simple format but i didn't figure it out.

But my result is like that. {"datas":{"title":"table"}}

    $sql = "SELECT * FROM mytable";
    $check = mysqli_fetch_array(mysqli_query($con,$sql));
    $array = array("table"=>$check["title"]);
    $result=json_encode(array('datas' => $array));
    echo($result);
    mysqli_close($con);

I need this is my format {"datas":[{"0":"table","title":"table"}]}

I guess i miss something.

use mysqli_fetch_assoc instead, need a mysqli version of stackoverflow.com/questions/11480129/… so it can be closed. Same applies anyway. — Lawrence Cherone
– Lawrence Cherone, Commented Nov 27, 2017 at 18:46
$array[] = $check; it works but i need to put some other data manually. — user7732643
– user7732643, Commented Nov 27, 2017 at 18:55

Andrii Pryimak · Accepted Answer · 2017-11-27 18:47:43Z

1

You should use this:

    $sql = "SELECT * FROM mytable";
    $check = mysqli_fetch_assoc(mysqli_query($con,$sql));
    $array = array("table"=>$check["title"]);
    $result=json_encode(array('datas' => $array));
    echo($result);
    mysqli_close($con);

answered Nov 27, 2017 at 18:47

Andrii Pryimak

8172 gold badges13 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

how to json encode format?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related