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 vote140 views1 answer
Validate audio file in laravel
PHP
7 votes155 views4 answers
Str slug laravel
PHP Laravel
0 vote140 views1 answer
Validate file count with validate in laravel
PHP
4 votes141 views4 answers
Carbon get day name
PHP
1 vote159 views1 answer
Laravel storage check file exists
PHP Laravel
0 vote146 views1 answer
Vivo.sx api php
PHP
0 vote167 views1 answer
Yii1 anchor tag
PHP
4 votes129 views1 answer
How to check query execution time in php
PHP
0 vote135 views1 answer
Pregmatch php only numbers and comma and dot
PHP
0 vote157 views1 answer
How check the time of operation in laravel
PHP