PHP csv operation

Write Data for CSV: [PHP]View Plaincopyprint?

2. $data = Array (
4. Array (' QQ number ',' login time ', 'name '),
6. Array (' 123456 ',' 2012-08-21 15:21:10 '. Chr (1),' I'm here to test '),
8. Array (' 56788 ',' 2012-08-21 18:21:20 '. Chr (1),' test data '),
10. Array (' 321789 ',' 2012-08-21 11:21:25 '. Chr (1),' HELLO ')
12. );
14. $filename = "./file/test.csv";
16. if (! File_exists ( $filename)) {
18. File_put_contents ($filename, ");
20. }
22. $file = fopen ($filename, ' W ');
24. foreach ( $data as $val) {
26. if (false = = = Fputcsv ($file, $val)) {
28. Die (' Write data failed ');
30. }
32. }
34. Fclose ($file);

$data = Array (' QQ number ', ' Login time ', ' name '), Array (' 123456 ', ' 2012-08-21 15:21:10 '. chr (1), ' I'm here to test '), Array (' 56788 ', ' 2012-08-21 18:21:20 '. chr (1), ' test data '), Array (' 321789 ', ' 2012-08-21 11:21:25 '. chr (1), ' HELLO ')); $filename = "./file/ Test.csv ", if (!file_exists ($filename)) {file_put_contents ($filename, ');} $file = fopen ($filename, ' W '); foreach ($data as $val) {if (false = = = Fputcsv ($file, $val)) {die (' Write Data Failed ')}} Fclose ($file);

There was a problem with my date format when I wrote to CSV, only the format was: 2011/06/05 12:02. Cause my number of seconds does not exist, so at the back of time to add Chr (1) to get the correct format

CSV Read data:

[PHP]View Plaincopyprint?

1. $file = fopen ($filename, ' W ') or Die (' Open file failed ');
2. Read data
3. $file = fopen ($filename, ' R ');
4. while ( $val = fgetcsv ($file)) {
5. Print_r ($val);
6. }
7. Fclose ($file);

$file = fopen ($filename, ' w ') or Die (' Open file failed ');//Read Data $file =  fopen ($filename, ' R '); while ($val = Fgetcsv ($file)) {pri Nt_r ($val);} Fclose ($file);

Download of CSV:

[PHP]View Plaincopyprint?

2. $data = Array (
4. Array (' QQ number ',' login time ', 'name '),
6. Array (' 123456 ',' 2012-08-21 15:21:10 '. Chr (1),' I'm here to test '),
8. Array (' 56788 ',' 2012-08-21 18:21:20 '. Chr (1),' test data '),
10. Array (' 321789 ',' 2012-08-21 11:21:25 '. Chr (1),' HELLO ')
12. );
18. Download function
20. $date = time ();
22. Header ("Content-type:text/csv");
24. Header ("content-disposition:attachment; Filename= ". $date. ". csv");
26. Header (' cache-control:must-revalidate,post-check=0,pre-check=0 ');
28. Header (' expires:0 ');
30. Header (' pragma:public ');
32. foreach ( $data as $val) {
34. Echo Implode (",", $val)." \ n ";
36. }
38. ----------------------------------------------------------------------------

40. <?php
    $filename = "./creattest.csv";
    Read data
    $file = fopen ($filename, ' R ');
    $prex = "Linpre";
    while ($val = Fgetcsv ($file)) {
    Print_r ($val);
    echo "$val _list[] = $val;
    }
    $val _list[0][0] = $prex. $val _list[0][0];
    $val _list[1][0] = $prex. $val _list[1][0];
    Echo $val _list[0][0]. " ------------";
    $file = fopen ($filename, ' w ');
    foreach ($val _list as $list) {
    if (false = = = Fputcsv ($file, $list)) {
    Die (' Write data failed ');
    }}
    Fclose ($file);

PHP csv operation