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

4 votes241 views2 answers
Php check if text is blank
PHP
5 votes252 views3 answers
Larael drop foreign key
PHP
36 votes291 views6 answers
Random string generator php
PHP
0 vote269 views1 answer
User order by role spatie laravel
PHP
0 vote451 views1 answer
Union for rwos
PHP
0 vote259 views1 answer
Logout php mysql
PHP
0 vote393 views1 answer
Comment désactiver la barre latérale Widgets sur des pages spécifiques WordPress
PHP Wordpress
2 votes307 views3 answers
Laravel model particular column
PHP
47 votes346 views6 answers
How to add new column in laravel migration
PHP Laravel
18 votes246 views6 answers
Where clause in laravel
PHP