Can’t get MySQL to work with PHP in IIS on W2K or XP pro.

[Yacaph]

I’m new to MySQL and would really appreciated some help. I’m stumped!

The info here is from the XP machine but it’s similar on the W2k box. MySQL works fine standalone as as does IIS & PHP although if I move php.ini to the Windows (or WINNT) folder I only get a blank screen when executing a .php file and this includes excuting phpinfo(). I have restarted IIS after each change. On the W2K box I copied the .dll’s from C:\PHP\ext to WINNT\System32, but not on the XP box.

Installs = IIS 5.1 – MySQL 5.0 – PHP 5.25 on both computers.

C:\PHP\ php5isapi.dll is set as the IIS php script engine on both machines.

Php.ini is in C:\PHP\ (although phpinfo() shows it in C:\WINDOWS\ and in C:\WINNT\ on the W2K box).

Path on XP= C:\PHP\;C:\PHP\ext\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Symantec\pcAnywhere\;;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;

Path on W2K= C:\Program Files\PHP\;D:\WINNT\system32;C:\WINNT;C:\WINNT\system32\WBEM;C:\Program Files\MySQL\MySQL Server 5.0\bin

The following are some of the uncommented items from my php.ini on the XP box.

doc_root =
user_dir =
extension_dir ="C:\PHP\ext"
enable_dl = On
cgi.force_redirect = 1
fastcgi.impersonate = 1;
file_uploads = On

[MySQL]
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off

[MySQLi]
mysqli.max_links = -1
mysqli.default_port = 3306
mysqli.default_socket =
mysqli.default_host =
mysqli.default_user =
mysqli.default_pw =
mysqli.reconnect = Off
[mSQL]
msql.allow_persistent = On
msql.max_persistent = -1
msql.max_links = -1

 [PHP_MYSQL]
extension=php_mysql.dll
[PHP_PHPDOC]
extension=php_phpdoc.dll
[PHP_POP3]
extension=php_pop3.dll
[PHP_SPL_TYPES]
extension=php_spl_types.dll

 

[vacunita]

If you aren't getting anythng even from just the phpinfo() call on a page, the this sounds like a PHP configuration problem not a MYSQL issue.

Anyway, how are you executing the PHP pages?

Second are the uncommented dll files available to PHP? I believe they should be in the extensions folder.

Perhaps posting in the forum434 may get you more help.



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.