Anyone running ISAPI and mysql succesfully?

[ImOk]

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

[Andy Hassall]

Re: Anyone running ISAPI and mysql succesfully?

On 7 Jul 2006 20:01:21 -0700, "ImOk" <jon.macaroni@g mail.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 :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Jeff North]

Re: Anyone running ISAPI and mysql succesfully?

On 7 Jul 2006 20:01:21 -0700, in comp.lang.php "ImOk"
<jon.macaroni@g mail.com>
<1152327681.715 433.140890@h48g 2000cwc.googleg roups.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_m ysql.dll in the php.ini file?
---------------------------------------------------------------
jnorthau@yourpa ntsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

[ImOk]

Re: Anyone running ISAPI and mysql succesfully?

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"
<jon.macaroni@g mail.com>
<1152327681.715 433.140890@h48g 2000cwc.googleg roups.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_m ysql.dll in the php.ini file?
---------------------------------------------------------------
jnorthau@yourpa ntsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

[Jerry Stuckle]

Re: Anyone running ISAPI and mysql succesfully?

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"
>><jon.macaroni @gmail.com>
>><1152327681.7 15433.140890@h4 8g2000cwc.googl egroups.comwrot e:
>>
>>

>>>| 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_m ysql.dll in the php.ini file?
>>---------------------------------------------------------------
>>jnorthau@your pantsyahoo.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.
jstucklex@attgl obal.net
=============== ===