Pas buka index.php/?s=programmer
Hasilnya

Array

(

 [COUNT(*)] => 1

)

Itu yang ane harapkan dan ini kodenya :

if ($search) {



 // If visitor is searching

 $sql = $DBH->prepare("SELECT COUNT(*) FROM blog_posts

 WHERE post_title LIKE '%$search%' OR post_content LIKE '%$search%'");

 //$sql->bindParam(':search', $search);

 print_r($sql);

 // Useful for indexing

 $searh_param = "&s=".$search;



} else {

 // If visitor not searching then query all post

 $sql = $DBH->prepare("SELECT COUNT(*) FROM blog_posts"); 

}



$sql->execute();



$sql->setFetchMode(PDO::FETCH_ASSOC);

$total_post = $sql->fetch();

print_r($total_post);

Tapi pas saya ganti $search ke :search karena pengen pake PDOStatement::bindParam(), pas buka lagi url nya malah hasilnya gg kaya sebelumnya.

Array

(

 [COUNT(*)] => 0

)

Kodenya :

if ($search) {



 // If visitor is searching

 $sql = $DBH->prepare("SELECT COUNT(*) FROM blog_posts

 WHERE post_title LIKE '%:search%' OR post_content LIKE '%:search%'");

 $sql->bindParam(':search', $search);

 print_r($sql);

 // Useful for indexing

 $searh_param = "&s=".$search;



} else {

 // If visitor not searching then query all post

 $sql = $DBH->prepare("SELECT COUNT(*) FROM blog_posts"); 

}



$sql->execute();



$sql->setFetchMode(PDO::FETCH_ASSOC);

$total_post = $sql->fetch();

print_r($total_post);

Apa yang salah ya gan ?

Tambahan :
$search = $_GET['s'];