$v = strtoupper($v); if (substr($v, 0, 1) == "+") { $SQL_APPEND .= " AND UPPER(CONCAT(`B`.`contents`,`B`.`keyword`)) LIKE ? "; $v = substr($v, 1); } else { $SQL_APPEND .= " OR UPPER(CONCAT(`B`.`contents`,`B`.`keyword`)) LIKE ? "; } array_push($PA, "%{$v}%"); } $SQL = "\r\n SELECT `B`.* FROM `ppt` as `A`,`ppt_items` as `B`\r\n WHERE\r\n 1=1\r\n AND `A`.`id`=`B`.`ppt_id`\r\n {$SQL_KIND}\r\n AND \r\n (\r\n 0 = 1\r\n {$SQL_APPEND} \r\n )\r\n \r\n ORDER BY \r\n `B`.`ppt_id` DESC,\r\n `B`.`id` ASC\r\n "; #pdo $SQL_ROWS = "SELECT COUNT(*) AS `COUNTER` FROM ({$SQL}) a"; $ra_counts = selectSQL_SAFE($SQL_ROWS, $PA); $totals_rows = $ra_counts[0]['COUNTER']; $SQL .= sprintf(" LIMIT %d,%d", $page * $p, $p); $ra = selectSQL_SAFE($SQL, $PA); ob_start(); array_page($totals_rows, $page, $p, $px, $new_Link, $mode = 'normal_ajax', $spandiv = ''); $thepage = ob_get_contents(); ob_end_clean(); $doc = array(); foreach ($ra as $v) { if (!isset($doc[$v['ppt_id']])) { $doc[$v['ppt_id']] = array(); } array_push($doc[$v['ppt_id']], $v); } unset($ra); $OUTPUT = array(); //$OUTPUT['data']=$ra; $OUTPUT['Gdata'] = $doc;
<?php require '../inc/config.php'; $GETS_STRING = "id"; $GETS = getGET_POST($GETS_STRING, "GET"); $FIELDS = "id,kind,title,計畫名稱,年度,簡報人,簡報類別,報告書類型,是否有拿到計畫,競爭對手,委員名單,評選心得,是否延續型計畫,orin_filename,filename,keyword,create_datetime,upload_datetime,author,pdf_status,png_status,text_status,has_single_page,download_counter,grades"; $mFIELDS = explode(",", $FIELDS); $SQL = "SELECT * FROM `ppt` WHERE `id` = ? LIMIT 1"; $ra = selectSQL_SAFE($SQL, array($GETS['id'])); $edit_title = ""; if (mb_strlen($ra[0]['orin_filename']) >= 15) { $edit_title = mb_substr($ra[0]['orin_filename'], 0, 10) . "..."; } else { $edit_title = $ra[0]['orin_filename']; } ?> <script language="javascript"> $(document).ready(function(){ <?php foreach ($mFIELDS as $v) { ?> $("#<?php echo $v; ?> ").val("<?php echo jsAddSlashes($ra[0][$v]); ?> "); $("#<?php echo $v; ?>