Pdo php search table

$search_keyword = '';
if(!empty($_POST['search']['keyword'])) {
	$search_keyword = $_POST['search']['keyword'];
}
$sql = 'SELECT * FROM posts WHERE post_title LIKE :keyword OR description LIKE :keyword OR post_at LIKE :keyword ORDER BY id DESC ';
...
...
$pdo_statement = $pdo_conn->prepare($query);
$pdo_statement->bindValue(':keyword', '%' . $search_keyword . '%', PDO::PARAM_STR);
$pdo_statement->execute();
$result = $pdo_statement->fetchAll();

Source: phppot.com

Similar codes

12 votes110 views4 answers
Php array remove empty values recursive
PHP
0 vote125 views1 answer
Laravel jwt check token sent by request is valid
PHP
0 vote131 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel
0 vote98 views2 answers
Php count words in string
PHP
0 vote143 views1 answer
$this meaning in codeigniter
PHP CodeIgniter
0 vote134 views1 answer
Laravel schedule kernel code sample
PHP Laravel
6 votes115 views2 answers
Laravel migration integer
PHP
32 votes111 views2 answers
Laravel sample controller
PHP
4 votes141 views1 answer
Php find multiple strings in string
PHP
0 vote111 views1 answer
Your Composer dependencies require a PHP version "><h1>HELLO THERE!</h1>
PHP