Re: [PHP-DB] Mysql PDO statement with params in HAVING problem

[Tamara Temple]

Alexander Pletnev pletnev.rusa...@gmail.com 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 ?

Yes. You put the execute before you bound the
parameters. prepare-bind-execute.

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

[PHP-DB] Mysql PDO statement with params in HAVING problem

[Alexander Pletnev]

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.

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

Re: [PHP-DB] Mysql PDO statement with params in HAVING problem

[Vinay Kannan]

$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as
full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%');

How about '%:$query%' instead of '%:query%' ? Does that solve the problem?

Thanks,



On Thu, Jun 27, 2013 at 5:21 PM, Alexander Pletnev 
pletnev.rusa...@gmail.com 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.

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