sql PDO fetchall duplicate object keys?

You have to specify fetching mode

$q->fetchAll(PDO::FETCH_ASSOC);

php sql pdo

Please specify the Mode of fetching

Change

$json = $q->fetchAll();

$q->fetchAll(PDO::FETCH_ASSOC);

CodeHunter