That's prepared statements http://php.net/manual/en/pdo.prepare.php
used for better performance (compiled query plan can be cached)

On Thursday, May 3, 2012 5:37:22 PM UTC+2, johnericsutton wrote:
>
> At the end of 
> http://book.cakephp.org/2.0/en/models/retrieving-your-data.html are some 
> examples of the use
> of DboSource::fetchAll() :
>
>
> $db = $this->getDataSource();
>
> $db->fetchAll(
>     'SELECT * from users where username = ? AND password = ?',
>     array('jhon', '12345'));
> $db->fetchAll(
>     'SELECT * from users where username = :username AND password = :password',
>     array('username' => 'jhon','password' => '12345'));
>
>
> I can't imagine how the first use of fetchAll() is supposed to work, but 
> surely the second is supposed to read:
>
> $db->fetchAll(
>   String::insert(
>     'SELECT * from users where username = :username AND password = :password',
>     array('username' => 'jhon','password' => '12345')
>   )
> );
>
>
> Is there some magic whereby the call to String::insert() can be omitted 
> and yet the substitutions happen anyway?
>
>

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to