PHP 5.0 & mySQL 5.0

[kulrom]

Hi,
I am not sure that i have posted in the most appropriate forum but i hope i will find the answer to my question anyway.
namely, i did install PHP 5 with settings to run under IIS (not apache) and also i installed mySQL 5.0 checking "Install as Windows Service" option. Now, i am able to access mySQL through the "mySQL Command Line Client" but i am not able to access any DB through the PHP code.
I am using very simple statement like:

$connect = mysql_connect("localhost","root","");

but i am getting an error mesage that function mySQL_connect doesn's exists (or wasn't find or something).
What could be possible explanation for my problem? is that related to the issue that PHP run under IIS somehow or i need to configure mySQL a bit different?
hah, nearly i forgot to say that i tried new PHP statement mysqli_connect function too.

Thanks in advance 😉

[devinemke]

you need to enable the mySQL extension in your php.ini file. read up on it here

[bradgrafelman]

kulrom wrote:

hah, nearly i forgot to say that i tried new PHP statement mysqli_connect function too.

And I nearly suggested looking at the [man]MySQLi[/man] class/extension! 😉

So why didn't your attempt at using [man]mysqli_connect[/man] succeed? Did you get an error message?

[kulrom]

Guys first off, thanks for the express replies. It is very appreciated 🙂

devinemke wrote:

you need to enable the mySQL extension in your php.ini file. read up on it here

It is already enabled and i can succefully execute all other php code that is not related to this issue (connection) means, i only have a problem when i try to fetch some data from the mySQL althrough i am able to see, add, delete and manipulate in all ways the data stored into DBs through the "mySQL Command Line Client".

bradgrafelman wrote:

So why didn't your attempt at using mysqli_connect succeed? Did you get an error message?

I am getting the same error message: function not found

Thanks for any furhter help 🙂

[bradgrafelman]

kulrom wrote:

althrough i am able to see, add, delete and manipulate in all ways the data stored into DBs through the "mySQL Command Line Client".

Enabling the MySQL function as devinemike said has nothing to do with the command line. Do a phpinfo() and see if there's a "mysql" section.

[kulrom]

bradgrafelman wrote:

Enabling the MySQL function as devinemike said has nothing to do with the command line. Do a phpinfo() and see if there's a "mysql" section.

Of course friend i've done that but it seems that this .dll file is missing somehow.
I can only guess that i didnt download the adequate distribution for my OS (Windows Server 2003 R2).
Actually, i have succesfully installed PHP and mySQL on another computer with Windows XP SP2 pro. Now it seems that i cannot adjust settings for this machine. Is it because of the OS version or something else i am not sure but anyway it doesn't work. I cannot even start any php document under IIS (when i type http://localhost/test.php inside address field of IE it throws me an error that "the page cannot be found" - 404).
I properly added extension through the IIS Service and i uncommented the line for mySQL as well but still nothing is happening. Can you suggest me something else please?
TYA
Regards 😉

[MarkR]

If IIS is giving you 404s for PHP scripts, that is a separate issue and needs to be fixed. PHP does not run very well through IIS (It can do so though) and there are a number of issues which can't be easily resolved.

My best guess is that you have not enabled this extension in the IIS6 "allowed applications" panel (which is new to IIS6 and does not exist in any other version of IIS, including the crippled one which comes with XP pro).

This was essentially Microsoft finally seeing sense and realising that it's better to have functionality disabled by default and insist that the admin manually enables it.

The second problem is that the relevant PHP extension isn't loaded - but this is another issue, and until you can execute <?php phpinfo(); ?>, you don't need to worry about this.

Mark

[kulrom]

Well to be honest maybe i changed my original question but it is because i bought a new machine with a server R2 in meantime and now my problems culminated as i cannot even set up the PHP (i am not even close to mySQL problem as it was a case with the original thread from the above). So, can you point me to some articles that describes installing PHP on Windows Server 2003 R2 computer ... at least could you explain how to set the mentioned "allowed applications"?

Thanks for your time and patient if left some 🙂

[kulrom]

BUMP
C'mon guys i know you can do that ... help me 🙂

[bradgrafelman]

Any chance you can switch from IIS to Apache?

If you still want to use IIS, I've set PHP up on it before, so when I get home later tonight, perhaps I can try help you do that.

In the meantime, have you tried looking at the PHP.net manual? It's got a great guide - here's the man page: [man]install.windows.iis[/man]

EDIT: I highly suggest you install PHP via the ISAPI filter. Instructions are on the manual page linked above - just scroll down a little bit until you see the section that talks about installing PHP via ISAPI filters, NOT the CGI module.