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

Just checking this is correct (not a fix) if(isset($data['0'])){. Did you mean $data[0]? — owenvoke
– owenvoke, Commented Feb 12, 2016 at 12:24
still i am getting same record,i can remove if concept then also i can able to create csv file — Arif Khan
– Arif Khan, Commented Feb 12, 2016 at 12:31

Batu.Khan · Accepted Answer · 2016-02-12 12:30:39Z

2

Try

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

answered Feb 12, 2016 at 12:30

Batu.Khan

3,0652 gold badges23 silver badges29 bronze badges

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

4 Comments

Batu.Khan Over a year ago

@ArifKhan No problem Arif

Daniel W. Over a year ago

This is only 50% of a good answer. It's missing an explanation of what leads to the OP's unexpected behaviour. "Try x/y" has no learning effect, only copy paste.

Arif Khan Over a year ago

@DanFromGermany Thanks for your response. some time we need to have only idea regard the problem. Then we can collect more information by themselves.

Daniel W. Over a year ago

@ArifKhan To gather ideas and clearify the problem you have the comments section.

Collectives™ on Stack Overflow

getting duplicate column while creating csv file in php

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related