how to connect MySQL from PHP

[jane]

Do I have to put MySQL server in a particular directory to make connection from PHP application? What should I write the first argument of mysql_connect() function?

Thanks

[mrmufin]

The syntax for connecting to MySQL is:

$conn = mysql_connect("hostname","username","password");

The returned value ($conn) is an integer value corresponding to the link identifier returned from the database server. It's always best to check that a connection could actually be established before continuing:

$conn = mysql_connect("localhost","root","");
if(!$conn) {
	exit("Unable to connect to the database.");
}
$db = mysql_select_db("test",$conn);
if(!$db) {
	exit("Unable to select the test database");
}

MySQL does not need to be in a particular directory, but the PHP interpreter needs to know where it is....

Have fun...

[jerdo]

You could try looking here for a quick and easy MySQL/PHP tutorial http://hotwired.lycos.com/webmonkey/99/21/index3a.html

[jane]

When I run the php file it gave me error "Can't connect to MySQL server on '3306' (10065). The localhost in mysql_connect is 3306 but it couldn't make the connect. why?

Thanks