'.__('You don\'t have enough privileges to access this area!').''); } if (isset($_POST['doExport'])) { // check for form validity if (empty($_POST['fieldSep']) OR empty($_POST['fieldEnc'])) { utility::jsAlert(__('Required fields (*) must be filled correctly!')); exit(); } else { // set PHP time limit set_time_limit(3600); // limit $sep = trim($_POST['fieldSep']); $encloser = trim($_POST['fieldEnc']); $limit = intval($_POST['recordNum']); $offset = intval($_POST['recordOffset']); if ($_POST['recordSep'] === 'NEWLINE') { $rec_sep = "\n"; } else if ($_POST['recordSep'] === 'RETURN') { $rec_sep = "\r"; } else { $rec_sep = trim($_POST['recordSep']); } // fetch all data from biblio table $sql = "SELECT m.member_id, m.member_name, m.gender, mt.member_type_name, m.member_email, m.member_address, m.postal_code, m.inst_name, m.is_new, m.member_image, m.pin, m.member_phone, m.member_fax, m.member_since_date, m.register_date, m.expire_date, m.birth_date, m.member_notes FROM member AS m LEFT JOIN mst_member_type AS mt ON m.member_type_id=mt.member_type_id "; if ($limit > 0) { $sql .= ' LIMIT '.$limit; } if ($offset > 1) { if ($limit > 0) { $sql .= ' OFFSET '.($offset-1); } else { $sql .= ' LIMIT '.($offset-1).',99999999999'; } } // for debugging purpose only // die($sql); $all_data_q = $dbs->query($sql); if ($dbs->error) { utility::jsAlert(__('Error on query to database, Export FAILED!')); } else { if ($all_data_q->num_rows > 0) { header('Content-type: text/plain'); header('Content-Disposition: attachment; filename="senayan_member_export.csv"'); while ($member_data = $all_data_q->fetch_assoc()) { $buffer = null; foreach ($member_data as $fld_data) { $fld_data = $dbs->escape_string($fld_data); // data $buffer .= $encloser.$fld_data.$encloser; // field separator $buffer .= $sep; } // remove the last field separator $buffer = substr_replace($buffer, '', -1); echo $buffer; echo $rec_sep; } exit(); } else { utility::jsAlert(__('There is no record in membership database yet, Export FAILED!')); } } } exit(); } ?> submit_button_attr = 'name="doExport" value="'.__('Export Now').'" class="button"'; // form table attributes $form->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $form->table_header_attr = 'class="alterCell" style="font-weight: bold;"'; $form->table_content_attr = 'class="alterCell2"'; /* Form Element(s) */ // field separator $form->addTextField('text', 'fieldSep', __('Field Separator').'*', ''.htmlentities(',').'', 'style="width: 10%;"'); // field enclosed $form->addTextField('text', 'fieldEnc', __('Field Enclosed With'), ''.htmlentities('"').'', 'style="width: 10%;"'); // record separator $rec_sep_options[] = array('NEWLINE', 'NEWLINE'); $rec_sep_options[] = array('RETURN', 'CARRIAGE RETURN'); $form->addSelectList('recordSep', __('Record Separator'), $rec_sep_options); // number of records to export $form->addTextField('text', 'recordNum', __('Number of Records To Export (0 for all records)'), '0', 'style="width: 10%;"'); // records offset $form->addTextField('text', 'recordOffset', __('Start From Record'), '1', 'style="width: 10%;"'); // output the form echo $form->printOut();