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 vote185 views1 answer
Access config variable in codeigniter controller
PHP
0 vote209 views1 answer
User order by role spatie laravel
PHP Laravel
2 votes169 views1 answer
Php discord webhook
PHP
0 vote197 views1 answer
Copy folder contect to anthor folder php
PHP
0 vote279 views1 answer
Non-static method Barryvdh\DomPDF\PDF::loadView() should not be called statically
PHP
9 votes174 views4 answers
Add another field in existing migration laravel
PHP
1 vote210 views1 answer
Add zeros in front of number php
PHP
18 votes161 views6 answers
Laravel log error
PHP
9 votes199 views3 answers
Image validate in laravel validater
PHP Laravel
5 votes245 views3 answers
Laravel eloquent duplicate record
PHP Laravel