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/lnovel/code/ajax/ |
<?php
$keyword = $CORE->input['keyword'] ?? '';
if($keyword==''){ return; }
$where = " AND truyen_active_status='Active' AND truyen_sochuong is not NULL ";
$where .= " AND (truyen_name LIKE '%".$keyword."%' OR truyen_fname LIKE '%".$keyword."%' OR truyen_othername LIKE '%".$keyword."%') ";
$query = $DB->query("
SELECT truyen_id,truyen_name,truyen_fname,truyen_othername,truyen_thumb,truyen_theloai,truyen_chuong_moinhat_id,truyen_chuong_moinhat_name,truyen_chuong_moinhat_fname,truyen_chuong_moinhat_isnew,truyen_chuong_moinhat_time
FROM tb_truyen
WHERE 1 ".$where."
ORDER BY time_post DESC LIMIT 0,10
");
$list = '';
while ($row = $DB->fetch_row($query)){
$txt_other_name = '';
if(!empty($row['truyen_othername'])){
$txt_other_name = '<i>'.$row['truyen_othername'].'</i>';
}
$list .= '<li><a href="/'.$row['truyen_fname'].'-'.$row['truyen_id'].'/">
<img src="'.$row['truyen_thumb'].'" alt="'.$row['truyen_name'].'">
<h3>'.$row['truyen_name'].'</h3>
<h4>
'.$txt_other_name.'
<i>'.$row['truyen_theloai'].'</i>
<i><b>'.$row['truyen_chuong_moinhat_name'].'</b> - '.$func->time_site($row['truyen_chuong_moinhat_time']).'</i>
</h4>
</a>
</li>';
}
echo $list;
exit();
?>