Okay, I'm using PHP4.0.1pl2 on NT4/IIS4 with Service Pack 4, and running MySQL 3.22.33. Because I'm on NT, I'm using MyODBC to make my connections to MySQL. What I've found is that text containing single or double quotes in a <TEXTAREA> or <INPUT> will not INSERT into MySQL properly even after using PHP's addslashes() function.
When I go to make the insert, the PHP process hangs and kills PHP until I reboot the machine. Also, the MySQL service chokes and fails to respond also requiring the reboot. When I examine the database after rebooting directly in a console window, everything is intact and I can see the INSERT made it. However, trying to SELECT it through the above setup for display on the web causes the same problem. I'm assuming that PHP is hanging because the database service hangs.
The exact same code works under Windows 98 using the exact same combinations (only Omnicron instead of IIS) with NO problems. Similarly, I dumped the NT MySQL tables and loaded them on a Redhat 6.1 Linux box and had no problem with the same PHP codebase (just changed the db abstraction module to connect to different host). On NT, the problem appeared using PHP4.0 as well as when using PHP4.0.1pl1, and the results were the same using PHP4 in CGI mode or ISAPI.
In the interim, I'm running MySQL off the Linux box, but ultimately I need to get this back onto NT. Has anyone else experienced this problem? I'm guessing the bug is between MyODBC and MySQL on NT, but I can't be certain. Oh, and I also tested MyODBC both with and without the optimized DLL; both setups still choked. I'd appreciate any comments on similar experiences or suggestions on how to further isolate the problem.
As always, thank you! - st
