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 vote285 views1 answer
Wordpress on publish hook
PHP
13 votes299 views4 answers
Laravel login by id
PHP Laravel
2 votes294 views1 answer
Wordpress display all variables
PHP
73 votes301 views6 answers
Php str to int
PHP
10 votes296 views6 answers
Php time()
PHP
5 votes285 views1 answer
A non well formed numeric value encountered
PHP
1 vote336 views1 answer
Using middleware auth laravel in controller constructor
PHP Laravel
0 vote249 views1 answer
Laravel foreach localstorage
PHP Laravel
0 vote295 views1 answer
Php static dropdown list example
PHP
0 vote290 views1 answer
Laravel model where set fields laravel
PHP Laravel