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 vote209 views1 answer
Download image from mysql using php
PHP
0 vote204 views1 answer
Stripe cards
PHP
191 votes340 views1 answer
Php pdo error handling
PHP
33 votes200 views4 answers
Php ucwords
PHP
0 vote231 views1 answer
If condition view page of laravel
PHP Laravel
8 votes252 views6 answers
Define table name in model laravel
PHP Laravel
0 vote226 views1 answer
Wp wc php if not is single product page
PHP
5 votes217 views3 answers
Wordpress get_permalink
PHP Wordpress
-2 votes222 views3 answers
Laravel where condition with if
PHP
0 vote197 views1 answer
WithErrors laravel
PHP