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 vote241 views1 answer
Php extensions for apache2
PHP
1 vote264 views1 answer
Select sum in laravel
PHP
35 votes278 views6 answers
Php get current date and time
PHP
33 votes314 views6 answers
Laravel carbon
PHP Laravel
1 vote289 views2 answers
Array length php for loop
PHP
0 vote248 views1 answer
Configuration laravel dompdf
PHP
1 vote264 views1 answer
How to create controler in laravel
PHP
0 vote286 views1 answer
Supprimer automatiquement les mots courts des URL pour un meilleur SEO dans WordPress
PHP
3 votes330 views2 answers
Remove admin bar wordpress front end
PHP Wordpress
0 vote288 views2 answers
Unique sql queries laravel
PHP Laravel