echo json_encode($row) returns duplicate values

Question

here's my php code

$result = mysql_query("select * from backup where owner='$email'") or die (mysql_error());
$dataCount = mysql_num_rows($result);
$row = mysql_fetch_array($result);
echo json_encode($row);

and it returns this:

{"0":"1","id":"1","1":"2015","year":"2015","2":"55","necessities":"55","3":"10","savings":"10","4":"10","entertainment":"10"}

this is how jsonviewer.stack.hu shows it

fyi, there's only one row of data inside the table. but it seems json_encode($row) displays the value twice, but firstly using number (0 - 4) as the label, then it uses the column name (id, year, necessities, savings, entertainment) as the label.

how can I make it to display the value only once, using the column name?

What does var_dump($row) tell you about the contents of $row? — t.h3ads
– t.h3ads, Commented Jul 27, 2015 at 8:48
Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — user3849602
– user3849602, Commented Jul 27, 2015 at 8:50

Samir Selia · Accepted Answer · 2015-07-27 08:49:11Z

4

Change mysql_fetch_array to mysql_fetch_assoc.

mysql_fetch_array returns a result row in both numeric and associative array.

mysql_fetch_assoc returns a result row as associative array.

answered Jul 27, 2015 at 8:49

Samir Selia

7,1502 gold badges14 silver badges33 bronze badges

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

1 Comment

imin Over a year ago

awesome!! and thanks for the explanation! I'd accept your anwer in the next 10 minutes.

Bryan Abrams · Accepted Answer · 2015-07-27 08:51:43Z

3

http://php.net/manual/en/function.mysql-fetch-array.php

You can give this functional additional arguments including MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH. In your case you want MYSQL_ASSOC.

However, you should be using mysqli and not mysql. the mysql functions are no longer maintained.

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

edited Jul 27, 2015 at 8:51

answered Jul 27, 2015 at 8:50

Bryan Abrams

3372 gold badges5 silver badges16 bronze badges

1 Comment

user3849602 Over a year ago

You can also use mysql_fetch_assoc() instead of giving MYSQL_ASSOC argument. (Same for mysqli_* functions.)

Adam Beleko · Accepted Answer · 2019-05-24 01:03:41Z

2

For new versions of php ( > 5.5), use mysqli_fetch_assoc instead of mysql_fetch_assoc. The mysql_fetch_assoc function is deprecated and is no longer maintained: Using it will lead to errors.

answered May 24, 2019 at 1:03

Adam Beleko

7818 silver badges16 bronze badges

Collectives™ on Stack Overflow

echo json_encode($row) returns duplicate values

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related