From: jamslam at gmail dot com
Operating system: RedHat 9
PHP version: 5.0.1
PHP Bug Type: SQLite related
Bug description: passing chained queries through methods doesn't work
Description:
------------
Alright, this is a strange bug, but I'll get to the point.
For some odd reason PHP is not letting me pass chained queries in through
a method, and from there execute the query successfully. I find that if I
use the transactions ('BEGIN;' and 'COMMIT;') no queries will be executed,
and if I leave the transactions out, only the first query will be
executed.
Now I know this bug exists:
http://bugs.php.net/bug.php?id=28264
And it's virtually identical, except for the fact that I'm passing data
through a method first, then executing it (I don't modify the data, as
you'll see below).
I have come to the conclusion that this is in fact a bug, as I have ruled
out every other possibility.
PHP Info: http://www.webtrickscentral.com/stuff/phpinfo.php
Reproduce code:
---------------
http://www.webtrickscentral.com/stuff/phpBug.phps
Expected result:
----------------
The code should insert two rows of data into table 'cool'.
Actual result:
--------------
It does not do anything- no error messages and it does not insert
anything.
* - This is for any type of query, also.
--
Edit bug report at http://bugs.php.net/?id=29806&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29806&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=29806&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=29806&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=29806&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=29806&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=29806&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=29806&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=29806&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=29806&r=support
Expected behavior: http://bugs.php.net/fix.php?id=29806&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=29806&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=29806&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=29806&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29806&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=29806&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=29806&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=29806&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=29806&r=float