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 vote254 views1 answer
Laravel range query
PHP
0 vote257 views1 answer
Php script auf serve alle 5 minuten ausführen
PHP
0 vote299 views1 answer
Php artisan test
PHP
0 vote254 views1 answer
Hide add new link on cpt page
PHP
0 vote432 views1 answer
Laravel one session per user
PHP Laravel
0 vote355 views1 answer
Wp php blog info image
PHP Wordpress
0 vote276 views1 answer
Js redirect in php
PHP
28 votes277 views6 answers
How to get data from json array in php
PHP
115 votes405 views6 answers
How to iterate array in php
PHP
0 vote278 views2 answers
Laravel use global variable in model
PHP