Re: mysqli problem with stmt and binding parameters.
- From: Andy Hassall <andy@xxxxxxxxxxx>
- Date: Mon, 30 Jul 2007 18:32:12 +0100
On Mon, 30 Jul 2007 09:13:15 -0700, sugapablo <sugapablo@xxxxxxxxxxx> wrote:
I have a website that I was moving from another server to mine for
somebody. This website uses mysqli functions.
mysqli extensions are installed on my Linux server, PHP is 5.1.6 and
and MySQL is 4.1.22 (both higher than his server).
How much higher is the MySQL - presumably just the minor version?
All seems to work fine, but any statement that uses the bind (i.e.
placing a ? in the sql statement, and then binding variables to it)
does not work in my server, only his.
In what way does it not work? Errors? Blank pages? Flame pouring out the back
of the computer?
Usual drill: put error_reporting to maximum, make sure you're not suppressing
errors with "@".
Two questions, comparing phpinfo() on both servers, I can't find any
differences that would cause this problem. Does anyone have any ideas
on where to look?
And two, does anyone know how I can echo the prepared sql statement so
I can see what the final product looks like that gets sent to MySQL?
If you're using mysqli, and you're expecting to see an SQL statement with the
values embedded and escaped into it, actually the statement with placeholders
/is/ the final product sent to MySQL - MySQL 4.x+ supports placeholders
natively.
If you were just after the SQL, then find the place where prepare() gets
called, and add some debugging there.
--
Andy Hassall :: andy@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
.
- References:
- mysqli problem with stmt and binding parameters.
- From: sugapablo
- mysqli problem with stmt and binding parameters.
- Prev by Date: Re: Changes for PHP5 ?
- Next by Date: Re: mysql command line client
- Previous by thread: Re: mysqli problem with stmt and binding parameters.
- Next by thread: How can I access a file remotely?
- Index(es):
Relevant Pages
|
