Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- define('INC', 1);
- include "config.php";
- error_reporting(1);
- $select = "select * from staff_on_call ";
- $export = $db->query($select);
- /*
- mana error controllernya dimana akan dikasi tau kl export gagal ato tidak??
- */
- if($export === false){ die('error'); }
- $fields = $export->columnCount();
- $header=$data='';
- for ($i = 0; $i < $fields; $i++) {
- $header .=$export->getColumnMeta($i) . "\t";
- }
- while($export->rowCount()) {
- $line = ''; foreach($row as $value) {
- if ((!isset($value)) OR ($value == "")) {
- $value = "\t";
- } else {
- $value = str_replace('"', '""', $value);
- $value = '"' . $value . '"' . "\t";
- }
- $line .= $value;
- } // while
- $data .= trim($line)."\n";
- }
- $data = str_replace("\r"," ",$data);
- if ($data == "") {
- $data = "n(0) record found!\n";
- }else{ }
- $tanggal=date("Ymd");
- header("Content-type: application/x-msdownload");
- header("Content-Disposition: attachment; filename=pendaftar_".$tanggal.".csv");
- header("Pragma: no-cache");
- header("Expires: 0");
- print "$header\n$data";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement