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

92 votes187 views6 answers
Replace String in PHP
PHP
0 vote128 views1 answer
Orwherebetween laravel
PHP Laravel
2 votes113 views2 answers
Php check if input is int
PHP
0 vote84 views1 answer
Vue js mouseover event
PHP
1 vote156 views1 answer
Laravel queue work schedule cpanel
PHP Laravel
0 vote137 views1 answer
Wordpress if is not page template
PHP Wordpress
0 vote163 views6 answers
Update codeigniter
PHP CodeIgniter
0 vote128 views1 answer
Array filter multiple conditions php
PHP
1 vote130 views2 answers
Laravel session put method
PHP
2 votes130 views4 answers
Laravel print query with parameters
PHP