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

5 votes163 views4 answers
Php get time in milliseconds
PHP
12 votes180 views3 answers
Do_shortcode
PHP
0 vote187 views1 answer
Befreie den WordPress-Header von unnötigen Einträgen
PHP
4 votes207 views3 answers
Get current route in blade laravel
PHP Laravel
0 vote251 views1 answer
Wordpress Simple Membership button name
PHP Wordpress
0 vote136 views1 answer
Change file name during downloading laravel
PHP
0 vote148 views2 answers
Php bytes to mb
PHP
0 vote179 views1 answer
Loop laravel 8
PHP Laravel
2 votes154 views3 answers
Laravel blade time difference
PHP Laravel
1 vote165 views3 answers
Symfony start
PHP