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

1 vote141 views1 answer
What is app_env in laravel
PHP
0 vote135 views1 answer
Php library to convert html to amp
PHP
3 votes109 views1 answer
Laravel inrandomorder
PHP Laravel
1 vote153 views2 answers
Laravel get url parameter value in controller
PHP Laravel
3 votes182 views3 answers
Get order details by id woocommerce
PHP
3 votes137 views6 answers
Add to collection laravel
PHP
7 votes250 views5 answers
Search laravel
PHP Laravel
0 vote276 views1 answer
Download yii 1.1
PHP Yii
0 vote163 views2 answers
Laravel filesystem
PHP Laravel
18 votes140 views6 answers
Where clause in laravel
PHP