поисковик с PDO

# Guccifer (04.06.2015 / 21:40)
мне нужен поисковик с PDO

# ValekS (04.06.2015 / 22:49)
Чего именно ПДО? У тебя сайт на нём?

$search = $_GET['harf'].'%';
 $stmt = $pdo->prepare("SELECT * FROM dream WHERE title LIKE $search");
$stmt -> bindValue(1, $search, PDO:ARAM_STR);
$stmt -> execute(); 
 
while ($row = $stmt -> fetchAll(PDO::FETCH_ASSOC)) { 
echo '<div class="menu">'.$row['title'].'</div>';

}

$harf = $_GET['harf'];
 $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `dream` WHERE  `title` LIKE '".$harf."%'  ORDER BY `title` ASC"),0); 
            


 
 $req = mysql_query("SELECT * FROM `dream` WHERE `title` LIKE '".$harf."%'  ORDER BY `title` ASC LIMIT $start, $kmess"); 
$i = 0;
        while ($res = mysql_fetch_array($req)) {
   $i++;
    echo '<div class="menu"><a href="index.php?id='.$res['id'].'">'.$res['title'].'</a><br/><small>'.mb_substr(trim($res['text']), 0, 100).'...</small></div>';
   


}