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

2 votes295 views1 answer
Laravel artisan create criteria
PHP Laravel
0 vote242 views1 answer
Array & multi-dimensional array
PHP
0 vote374 views1 answer
Yii1 anchor tag
PHP Yii
0 vote276 views3 answers
Oop php
PHP
1 vote238 views1 answer
Php foiz
PHP
0 vote240 views1 answer
Yajra laravel datatables rawcolumn
PHP
0 vote242 views1 answer
Adding n days to a DATETIME format value
PHP
0 vote249 views1 answer
Relationship on the base of condition in laravel
PHP
0 vote230 views1 answer
Auth.php Class "\App\User" not found
PHP
0 vote258 views1 answer
Php explode multiple delimiters
PHP