"SELECT * FROM `test` WHERE `title` LIKE '%$text%' ORDER BY `pubdate` DESC"

$stmt
=
$db
-
>
prepare
(
"SELECT * FROM `test` WHERE `title` LIKE ? ORDER BY `pubdate` DESC"
)
;
$searchText
=
"%$text%"
;
$stmt
-
>
bind_param
(
"s"
,
$searchText
)
;
$stmt
-
>
execute
(
)
;
$result
=
$stmt
-
>
get_result
(
)
;