too long

Question

I have this PHP script which is supposed to take an SQL Query and output it to a CSV file, I know that when I run it i'm getting the right Statement put in but it does not seem to generate a file to my uploads folder.

Could anyone debug this for me?

<?php
function ExportExcel($statement)
{

$filename = "uploads/".strtotime("now").'.csv';

$sql = mysql_query("$statement") or die(mysql_error());

$num_rows = mysql_num_rows($sql);
if($num_rows >= 1)
{
$row = mysql_fetch_assoc($sql);
$fp = fopen($filename, "w");
$seperator = "";
$comma = "";

foreach ($row as $name => $value)
    {
        $seperator .= $comma . '' .str_replace('', '""', $name);
        $comma = ",";
    }

$seperator .= "
";
fputs($fp, $seperator);

mysql_data_seek($sql, 0);
while($row = mysql_fetch_assoc($sql))
    {
        $seperator = "";
        $comma = "";

        foreach ($row as $name => $value) 
            {
                $seperator .= $comma . '' .str_replace('', '""', $value);
                $comma = ",";
            }

        $seperator .= "
";
        fputs($fp, $seperator);
    }

fclose($fp);
echo "<a href='$filename'>Download</a>";
echo $statement;
}
else
{
    echo "error";
}


}
?>

If someone has a similar script that uses mysqli that would be nice

Answer 1

here is a example of a export script I use on my apps using MySqli. This will get you started...

<?php

    function ExportExcel($statement){

        $output = ""; 
        $sql = mysqli_query($db , $statement);
        $columns_total = mysqli_num_fields($sql);

        // Get The Field Name

        for ($i = 0; $i < $columns_total; $i++) {
        $heading = mysqli_fetch_field_direct($sql, $i);
        $output .= '"'.$heading->name.'",';
        }
        $output .="
";

        // Get Records from the table

        while ($row = mysqli_fetch_array($sql)) {
        for ($i = 0; $i < $columns_total; $i++) {
        $output .='"'.$row["$i"].'",';
        }
        $output .="
";
        }

        // Download the file

        $filename = "CSV_NAME_GOES_HERE.csv";
        header('Content-type: application/csv');
        header('Content-Disposition: attachment; filename='.$filename);

        echo $output;
        exit;

    }

?>