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 vote122 views1 answer
What is errore Personal access client not found. Please create one in laravel
PHP Laravel
0 vote126 views1 answer
Doiffernce between text and string in laravel migration
PHP Laravel
0 vote139 views1 answer
Php script to encrypt an input
PHP
0 vote86 views1 answer
Launch new tab and refresh original page codeigniter
PHP CodeIgniter
0 vote96 views1 answer
Export PATH=/Applications/MAMP/bin/php/php5.4.10/bin:$PATH
PHP
0 vote112 views2 answers
Laravel roles and permissions
PHP Laravel
0 vote93 views1 answer
Non static method 'loadView' should not be called statically.intelephense(1036)
PHP
0 vote94 views1 answer
Function id codeigniter 3
PHP
0 vote113 views1 answer
Laravel redis sentinel
PHP Laravel
5 votes95 views3 answers
Laravel get parameters from request
PHP