Posted by Andy Hassall on 07/30/07 17:32

On Mon, 30 Jul 2007 09:13:15 -0700, sugapablo <sugapablo@hotmail.com> 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@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]