How to solve this with json_encode(php array from database) result

Question

Hi i have a table with name Users that have these columns:

UserId INT
DisplayName VARCHAR(50)
Username VARCHAR(50)
Password VARCHAR(50)

i get records from this table with mysqli (mysqli_query,mysqli_fetch_array) like this:

$users=array();
while($user=mysqli_fetch_array($result)
$users=array("User"=>$user);
echo json_encode(array("Users"=>$users));

and the result of json_encode is:

{"users":{
    "user":{
        "0":"1",
        "UserId":"1",
        "1":"name",
        "DisplayName":"name",
        "2":"usernameTest",
        "Username":"usernameTest",
        "3":"passwordTest",
        "Password":"passwordTest"
    }
}}

But must be:

{"users":{
    "user":{
        "UserId":"1",
        "DisplayName":"name",
        "Username":"usernameTest",
        "Password":"passwordTest"
    }
}}

AbraCadaver · Accepted Answer · 2017-07-03 17:35:12Z

3

Either tell mysql_fetch_array to fetch an associative array with MYSQLI_ASSOC:

$user = mysql_fetch_array($result, MYSQLI_ASSOC);

Or use mysqli_fetch_assoc that fetches an associative array:

$user = mysqli_fetch_assoc($result);

answered Jul 3, 2017 at 17:35

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

Comments

Sirko · Accepted Answer · 2017-07-03 17:35:01Z

2

Use mysqli_fetch_assoc():

$users=array();
while($user=mysqli_fetch_assoc($result)
  $users=array("User"=>$user);
echo json_encode(array("Users"=>$users));

Btw your code seems a little off. Are your sure you only want to have a single user in this format returned?

answered Jul 3, 2017 at 17:35

Sirko

74.3k19 gold badges157 silver badges194 bronze badges

Collectives™ on Stack Overflow

How to solve this with json_encode(php array from database) result

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related