NYCPHP Meetup

NYPHP.org

[nycphp-talk] mysqli exception problem

Michael Southwell michael.southwell at nyphp.com
Mon Nov 5 18:14:07 EST 2007


Flavio daCosta wrote:
> On 11/05/2007 05:16 PM, Michael Southwell wrote:
> /snip
>> The docs say the prepared statement must be a
>> single statement, and of course
>> this is not. But why don't I get an exception here?
> 
> Your /prepare/d statement is a single statement.

aha, so 'SELECT name FROM wines WHERE color = "red";DELETE FROM wines' 
is two statements in mysql (failing with msyql_query) but one in mysqli?!?!

   You have bound
> 'red;DELETE FROM wines' to your parameter, there is no error, the
> bind_param() returns TRUE.  There are no `names` where color =
> 'red;DELETE FROM wines'

-- 
=================
Michael Southwell
Vice President, Education
NYPHP TRAINING:  http://nyphp.com/Training/Indepth



More information about the talk mailing list