JSON data output from database

Question

Hi I have the following JSON data ,fetched from my database:

[{
    "0": "1",
    "id": "1",
    "1": "Hakob",
    "name": "Hakob",
    "2": "[email protected]",
    "email": "[email protected]"
}, {
    "0": "2",
    "id": "2",
    "1": "Arsen",
    "name": "Arsen",
    "2": "[email protected]",
    "email": "[email protected]"
}]

I don't want to see the following key/values "0": "1","1": "Hakob","2": "[email protected]", and same for other row. Who does now what are they, and how I can remove them.

Here is my PHP script for getting this thing

$sql = "SELECT * FROM contacts";
$result = mysqli_query($connect, $sql);
$response = array();
while ($row = mysqli_fetch_array($result)) {
    $response[] = $row;
}

print json_encode($response);

// Close connection
mysqli_close($connect);

Possible duplicate of remove item from array using its name / value — Abid
– Abid, Commented Aug 8, 2017 at 9:11

localheinz · Accepted Answer · 2017-08-08 07:02:09Z

1

You simply have to pass second params of mysqli_fetch_array to get desired result

$sql = "SELECT * FROM contacts";
$result = mysqli_query($connect, $sql);
$response = array();

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { //<-----------change this
    $response[] = $row;
}

print json_encode($response);

// Close connection
mysqli_close($connect);

EDIT

OR you can use mysqli_fetch_assoc($result) to get associative array

See the manual : http://php.net/manual/en/mysqli-result.fetch-array.php

http://php.net/manual/en/mysqli-result.fetch-assoc.php

edited Aug 8, 2017 at 7:02

localheinz

9,6422 gold badges37 silver badges44 bronze badges

answered Aug 8, 2017 at 6:49

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

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

1 Comment

Barmar Over a year ago

Or use mysqli_fetch_assoc()

Collectives™ on Stack Overflow

JSON data output from database

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related