Created
November 18, 2018 12:57
-
-
Save klebinhopk/360c17a6fea284620bfba6f8e13e1466 to your computer and use it in GitHub Desktop.
PHP, PDO, EXPORT, EXPORT TO CSV: Use PDO to create a standalone php script for use in cron jobs where codeigniter urls can't be run by cron
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
if (isset($_SERVER['REMOTE_ADDR'])) { | |
die(':)'); | |
} | |
echo "Cron is running"; | |
$hostname = 'localhost'; | |
$username = 'cl50-whiskey_p'; | |
$password = 'rmBRsm!kK'; | |
$myDatabase = 'cl50-whiskey_p'; | |
try { | |
$conn = new PDO('mysql:host=localhost;dbname='.$myDatabase, $username, $password); | |
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | |
$stmt = $conn->prepare("SELECT users.id AS ui, users.firstname AS uf, users.lastname AS ul, users.email AS ue, users.dob AS ud, messages.line1 AS ml1, messages.line2 AS ml2, messages.line3 AS ml3, messages.line4 AS ml4, messages.barcode_selected AS mb, address.my_address AS am, address.firstname AS af, address.lastname AS al, address.address1 AS aa1, address.address2 AS aa2, address.town AS at, address.postcode AS ap, address.datecreated AS ad | |
FROM users | |
JOIN messages | |
ON users.id = messages.user_id | |
JOIN address | |
ON users.id = address.user_id"); | |
$stmt->execute(); | |
$filelocation = 'assets/exports/'; | |
$filename = 'export-'.date('Y-m-d H.i.s').'.csv'; | |
$file_export = $filelocation . $filename; | |
$data = fopen($file_export, 'w'); | |
$csv_fields = array(); | |
$csv_fields[] = 'id'; | |
$csv_fields[] = 'firstname'; | |
$csv_fields[] = 'lastname'; | |
$csv_fields[] = 'email'; | |
$csv_fields[] = 'dob'; | |
$csv_fields[] = 'line1'; | |
$csv_fields[] = 'line2'; | |
$csv_fields[] = 'line3'; | |
$csv_fields[] = 'line4'; | |
$csv_fields[] = 'barcode_selected'; | |
$csv_fields[] = 'my_address'; | |
$csv_fields[] = 'firstname'; | |
$csv_fields[] = 'lastname'; | |
$csv_fields[] = 'address1'; | |
$csv_fields[] = 'address2'; | |
$csv_fields[] = 'town'; | |
$csv_fields[] = 'postcode'; | |
$csv_fields[] = 'datecreated'; | |
fputcsv($data, $csv_fields); | |
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { | |
fputcsv($data, $row); | |
} | |
} catch(PDOException $e) { | |
echo 'ERROR: ' . $e->getMessage(); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment