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 vote321 views3 answers
Email or phone required in laravel
PHP
17 votes246 views5 answers
Wordpress debug mode
PHP
0 vote237 views1 answer
How to create header in csv file inphp
PHP
0 vote245 views1 answer
Onclick on image php
PHP
3 votes251 views1 answer
Laravel throw function
PHP Laravel
8 votes251 views3 answers
Laravel log query for model
PHP
8 votes245 views6 answers
Relationship in laravel
PHP
3 votes228 views3 answers
Convert stdclass object to array php
PHP
0 vote256 views1 answer
Get action name in yii2
PHP Yii
2 votes249 views2 answers
Laravel arrays
PHP