Re: Mysql PDO statement with params in HAVING problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 6/27/2013 7:51 AM, Alexander Pletnev wrote:
Hi everyone, im new here, so please correct me if i created or formated
topic incorrectly.

I found a problem. I have a simple query for my needs:

     $stmt = $dbh->prepare("SELECT concat(first_name,' ',last_name) as
     full_name,t.* FROM `specialists` `t` HAVING full_name like '%john%'");
     $stmt->execute();
     while($row = $stmt->fetch())
     {
        echo '<pre>'; var_dump($row); echo '</pre>';
     }

It works fine, until i add a param to my query:

     $stmt = $dbh->prepare("SELECT concat(first_name,' ',last_name) as
     full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%'");
     $stmt->execute();
     $query = 'londo';
     $stmt->bindParam(':query',$query);
     while($row = $stmt->fetch())
     {
        echo '<pre>'; var_dump($row); echo '</pre>';
     }

Now there is nothing in fetch(). Is it a bug ?

Thanks.

First - you prepare the query
Second - you create and 'bind' the parameters to it
Third - you execute the now completed query
Fourth - you process the results.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux