I've created a PHP script that is supposed to take an array and generate a CSV file for each element in the array. However, there seems to be an issue as it's not saving any files in the specified directory. Strangely, no errors are being returned either. Can anyone spot the problem?
$ids = json_decode($_POST['jsonarray']); // receiving array via ajax
$start = $_POST['start']; // receiving date via ajax
$end = $_POST['end']; // receiving date via ajax
$start_date = date('yyyy-mm-dd', strtotime($start)); // formatting dates for SQL
$end_date = date('yyyy-mm-dd', strtotime($end));
$toZip = array(); // preparing array for zip
if(is_array($ids)) {
foreach ($ids as $key => $qr)
{
// Retrieving labels first
// Preparing the first line of the .CSV file
$tb = $qr . '_labels';
$sql = $user_pdo->query("SELECT * FROM $tb");
$head_array = array('Log ID', 'Timestamp');
while ($row = $sql->fetch(PDO::FETCH_ASSOC))
{
$head_array[] = $row['label'];
}
// Setting up for database looping
$table = $qr . '_data';
$results = $user_pdo->prepare("SELECT * FROM $table WHERE timestamp BETWEEN :start_date AND :end_date;");
$results->bindParam(':start_date', $start_date, PDO::PARAM_STR);
$results->bindParam(':end_date', $$end_date, PDO::PARAM_STR);
$results->execute();
// Determining filename and destination directory
$filename = "temp/db_user_export_".time().".csv";
// Creating the file
$handle = fopen($filename, 'w+');
// Writing column titles
fputcsv($handle, $head_array);
// Writing user records to the file
foreach($results as $row)
{
$rows = $row->rowCount();
$insert_array = array();
for ($i=0; $i<=$rows; $i++)
{
$insert_array[] = $row[$i];
}
fputcsv($handle, $insert_array);
}
// Finalizing the file
fclose($handle);
$toZip[] = $filename;
}
}
Example using var_dump($ids);
array(4) {
[0]=>
string(5) "t23ry"
[1]=>
string(5) "6us32"
[2]=>
string(5) "se43z"
[3]=>
string(5) "o00gq"
}