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

7 votes363 views3 answers
Laravel random query
PHP Laravel
134 votes596 views6 answers
Php find if string contains
PHP
1 vote339 views3 answers
Get next month first day php
PHP
0 vote331 views2 answers
Laravel sortby varchar date
PHP
4 votes341 views2 answers
Php array to console
PHP
2 votes313 views1 answer
Laravel mix purge css
PHP
0 vote361 views1 answer
Use font awesome in laravel 8
PHP
0 vote338 views1 answer
Many to many relationship in laravel example stackoverflow
PHP
2 votes351 views1 answer
Laravel carbon human readable
PHP Laravel
0 vote311 views1 answer
Laravel showing index of problem
PHP