Store PHP Variable in CSV file

Question

I want to store my PHP variable in a CSV file.

As they are individual variables and I need to store them in row columns format.

for ex- ID, First Name, Last Name, Address, Phone. etc.

suppose I have variable $id, $firstname, $lastname, $address, $phone.

How can I store this variable in a single row separated by a column in a CSV file?

I tried using an array but as they are individual variables and use in entire my program so I want to add this variable at end of the script to CSV to maintain the report.

$fp = fopen($filename, "w");

$fp = fopen("ouput.csv", w)

fputcsv($fp,array(array($id,$firstname, $lastname,$address,$phone)));

fclose($fp);

Thanks in advance.

Show us what you tried. This isn't a coding service where we write all the code for you. — M. Eriksson
– M. Eriksson, Commented Jan 25, 2016 at 7:08
Did you want to store variable value or variable name to csv file? — Ijas Ahamed N
– Ijas Ahamed N, Commented Jan 25, 2016 at 7:08
I want to store variable value in csv, As first I am importing data from csv and storing into database. Then I want to store that variable which are inserted or updated using previous queries into csv file. — Rahul
– Rahul, Commented Jan 25, 2016 at 7:12

Evert · Accepted Answer · 2016-01-25 17:50:38Z

1

You were very close, instead of:

$fp = fopen("ouput.csv", 'w');

you should have called:

$fp = fopen("ouput.csv", 'a');

The w causes the file to overwrite, the a stands for append.

answered Jan 25, 2016 at 17:50

Evert

101k18 gold badges136 silver badges221 bronze badges

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

Comments

Ijas Ahamed N · Accepted Answer · 2016-01-25 07:19:28Z

0

Just try this :

$string = $id . "," . $firstname . "," . $lastname . "," . $address . "," . $phone;

file_put_contents("ouput.csv", $string."\n", FILE_APPEND);

answered Jan 25, 2016 at 7:19

Ijas Ahamed N

6,2486 gold badges33 silver badges55 bronze badges

2 Comments

Evert Over a year ago

Also not necessarily correct. this will 100% fail if your address contains a comma or newline for example. Pretty bad idea

Cano64 Over a year ago

This is a really bad answer.

Cano64 · Accepted Answer · 2016-01-25 18:01:00Z

0

Check fputcsv function in the manual.

From the example in the manual:

$list = array (
    array('aaa', 'bbb', 'ccc', 'dddd'),
    array('123', '456', '789'),
    array('"aaa"', '"bbb"')
);

$fp = fopen('file.csv', 'w');

foreach ($list as $fields) {
    fputcsv($fp, $fields);
}

fclose($fp);
?>

answered Jan 25, 2016 at 18:01

Cano64

2371 gold badge2 silver badges8 bronze badges

Comments

Rahul · Accepted Answer · 2016-01-29 12:19:10Z

0

I got best Solution to separately save data column wise. fputcsv is able to handle large no of records very efficiently. also if the content with escape characters like , "" '' it will still add data properly in csv file ..

fputcsv($csvfileoutput, array($id,$firstname,,$lastname, $address,$mobilenumber));

edited Jan 29, 2016 at 12:19

answered Jan 29, 2016 at 12:14

Rahul

7261 gold badge12 silver badges49 bronze badges

Collectives™ on Stack Overflow

Store PHP Variable in CSV file

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related