By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,871 Members | 2,464 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,871 IT Pros & Developers. It's quick & easy.

Anyone running ISAPI and mysql succesfully?

P: n/a
I have the following setup:

Windows XP Prof, IIS, PHP5

PHP5 works no problem with either PHP-CGI.EXE and mySQL,

PHP5 also works no problem with php5isapi.dll as long as I dont use
mySQL. When I use mysql It just gives an error or nothing when I try to
execute any mysql function (e.g. mysql_connect).

I have put the PHP.INI in C:\Windows but no luck. I have also setup the
PHPRC variable but no luck. I even put the IniFilePath in the registry
as per docs. Every time I reboot.

Can anyone tell me the exact steps to get ISAPI to work with mysql in
IIS?

Thanks

Jul 8 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 7 Jul 2006 20:01:21 -0700, "ImOk" <jo**********@gmail.comwrote:
>PHP5 also works no problem with php5isapi.dll as long as I dont use
mySQL. When I use mysql It just gives an error or nothing when I try to
execute any mysql function (e.g. mysql_connect).
What is the error?

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Jul 11 '06 #2

P: n/a
On 7 Jul 2006 20:01:21 -0700, in comp.lang.php "ImOk"
<jo**********@gmail.com>
<11**********************@h48g2000cwc.googlegroups .comwrote:
>| I have the following setup:
|
| Windows XP Prof, IIS, PHP5
|
| PHP5 works no problem with either PHP-CGI.EXE and mySQL,
|
| PHP5 also works no problem with php5isapi.dll as long as I dont use
| mySQL. When I use mysql It just gives an error or nothing when I try to
| execute any mysql function (e.g. mysql_connect).
|
| I have put the PHP.INI in C:\Windows but no luck. I have also setup the
| PHPRC variable but no luck. I even put the IniFilePath in the registry
| as per docs. Every time I reboot.
|
| Can anyone tell me the exact steps to get ISAPI to work with mysql in
| IIS?
Have you uncommented the extension=php_mysql.dll in the php.ini file?
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Jul 12 '06 #3

P: n/a
There is no error which makes it difficult to even tell what is going
on.
Here is the simplest version of code that fails:

<?php
print 'Start';
$xx = mysql_connect('localhost') or die (mysql_error());
print 'End' ;
?>

The above code works and prints StartEnd to the browser whe using
php-cgi.exe

When I setup the php5isapi.dll (.php and add ISAPI filter) it fails to
execute the print 'End'

It prints "Start" but never prints "End" to the browser.

I even tried removing or die() and I get the same problem.

And yes, I do have the extensions in my PHP.INI otherwise the
php-cgi.exe wouldnt work either.

Thanks
Jeff North wrote:
On 7 Jul 2006 20:01:21 -0700, in comp.lang.php "ImOk"
<jo**********@gmail.com>
<11**********************@h48g2000cwc.googlegroups .comwrote:
| I have the following setup:
|
| Windows XP Prof, IIS, PHP5
|
| PHP5 works no problem with either PHP-CGI.EXE and mySQL,
|
| PHP5 also works no problem with php5isapi.dll as long as I dont use
| mySQL. When I use mysql It just gives an error or nothing when I try to
| execute any mysql function (e.g. mysql_connect).
|
| I have put the PHP.INI in C:\Windows but no luck. I have also setup the
| PHPRC variable but no luck. I even put the IniFilePath in the registry
| as per docs. Every time I reboot.
|
| Can anyone tell me the exact steps to get ISAPI to work with mysql in
| IIS?

Have you uncommented the extension=php_mysql.dll in the php.ini file?
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Jul 12 '06 #4

P: n/a
ImOk wrote:
There is no error which makes it difficult to even tell what is going
on.
Here is the simplest version of code that fails:

<?php
print 'Start';
$xx = mysql_connect('localhost') or die (mysql_error());
print 'End' ;
?>

The above code works and prints StartEnd to the browser whe using
php-cgi.exe

When I setup the php5isapi.dll (.php and add ISAPI filter) it fails to
execute the print 'End'

It prints "Start" but never prints "End" to the browser.

I even tried removing or die() and I get the same problem.

And yes, I do have the extensions in my PHP.INI otherwise the
php-cgi.exe wouldnt work either.

Thanks
Jeff North wrote:
>>On 7 Jul 2006 20:01:21 -0700, in comp.lang.php "ImOk"
<jo**********@gmail.com>
<11**********************@h48g2000cwc.googlegrou ps.comwrote:

>>>| I have the following setup:
|
| Windows XP Prof, IIS, PHP5
|
| PHP5 works no problem with either PHP-CGI.EXE and mySQL,
|
| PHP5 also works no problem with php5isapi.dll as long as I dont use
| mySQL. When I use mysql It just gives an error or nothing when I try to
| execute any mysql function (e.g. mysql_connect).
|
| I have put the PHP.INI in C:\Windows but no luck. I have also setup the
| PHPRC variable but no luck. I even put the IniFilePath in the registry
| as per docs. Every time I reboot.
|
| Can anyone tell me the exact steps to get ISAPI to work with mysql in
| IIS?

Have you uncommented the extension=php_mysql.dll in the php.ini file?
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

Works fine for me - and I just set up a new server using isapi and MySQL
and it works just fine, also.

The fact it doesn't display the "End" message tells me it's terminating
for some reason. Check your Windows event log and IIS error log for
possible messages.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 12 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.