PHP:MYSQL array to JSON stop duplicating?

Question

So whenever I download data from my mysql database, and convert to a JSON array via PHP then display it, I get duplicated values.

I do understand why this is so, but is there any way to remove the numeric duplicates?:/

{"id":"1","0":"1","userId":"23","1":"23","message":"HELLO","2":HELLO"},
{"id":"2","0":"2","userId":"53","1":"53","message":"WOW","2":WOW"}

Looks like you're using the default "both" fetch option. You need to specify associative only. Is it PDO or mysqli? — Don't Panic
– Don't Panic, Commented Mar 9, 2018 at 17:35
Open a manual for database api you use and find answer there. — u_mulder
– u_mulder, Commented Mar 9, 2018 at 17:39

aidinMC · Accepted Answer · 2018-03-09 17:47:35Z

1

For PDO use PDO::FETCH_ASSOC flag after query execute

$sth = $dbh->prepare("SELECT col FROM table");
$sth->execute();
$result = $sth->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($result);

And for mysql_* functions:

$query = "SELECT col FROM table";
$result = mysqli_query($connection, $query);
$output = array();
while($row = mysqli_fetch_assoc($result)){
    $output[] = $row;
}
json_encode($output);

edited Mar 9, 2018 at 17:47

answered Mar 9, 2018 at 17:40

aidinMC

1,4363 gold badges22 silver badges38 bronze badges

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

Comments

Orry · Accepted Answer · 2018-03-09 17:41:58Z

0

As you've asked, to remove it: Loop through it, if key is numeric delete.

foreach($array as $key=>$var){ 
    if(is_numeric($key)){ 
        delete $array[$key]; 
    } 
}

answered Mar 9, 2018 at 17:41

Orry

6396 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP:MYSQL array to JSON stop duplicating?

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