singollo

Query-to-CSV

Feb 15th, 2021 (edited)
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.31 KB | None | 0 0
  1. <?php
  2. $pdo = new PDO('dns', 'user', 'password');
  3. $stmt= $pdo->query("select * from `source_table`");
  4. $smt->execute();
  5. $row = $stmt->fetch();
  6. if (!$row) die();
  7. $fp = fopen('report.csv', 'w');
  8. fputcsv($fp, array_keys($row));
  9. do {
  10.     fputcsv($fp, $row);
  11. } while (($row = $stmt->fetch()) !== false)
  12. fclose($fp);
Add Comment
Please, Sign In to add comment