473,796 Members | 2,911 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Anyone running ISAPI and mysql succesfully?

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
4 1895
On 7 Jul 2006 20:01:21 -0700, "ImOk" <jo**********@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 :: an**@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Jul 11 '06 #2
On 7 Jul 2006 20:01:21 -0700, in comp.lang.php "ImOk"
<jo**********@g mail.com>
<11************ **********@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?
---------------------------------------------------------------
jn******@yourpa ntsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Jul 12 '06 #3
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**********@g mail.com>
<11************ **********@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?
---------------------------------------------------------------
jn******@yourpa ntsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Jul 12 '06 #4
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********** ************@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?
---------------------------------------------------------------
jn******@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.
js*******@attgl obal.net
=============== ===
Jul 12 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3949
by: Frank Conte | last post by:
I'm having a problem running a simple printer friendly script written in PHP. I'm not sure whether the problem is with apache 1.3 or with the scripts. I updated apache's config file httpd.conf to include the directives for running PHP as a loaded module and as CGI as noted in the documentation at php.net # Add to the end of the LoadModule section LoadModule php4_module "c:/php/sapi/php4apache.dll" # Add to the end of the AddModule...
3
11768
by: dave | last post by:
Hello there, I am at my wit's end ! I have used the following script succesfully to upload an image to my web space. But what I really want to be able to do is to update an existing record in a table in MySQL with the path & filename to the image. I have successfully uploaded and performed an update query on the database, but the problem I have is I cannot retain the primary key field in a variable which is then used in a SQL update...
6
1602
by: mark | r | last post by:
I believe that ISAPI can convert a search engine friendly url string into a querystring? does anyone have any tutorials about using this feature in ASP? mark
22
3362
by: Duncan Jones | last post by:
Hello, I just installed MySQL 4.0.18 on my Win2K computer. Once it installed, I ran the WinMySQLAdmin program and everything worked fine. The little green light was on, and I could connect to my databases. However, as soon as I restarted my computer, the green light changed to a red light, and since then I've been unable to connect to my databases. When I open WinMySQLAdmin, the "Server" group box on the Environment page is...
0
1528
by: Massimiliano Marcon | last post by:
I'm triyng to install mysql server with rpm on a linux red hat 9.0 machine. The installation was succesfully, but now I can't start the server. I think the right command is mysqld_safe --user=mysql but during the starting procedure the server shutdown, it reports: # mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 040525 09:32:25 mysqld ended If I try to rebuilt the grant tables using the...
0
1359
by: alchimista | last post by:
hi, I've succesfully installed mysql on linux 2.4.x (TRUSTIX), I've tried to move it on my chroot jail but after 10s it crashes with the following message: --- cut here---- 040602 18:22:21 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.0.20' socket: '/var/run/mysql/mysql.sock' port: 3306 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary
175
11519
by: Sai Hertz And Control Systems | last post by:
Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. What I think is PostgreSQL would have less USP's (Uniqe Selling Points
0
5986
by: Erwin Moller | last post by:
Hi, I am one of those questionable people that started with Vista (Home Premium). Not because I think it is a ready/steady OS, but partly out of curiousity, and partly because I needed to work on an old project that happens to run on IIS6/W2000/MSSQL7, but my W2000 machine couldn't handle the size of the database in question anymore. :-( My new Vista machine is 5 years younger and is a lot faster, so I started to figure out how to use...
7
1772
by: David | last post by:
Hi, I am attempting to do URL ReWriting with .NET to my classic ASP app. (Too big to upgrade to .NET at the moment). However, those who have tried will know that classic asp when rewritten doesn't work. Speaking to a friend of mine, he says (and I am sure I have seen it before as well) that I can run the classic ASP under the aspnet isapi. However, I can't find how to do that.
0
9535
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10467
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10244
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10021
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9061
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7558
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5454
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4130
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2931
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.