Re: mysqli problem with stmt and binding parameters.

sugapablo 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).

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.


"Does not work" is pretty broad. What do you expect to happen? What actually happens? What error messages do you get?

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?


No, prepared statements are resources and can't be echo'd.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.

Relevant Pages

  • Export fast, my code slow =[
    ... ODBC driver or the server (MySQL, ... I think the above code is sending an "INSERT INTO" SQL statement to ... The reason I posted this to the MSAccess group instead of MySQL/MyODBC ...
    (comp.databases.ms-access)
  • Re: mysqli problem with stmt and binding parameters.
    ... This website uses mysqli functions. ... and MySQL is 4.1.22 (both higher than his server). ... How much higher is the MySQL - presumably just the minor version? ... does anyone know how I can echo the prepared sql statement so ...
    (comp.lang.php)
  • Re: PHP & Apache
    ... the change is adding an "i" to the mysql portion ... Restart your apache server. ... Note that the mysqli functions are slightly different than the ... I am not sure that you can, in fact, use the mysql extension, due to ...
    (alt.php)
  • mysqli problem with stmt and binding parameters.
    ... I have a website that I was moving from another server to mine for ... This website uses mysqli functions. ... does anyone know how I can echo the prepared sql statement so ...
    (comp.lang.php)
  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)