Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/netphim/code/admin/server/ |
<?php
$txt_where = '';
$keyword= '';
if(isset($CORE->input['search']) && $CORE->input['search']!=''){
$keyword= trim($CORE->input['search']);
}
$v_where_clause = " AND author_fname!='' ";
if($keyword!=''){
$v_where_clause .= " AND (author_name LIKE '%".$keyword."%' OR author_fname LIKE '%".$keyword."%' OR author_id LIKE '%".$keyword."%') ";
}
$pageNum = (isset($_GET['pageNum'])) ? intval($_GET['pageNum']) : 1;
$pageSize = 20 ;
$from = (($pageNum * $pageSize) - $pageSize);
$row_total = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_author WHERE 1 ".$v_where_clause." "));
$total = $row_total['total'];
$totalPage = ceil($total/$pageSize);
$q_author = $DB->query("SELECT * FROM tb_author WHERE 1 ".$v_where_clause." ORDER BY author_fname LIMIT $from,$pageSize ");
$txt_list = '';
while($r_author = $DB->fetch_row($q_author)){
$list_author['id'] = $r_author['author_fname'];
$list_author['text'] = $r_author['author_name'];
$list['results'][] = $list_author;
}
if(!empty($list['results'])) {
$list['pagination']['more'] = true;
}else{
$list['pagination']['more'] = false;
}
echo json_encode($list);
exit();
?>