getting duplicate column while creating csv file in php

Question

    $stmt =$this->db->prepare("select * from abstract where account_name=:account_name");
    $stmt->bindparam(':account_name',$name);
    $stmt->execute();
    $getAccountInfo=$stmt->fetchAll();
    return $getAccountInfo;

csv file concept is

if (isset($_POST['xyz'])) {
    $randnum = rand(1111111111,9999999999);

    if (isset($data['0'])) {
        $fp= fopen("contacts_$randnum.csv","w");
        foreach ($data AS $values) {
            fputcsv($fp, $values);
        }
        fclose($fp);
    }
}

when i submit post request i am getting csv file with duplicate column

Answer 1

Try

$getAccountInfo=$stmt->fetchAll(PDO::FETCH_ASSOC);