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 vote157 views1 answer
Get_the_id wordpress
PHP
0 vote133 views1 answer
Show widget using the shortcode from php
PHP
0 vote247 views1 answer
Php retour à la ligne
PHP
0 vote129 views1 answer
Failed to authenticate on SMTP server with username
PHP
0 vote184 views1 answer
Avoid sql injection in password field
PHP
0 vote178 views3 answers
Upload multiple files in codeigniter
PHP CodeIgniter
0 vote160 views0 answer
PHP
6 votes155 views4 answers
Laravel previous url
PHP Laravel
9 votes166 views5 answers
Php get day number
PHP
1 vote135 views3 answers
Laravel JSON query
PHP