php mysql search function error

Question

I'm using this search function inside the search controller to send search results to the web page. For some reason it doesn't work. I'm using PDO and i can't see any errors in the php log either. I'we spent a lot of time trying to figure out what's wrong and still seems as if its a lost cause

public function search($search_string){

if (strlen($search_string) >= 1 && $search_string !== ' ') {
    // Build Query
    $sql = 'SELECT * FROM products WHERE name LIKE "%:search%" OR description LIKE "%:search%"';
    $query = $this->db->prepare($sql);
    $query->execute(array(':search' => $search_string));
    $this->search=$query->fetchAll();
    // Do Search


    // Check If We Have Results
    if (isset($query)) {

foreach($this->search as $key => $value) {
            // Format Output Strings And Hightlight Matches
            $display_function = preg_replace("/".$search_string."/i", "<b class='highlight'>".$search_string."</b>", $value->name);
            $display_name = preg_replace("/".$search_string."/i", "<b class='highlight'>".$search_string."</b>", $value->name);
            $display_url = 'http://hello.com/what'.urlencode($value->name).'&lang=en';

            // Insert Name
            $output = str_replace('nameString', $display_name, $html);

            // Insert Function
            $output = str_replace('functionString', $display_function, $output);

            // Insert URL
            $output = str_replace('urlString', $display_url, $output);

            // Output
            echo($output);
        }
    }else{

        // Format No Results Output
        $output = str_replace('urlString', 'javascript:void(0);', $html);
        $output = str_replace('nameString', '<b>No Results Found.</b>', $output);
        $output = str_replace('functionString', 'Sorry :(', $output);

        // Output
        echo($output);
    }
}





}

http://stackoverflow.com/questions/15990857/reference-frequently-asked-questions-about-pdo#15990965 — Your Common Sense, Mar 26 '14 at 06:27
and also http://stackoverflow.com/questions/15990857/reference-frequently-asked-questions-about-pdo#15990858 — Your Common Sense, Mar 26 '14 at 06:28
im pretty sure its not the pdo search part as iwe used LIKE before using this same method.. im guessing something wrong in the php — user3117384, Mar 26 '14 at 06:30
And, if it's not PDO part, then it makes whole question not a real one. "Find an error in my code, make a question out of it and answer as well" is not a valid question to ask — Your Common Sense, Mar 26 '14 at 06:32
sorry.. diyaza corrected my search query.. you were correct., it was the pdo part — user3117384, Mar 26 '14 at 06:34
It's was me actually who corrected your search query with a comment, as your question has been asked a zillion times already. You just had a fancy not to believe me — Your Common Sense, Mar 26 '14 at 06:35
id give you rep but turns out i dont have enough rep to rep you.. Honestly thanks alot — user3117384, Mar 26 '14 at 06:42
I am not after rep. I have more than enough already. Think of this this way: zillion repeated questions makes site bloated and hard to search for answers. — Your Common Sense, Mar 26 '14 at 06:45

score 0 · Answer 1 · answered Mar 26 '14 at 06:30

Change this part:

$sql = 'SELECT * FROM products WHERE name LIKE "%:search%" OR description LIKE "%:search%"';
$query = $this->db->prepare($sql);
$query->execute(array(':search' => $search_string));

to:

$sql = 'SELECT * FROM products WHERE name LIKE :search OR description LIKE :search';
$query = $this->db->prepare($sql);
$query->execute(array(':search' => "%".$search_string."%"));

Your way to use placeholder is not valid.

php mysql search function error

1 Answers1