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 vote128 views1 answer
Wp_login_form wrong password redirect
PHP
0 vote130 views1 answer
Laravel dingo api response
PHP
1 vote174 views1 answer
Update many laravel
PHP Laravel
1 vote127 views2 answers
Wordpress login programmatically
PHP
2 votes178 views1 answer
Tl to usd
PHP
38 votes131 views6 answers
Convert object to array
PHP
8 votes121 views4 answers
Php carbon get timestamp
PHP
0 vote100 views1 answer
Login with email or username codeigniter 4
PHP
0 vote132 views3 answers
Laravel pagination with search filter
PHP
8 votes181 views6 answers
Relationship in laravel
PHP Laravel