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 vote223 views1 answer
Laravel ErrorException Undefined variable: _SESSION
PHP Laravel
0 vote207 views1 answer
Mysql php update sum same table
PHP
2 votes181 views3 answers
Php access json object
PHP
0 vote180 views1 answer
"Illuminate\Database\Eloquent\MassAssignmentException"
PHP
0 vote216 views1 answer
Spatie/laravel-activitylog display only changed data
PHP
0 vote186 views1 answer
Php conditionally remove element from array
PHP
1 vote197 views1 answer
Laravel date rule before 18 years ago
PHP
1 vote173 views2 answers
How console log laravel
PHP
0 vote198 views1 answer
Laravel change db connection on the fly
PHP Laravel
2 votes224 views2 answers
Laravel many to many update all pivot
PHP Laravel