mysqli return json array from single sql table column [duplicate]

Question

I am selecting a single column from an SQL table. I want to get as result an array of usernames in json. I don't know what to write in the missing code place in the code below.

Desired result for example:

users ["userA", "userB", "userC"];

<?php
    require_once 'connection.php';
    $result = $conn->query("SELECT username FROM users");
    $users = array();
    // missing code
    $json = json_encode($users);
    echo $json;
?>

Try change it to $users = $result->fetch_all(MYSQLI_NUM);

Nigel Ren
– Nigel Ren

2019-06-23 18:53:08 +00:00
Commented Jun 23, 2019 at 18:53 — Nigel Ren
– Nigel Ren, Commented Jun 23, 2019 at 18:53

Nigel Ren · Accepted Answer · 2019-06-23 18:58:22Z

2

You can fetch all of the users using...

$users = $result->fetch_all(MYSQLI_NUM);

Using MYSQLI_NUM will return a numerically indexed list and so json_encode() will work as you wish.

answered Jun 23, 2019 at 18:58

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

mysqli return json array from single sql table column [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related