Why is my simple PHP query returning duplicate values?

Question

When I use PHP to do a simple query on a MySQL database, the object being returned holds duplicate values.

This is the PHP code where I query the database:

$query = 'SELECT * FROM names';
$result = mysqli_query($connection, $query);

$data = array();
while ($row = mysqli_fetch_array($result)) {
    array_push($data, $row);
}

echo json_encode($data);

The returning JSON object (being outputted by the Chrome console through Javascript) is as follows:

[{"0": "1", "id": "1", "1": "Jeff", "name": "Jeff"},
 {"0": "2", "id": "2", "1": "Andrew", "name": "Andrew"}]

Each value is listed twice: once as its correct column name and once as its column name's index. Does anyone know why this is happening?

can you please print_r($row); inside your while?

GrafiCode
– GrafiCode

2015-10-12 18:46:21 +00:00
Commented Oct 12, 2015 at 18:46 — GrafiCode
– GrafiCode, Commented Oct 12, 2015 at 18:46

John Conde · Accepted Answer · 2015-10-12 18:47:09Z

4

mysqli_fetch_array() returns both a numerical and asssociative array of the resultset. You need to use mysql_fetch_assoc() to get just the associative array.

while ($row = mysqli_fetch_assoc($result)) {
    array_push($data, $row);
}

answered Oct 12, 2015 at 18:47

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Collectives™ on Stack Overflow

Why is my simple PHP query returning duplicate values?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related