PHP - Fputcsv Help

Hi guys,
 
I've got quite a few fields in my tables that i've serialised to keep the number of fields down. For everything else that works perfect as it stores the data and when needed I can use the following as an example:

$dateofbirth = unserialize($row['dateofbirth']);
$dobday = $dateofbirth[0];
$dobmonth = $dateofbirth[1];
$dobyear = $dateofbirth[2];

 

 
Date of birth is stored as dd,mm,yyyy and for everything else I can call it fine. My issue is now that i'm trying to use fputcsv to create a csv file using the following:

$result = mysqli_query($con, 'SELECT u.user_id, b.dateofbirth FROM Users u INNER JOIN Basic b USING (user_id) ORDER BY user_id DESC');


$fp = fopen('latest.csv', 'w');
 
fputcsv($fp, array('User ID', 'DOB' ));

 
 
 
The CSV generates, but for the date of birth column in the csv it outputs as "a:3:{i:0;s:2:"03";i:1;s:2:"02";i:2;s:4:"1986";}" because it's obviously still serialised. What is my best and or easiest way of handling these fields?
 
Many thanks in advance.
Edited by Kristoff1875, 21 January 2015 - 05:24 AM.

We had to update our Linux server from php 5.4 to php 7.4.  Something has changed and I have a feeling it is due to changes in fputcsv.

When running the code below, instead of opening a csv file in libre calc, it fills the browser with the result.  Is there a way of fixing this so I get the csv file again?

<code>date_default_timezone_set("America/New_York");
$filename = "import.csv";
$fp = fopen('php://output', 'w');
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);
$then = time() - 3601;
$query = "SELECT * FROM ppb_listings where user_id = '4' and unix_timestamp(start_time) > $then";
$result = mysqli_query($conn, $query);
while($row = mysqli_fetch_row($result)) {
    fputcsv($fp, $row);
}
echo $result;
exit;
?>

</code>

Thanks for any help.

I'm trying to write a new csv file using the data from a large 1.4gb csv file. The problem is that its not working with the code I have below. It just hangs up when the size of output (tempfile) reaches 848661. Any ideas?

$file = "file.csv";
    $file_number = 1;
    if (!$output = fopen($tempfile, 'w')) {
        unlink($tempfile);
        die('could not open temporary output file');
    }

    $in_data = array();
    $header = true;
    $row = 0;
    while (($data = fgetcsv($handle, 0, $delimiter)) !== FALSE) {
        if ($header) {
            $in_data[] = $headers;
            fputcsv($output, $headers, "\t");
            $header = false;
            continue;
        }
/*
                if ( ($row % 10) == 0 ){
error_log("sleeping on row: $row");
                    sleep(3);
                }
error_log("checking row: $row");
*/
                if (!$val = getProductRow($data)) //this returns an array
                    continue;

                $stat = fstat($output);
error_log("Stat is: " . print_r($stat['size'],true));
                if($stat['size'] > 9437184){
error_log("saving the $file");
                    fputcsv($output, $val, "\t");
error_log(__LINE__);
                    fclose($output);
error_log(__LINE__);
                    if (file_exists($file))
                        unlink($file);
error_log(__LINE__);
                    rename($tempfile, $file);
error_log(__LINE__);
                    chmod($file, 0777);
error_log(__LINE__);
                    $final_file_name = $file = "file$file_number.csv";
error_log(__LINE__);
                    $tempfile = tempnam(".", "tmp"); // produce a temporary file name, in the current directory
error_log("creating the $file");
                    if (!$output = fopen($tempfile, 'w')) {
error_log(__LINE__);
                        unlink($tempfile);
                        die('could not open temporary output file');
                    }
error_log(__LINE__);
                    fputcsv($output, $headers, "\t");
error_log(__LINE__);
                    $file_number++;
error_log(__LINE__);
                    continue;
                }

error_log(__LINE__);
                fputcsv($output, $val, "\t");
            }