Total members 11889 |It is currently Sun Apr 14, 2024 8:38 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





How to connect to MYSQL database from PHP?
This is a code to connect to the database using PHP.one the local host.
    localhost= Server of Mysql database :!:
    username= root
    password=""
    Database name=book


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:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 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     -  
 clients cannot connect to server on another machine     -  
 how to connect client on one machine with server     -  
 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     -  
 how to connect applet with excel     -  



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