How to Connect to MySql Server

Sat Apr 07, 2007 12:55 pm

How to connect to MYSQL database from PHP?
This is a code to connect to the database using PHP.one the local host.

Code:: $connection =mysql_connect("localhost","root","",true,1); mysql_select_db("library",$connection); $result1 = mysql_query ("SELECT * FROM book", $connection); while ($row = mysql_fetch_row($result1)) { // (4) Print out each element in $row, that is, // print the values of the attributes for ($i=0; $i"; } // (5) Close the database connection mysql_close($connection);