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

6 votes322 views4 answers
Laravel spatie asigne role
PHP Laravel
8 votes315 views6 answers
Laravel validation date
PHP Laravel
2 votes335 views1 answer
For loop php continue to next item
PHP
1 vote366 views1 answer
Laravel return list of ids
PHP Laravel
12 votes323 views2 answers
Creating a Basic Route in Laravel 8
PHP
0 vote445 views1 answer
Drupal 8 entity query
PHP Drupal
0 vote334 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
8 votes329 views6 answers
Codeigniter echo last query
PHP
47 votes307 views6 answers
Php array lenght
PHP
0 vote306 views1 answer
Define constructor in trait php
PHP