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

10 votes271 views3 answers
Php check weekday of date
PHP
0 vote257 views1 answer
Wordpress how to string multple function.php files together
PHP Wordpress
0 vote252 views1 answer
2 chiffres apres virgule php
PHP
0 vote245 views1 answer
Yum install php-mysql
PHP
24 votes318 views2 answers
Clear laravel cache and clear vue
PHP Laravel
10 votes270 views2 answers
Get element by index array php
PHP
1 vote257 views1 answer
Laravel Squashing Migrations
PHP
1 vote246 views1 answer
Php if negative make positive
PHP
5 votes275 views3 answers
Php.ini location mac
PHP
1 vote252 views1 answer
Request type PHP $SERVER
PHP