PHP 5.0 can't connect to MySQL dB

[ForYou]

---

Hi there guys!

To all PHP & MySQL Experts... please help!

Issue: My PHP can't connect to MySQL

OS: WinXP Prof SP2
Server: IIS
PHP: version 5.0 (uses CGI)
MySQL: version 5.0 (username: "root" & password: test)

PHP Side:
- I don't have any issues hard coding it or using it in DreamweaverMX
- I just can't connect to MySQL weather hard coding or configuring in DreamweaverMX!

MySQL Side:
- I can do anything in creating & administering databases on the command line
- This just don't want to cooperate with my PHP 5.0

Troubleshooting:
- Turn off all firewall/anti-virus/any software that's a possibility in blocking the connection

Error Code: "PHP Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\PHPTest\test.php on line 7"

My dB connection code:
<?php
$con = mysql_connect("localhost","root","secret");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}// some code
?>

Standbye sa lang guys... Tnx daan ninyo!
But for now, if you have something in mind please do feel free to post your suggestions in troubleshooting this. Thanks again!



Be back...,
ForYou

[ta3]

Be sure na butang nimo ang libmySQL.dll sa imong system directory and remove nimo ang ; sa extension=php_mysql.dll sa php.ini file then restart your web server.


btw here's a good link in installing php and mysql. http://vbforums.com/showthread.php?t=330825

[ventura]

bai!
unsaon man pag display database to vb example i want a month from may to june then mo display ang month sa may to june nga data from database.... other SQL i know kana ra .... unsaon man

mag gamit man gud ko inventory para sa amo company I.T staff ko i want to help lang nila....

pls..

[rue2007]

bai!
unsaon man pag display database to vb example i want a month from may to june then mo display ang month sa may to june nga data from database.... other SQL i know kana ra .... unsaon man

mag gamit man gud ko inventory para sa amo company I.T staff ko i want to help lang nila....

SQL:

select trxid, mdate, description from table where mdate between date1 and date2

pls..

[ForYou]

Guys!
Still having issues connecting mySQL to PHP gyud... Other info/resources guys beh? Please do help... Tnx!
By the way, unsa diay mysql.default_socket? Anyone guys?... Tnx again!...

[silent-kill]

mag xammp nalng diay ka bai?... check daw onsa port imo gi gamit.

[din428]

i have the same promblem .... up!

[maddox]

This is assuming nga ok na inyo MySQL ha... sigurado na gyud nga ga-dagan.

I check ang mga port gigamit.

Kung dili pa gali gyud, gamit na lang ug XAMMP or WAMP para wala na problema.

[maddox]

Ay teka... Kani nga error code:

Error Code: "PHP Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\PHPTest\test.php on line 7"

indicates that there could be something wrong with your PHP configuration.

Wala pa ta kabalo kung naa problema sa imo db connection coz wala pa man kaabot imo script didto. Look:

My dB connection code:
<?php
$con = mysql_connect("localhost","root","secret");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}// some code
?>

If the script proceeded, it could have given you the string 'Could not connect: ...' + the error you specified. But it got stuck with the mysql_connect function that is built-in php.

So fix this first.

[ondoy]

Better check your php if properly configured ba.
Create a php file, any filename blaha nka.
<?php
phpinfo();
?>
e save din open imo browser, this will tell if na configure ba imong php with Mysql.
Tanawa sa middle part man cguro kung naay configuration.

E make sure lng sa php.ini na unmark ang mysql nga dll din nka define ang path sa php.ini or maayo i butang nimo cya sa root folder saimung windows