$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;
?>
