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

1 vote157 views1 answer
Update many laravel
PHP
0 vote180 views1 answer
Laravel where on relationsship column
PHP
0 vote250 views2 answers
Create curl api request php with para
PHP
0 vote532 views2 answers
Laravel composer sanctum
PHP Laravel
1 vote158 views1 answer
Modal form with php
PHP
0 vote199 views1 answer
Get All dates of a month with laravel carbon
PHP Laravel
3 votes157 views1 answer
Laravel loop through collection
PHP
0 vote252 views1 answer
Get_the_id wordpress
PHP Wordpress
1 vote257 views1 answer
Wordpress acf get checkbox options
PHP Wordpress
0 vote160 views1 answer
Laravel request protected prop
PHP