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 vote354 views1 answer
Clear and delete the folder after the time specified in php
PHP
8 votes290 views3 answers
Php get timezone
PHP
2 votes325 views3 answers
Laravel Create Custom Artisan Command
PHP
0 vote313 views1 answer
Sanctum
PHP
2 votes308 views2 answers
Laravel create migration file
PHP Laravel
0 vote346 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP Laravel
0 vote311 views1 answer
Twig for loop key
PHP
0 vote291 views1 answer
Get row ezSql | select on ezSql
PHP
1 vote355 views1 answer
Laravel string builder
PHP Laravel
0 vote293 views1 answer
Array issue in php
PHP