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 vote194 views5 answers
Download file laravel s3
PHP
5 votes229 views6 answers
Array to string conversion php
PHP
20 votes194 views6 answers
Php get random value from array
PHP
0 vote191 views1 answer
Twig superglobal
PHP
0 vote239 views1 answer
Laravel request input default value
PHP Laravel
1 vote181 views3 answers
Calculate time difference php
PHP
10 votes261 views3 answers
Convert array to json online
PHP
0 vote199 views1 answer
Date Format Conversion in controller or Blade file
PHP
22 votes221 views1 answer
Php difference between two dates in years months and days
PHP
0 vote218 views1 answer
Wordpress exclude current post from loop
PHP Wordpress