Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $app_directory = dirname(BASEPATH);
- $export_location = $app_directory . '/assets/exports/';
- $filename = "export-" . date('Y-m-d H-i-s') . ".csv";
- $export_location = $export_location . $filename;
- $query = $this->db->query("
- SELECT users.id, users.firstname, users.lastname, users.email, users.dob, messages.line1, messages.line2, messages.line3, messages.barcode_selected, address.my_address, address.firstname, address.lastname, address.address1, address.address2, address.town, address.postcode, address.datecreated
- FROM users
- JOIN messages
- ON users.id = messages.user_id
- JOIN address
- ON users.id = address.user_id
- INTO OUTFILE '$export_location'
- FIELDS TERMINATED BY ','
- LINES TERMINATED BY '\r\n'
- ");
Add Comment
Please, Sign In to add comment