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 vote177 views1 answer
What is the name of scripting engine in PHP?
PHP
0 vote241 views1 answer
How-to-call-ajax-in-wordpress
PHP
0 vote179 views1 answer
Php get directory
PHP
0 vote214 views3 answers
Not Found The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/8.0.6 Server at localhost Port 80
PHP
0 vote212 views1 answer
How to share count of things to sidebar in laravel
PHP Laravel
0 vote167 views1 answer
Add auth middleware to route laravel
PHP
1 vote262 views2 answers
Laravel collection implode
PHP Laravel
0 vote298 views1 answer
Drupal 8 $_GET
PHP Drupal
0 vote224 views1 answer
Laravel optional params
PHP Laravel
28 votes205 views5 answers
Migrate specific table laravel
PHP Laravel