Databases
StackOverflow2013
Postsdbo
POExporting CSV | Weird Behaviour
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExporting CSV | Weird Behaviour
    primarykey
    data
    text
    <p>So, I think that I have asked this question and others related to it for more than twice. But I cannot figure out what's happening.</p> <p>I'm using this PHP function to export some data from a table to a CSV table. I am testing on local host ( XAAMP ):</p> <pre><code>// Export CSV By User Level public function CSVData($path, $level) { switch ($level) { case 0: $filename = $path."/standard_members_".date('Y')."_".date('m')."_".date('d').".csv"; break; case 1: $filename = $path."/special_members_".date('Y')."_".date('m')."_".date('d').".csv"; break; case 2: $filename = $path."/admin_members_".date('Y')."_".date('m')."_".date('d').".csv"; break; default: break; } $sql = "SELECT user_name, user_username, user_email, user_register_date INTO OUTFILE '$filename' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM users WHERE user_level = '$level'"; if ($stmt = $this-&gt;connect-&gt;prepare($sql)) { if(!($stmt-&gt;execute())){ print_r($stmt-&gt;error); } $stmt-&gt;close(); } else { $error = true; $message['error'] = true; $message['message'] = CANNOT_PREPARE_DATABASE_CONNECTION_MESSAGE; return json_encode($message); } if(!is_file($filename)) { die('file not found'); } else { header('Content-Type: application/csv'); header("Content-Disposition: attachment; filename=$filename"); header('Expires: 0'); header('Pragma: no-cache'); readfile($filename); } } </code></pre> <p>And I have a form that performs the action, I mean it submits the action to the PHP file which processes the above function, and this is the action code:</p> <pre><code>&lt;?php include '../assets/class/login/loginsys.php'; $extension = new extension; if ($_GET['action'] == 0) { $extension-&gt;CSVData('exports', 0); } elseif ($_GET['action'] == 1) { $extension-&gt;CSVData('exports', 1); } elseif ($_GET['action'] == 2) { $extension-&gt;CSVData('exports', 2); } exit(); ?&gt; </code></pre> <p>What happens is the following:</p> <p>-when I click the submit button on the form I have it sends either the value 0, 1 or 2 to the action code; -the action code gets the value and processes accordingly; -but if I haven't created the folder 'exports' on localhost if would have given me this error:</p> <pre><code>Can't create/write to file 'C:xampphtdocsloginadminexports\standard_members_2012_01_28.csv' (Errcode: 2); </code></pre> <p>-and I have created it so it can work; -now that the folder it's there the CSV file is created and the data is dumped into the CSV table; -but the file that opens in my browser ( the attachment that downloads like you'd click on a file from some website and downloaded it ) it's empty even though the file exported in 'exports' has the data in it; -and another thing is that when the file already exists in the folder 'exports' the table that is created is tells me:</p> <pre><code>File 'exports/admin_members_2012_01_29.csv' already exists </code></pre> <p>So my question is why is what I described happening ? And is there a way to make the MySql query overwrite the previous CSV file ?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USRoland
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThis SO answer will help, http://stackoverflow.com/questions/960627/mysql-into-outfile-overide-existing-file you cant overwrite the outputted file so you would need to name the file uniquely with a microtime or move the outputted file elsewhere before creating a new backup..
      singulars
      1. POExporting CSV | Weird Behaviour
      1. USLawrence Cherone
    2. COVoting to close this as "too localized", but here's a few hints for you to consider: What have you done to track down this bug? What options have you considered and tested? Where do you output the file to the browser? Are you reading the file from the same folder as MySQL does? Why don't you check for file existence before running the SQL query?
      singulars
      1. POExporting CSV | Weird Behaviour
      1. USEmil Vikström
    3. CO@EmilVikstrom - I don't know what to do to track down the bug. The code you see is what I tested, it exports the file as described but the file downloaded by the browser is empty. I output it in a folder on my hard drive, a separate partition, not the one my OS is, but any other file behaves as it suppose to ( if I download something from a website ). I'm not sure, but no, I'm reading the file that is downloaded, but it shouldn't be empty right ? How do I check for the file existence ? I tried `if(!is_file($filename)){ unlink($filename); }` but still the file remains there.
      singulars
      1. POExporting CSV | Weird Behaviour
      1. USRoland
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload