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 vote218 views1 answer
Validate file count with validate in laravel
PHP Laravel
20 votes177 views6 answers
Print array php
PHP
2 votes167 views2 answers
Laravel select query return array
PHP Laravel
4 votes199 views4 answers
Wp enqueue styles
PHP Wordpress
0 vote181 views1 answer
Php formData curl
PHP
0 vote222 views1 answer
Return single row from eloquent all collection laravel
PHP Laravel
9 votes197 views3 answers
Php date object to timestamp
PHP
0 vote170 views1 answer
Carbon this month first day
PHP
2 votes178 views3 answers
Php reverse string
PHP
0 vote207 views1 answer
Php endwhile
PHP