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 vote188 views1 answer
Remove public or index file from url in laravel
PHP Laravel
15 votes182 views2 answers
Update column value laravel
PHP
0 vote200 views1 answer
What is type-hinting in php
PHP
0 vote172 views1 answer
Php docblock
PHP
0 vote548 views1 answer
Failed opening required 'PHPMailer\PHPMailer\PHPMailer'
PHP
2 votes179 views2 answers
Laravel has table
PHP Laravel
100 votes200 views6 answers
Php substr_replace
PHP
0 vote155 views1 answer
Laravel mixed content error
PHP
1 vote180 views1 answer
Use model from variable laravel
PHP
0 vote178 views1 answer
Php pdo random multiple insert query
PHP