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

0 vote296 views2 answers
Php decrement variable
PHP
0 vote312 views1 answer
Laravel price database
PHP
5 votes284 views2 answers
Memory limit wordpress
PHP
7 votes320 views2 answers
Date time format for laravel validation
PHP
0 vote321 views1 answer
Wpml get site url
PHP
0 vote303 views1 answer
Php get hour
PHP
2 votes359 views2 answers
How to restart php-fpm on ubuntu
PHP
0 vote301 views1 answer
Hoew to store a cookie php
PHP
1 vote341 views4 answers
Laravel form request validation api
PHP Laravel
0 vote323 views1 answer
Brew remove php
PHP