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/api-truyentranh/includes/get/ |
<?php
global $DB, $func, $CORE, $INFO;
$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
");
$items = [];
while ($row = $DB->fetch_row($query)) {
$items[] = [
'id' => $row['truyen_id'],
'name' => $row['truyen_name'],
'fname' => $row['truyen_fname'],
'other_name' => $row['truyen_othername'],
'thumb' => $INFO['path_image'].'/'.$row['truyen_thumb'],
'genres' => $row['truyen_theloai'],
'latest_chapter' => [
'id' => $row['truyen_chuong_moinhat_id'],
'name' => $row['truyen_chuong_moinhat_name'],
'fname' => $row['truyen_chuong_moinhat_fname'],
'is_new' => $row['truyen_chuong_moinhat_isnew'],
'time' => $row['truyen_chuong_moinhat_time'],
'time_formatted' => $func->time_site($row['truyen_chuong_moinhat_time'])
],
'url' => '/' . $row['truyen_fname'] . '-' . $row['truyen_id'] . '/'
];
}
$result = [
'status' => true,
'status_note' => 'Success',
'data' => $items
];
echo jsonutf($result);
exit();
?>