How to Connect to MySql Server

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);

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : How to Connect to MySql Server
connect to MYSQL from ASP -
HELP CONNECT SQL SERVER 2005 WITH PHP 5.2.6 -
how to connect client on one machine with server -
clients cannot connect to server on another machine -
MySQL server information getting in php -
MYSQL best performance optimized parameters for 4G server -
How to connect two computers and connect them with Internet? -
Sql server or windows server question? -
Connect Dots -
connect SSIS package with ASP.net -

Topic Tags

PHP Database

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com