My PHP file is unable to connect MYSQL

[Rahulnewdelhi]

hello all

Hello all

I installed php, mysql and IIS in xp. Problem is this while i run following file

PHP Code:
----------------

<?php
phpinfo();
?>

it doesnt show mysql info table in result. I seen mysql server it is running well. While i am trying to connect

my php file to mysql database then it doesnt connect. why it is happening? how to short out this problem,

please help me

regards

[james01]

i will want you to send me your mail adress anmd i will send ou the mailer on
here is my mail adress(jamescot [e-mail] )...



Hello all

I installed php, mysql and IIS in xp. Problem is this while i run following file

PHP Code:
----------------

<?php
phpinfo();
?>

it doesnt show mysql info table in result. I seen mysql server it is running well. While i am trying to connect

my php file to mysql database then it doesnt connect. why it is happening? how to short out this problem,

please help me

regards[/quote]

[teesha]

i think you need to verify dynamic extensions in "php.ini " (your configuration file)
extension=php_m ysql.dll
extension=php_m ysqli.dll
don't forget to restart your server

[pbmods]

Did you install PHP after you installed MySQL? DId you install PHP with MySQL support? It's been awhile since I've worked on a PC, but when you're using the PHP installer, it should give you the option to install optional components. Verify that MySQL is selected in that list.

[Rahulnewdelhi]

Hello all

I installed php, mysql and IIS in xp. Problem is this while i run following file

PHP Code:
----------------

<?php
phpinfo();
?>

it doesnt show mysql info table in result. I seen mysql server it is running well. While i am trying to connect my php file to mysql database then it doesnt connect. why it is happening? how to short out this problem,

please help me

[ak1dnar]

[PHP]<?php
if (function_exist s('mysql_connec t')) {
echo "function available.<br />\n";
} else {
echo "function not available.<br />\n";
}
?> [/PHP]

what is the output that you can get in your end for this script.

[Motoma]

You may still need to configure PHP to work with MySQL. PHP.net is a great resource for such information.

[Rahulnewdelhi]

This function is not working and showing result "function not available".

[PHP]<?php
if (function_exist s('mysql_connec t')) {
echo "function available.<br />\n";
} else {
echo "function not available.<br />\n";
}
?> [/PHP]

what is the output that you can get in your end for this script.

[ak1dnar]

This probably the configuration on your PHP.ini read this article.
Installation on Windows Systems

[ufitzi]

This post may have something to do with your problem.
http://www.thescripts.com/forum/thread429124.html

I'm currently in the same boat as you, both PHP and MYSQL are running, but PHP doesn't seem to be finding the php.ini file, which in turn results in the /ext/ directory (where the php_mysql.dll is located) not being read correctly.

If you run the phpinfo() function, you will see a summary of all php environment.
My guess is you will find the values you've entered in your php.ini file are NOT the ones being used. The post above seems to indicate a solution, however he was not very specific in the steps taken to resolve this issue. I would like to contact him to determine those steps, but he posted as a guest user. Hopefully someone else has info on the permissions solution he described.Good luck, I will post back here once I've figured this out.
bh