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 vote359 views1 answer
CURL error 6: Could not resolve host: api.themoviedb.org (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://api.themoviedb.org/3/movie/popular?api_key=5cb73b68870b70a436b10ea06298de07
PHP
0 vote300 views2 answers
Laravel storage link without command line
PHP
2 votes350 views1 answer
Multiple logical condition in laravel query
PHP Laravel
4 votes318 views2 answers
Cascade in laravel migration
PHP
4 votes299 views3 answers
Nl2br php
PHP
33 votes271 views6 answers
Laravel make:auth
PHP
24 votes327 views3 answers
Upppercase php
PHP
14 votes300 views4 answers
Php get current domain
PHP
1 vote317 views2 answers
Linux set alternatives /etc/alternatives
PHP
4 votes357 views3 answers
Php get size of file
PHP