คำสั่ง sql ผมยาวมากอ่ะ ผมจะตัดให้มันสั้น ผมใช้ $select_stmt = $conn->prepare("

$param = "%{$bookKey}%";
$sql="SELECT * FROM book B INNER JOIN categories C on B.cat_id = C.cat_id 
WHERE concat(B.book_nameTH,'|', B.book_nameEN,'|', B.book_aut1,'|', B.book_aut2,'|', B.book_aut3,'|', B.book_ISBN,'|', B.book_id,'|', B.book_ta) Like ? ";

$select_stmt = $conn->prepare( $sql); 
$select_stmt->bind_param('s', $param); 
$select_stmt->execute();

$sql = 'SELECT * FROM `table` WHERE `id` = :id AND (`date` = :date OR `lastdate` = :date)';
$sth = $dbh->prepare($sql, [\PDO::ATTR_CURSOR => \PDO::CURSOR_FWDONLY]);
$sth->execute([':id' => $myId, ':date' => $date]);