PHP连接数据库

PHP连接MYSQL数据库

$username=your_name;
$userpass=your_pass;
$dbhost=localhost;
$dbdatabase=your_database;

//生成一个连接
$db_connect=mysql_connect($dbhost,$username,$userpass) or die("Unable to connect to the MySQL!");

//选择一个需要操作的数据库
mysql_select_db($dbdatabase,$db_connect);

//执行MySQL语句
$result=mysql_query("SELECT id,name FROM user");

//提取数据
$row=mysql_fetch_row($result);

 

PHP连接MS SQL数据库

< ?php   
$myServer = localhost; //主机  
$myUser = sa; //用户名  
$myPass = password; //密码  
$myDB = Northwind; //MSSQL库名  
$s = @mssql_connect($myServer, $myUser, $myPass)   or die(Couldnt connect to SQL Server on $myServer);   
$d = @mssql_select_db($myDB, $s)   or die(Couldnt open database $myDB);   
$query = SELECT TitleOfCourtesy
+ +FirstName+ +LastName AS Employee ;   
$query .= FROM Employees ;   
$query .= WHERE Country=USA AND Left(HomePhone, 5) = (206);   
$result = mssql_query($query);   
$numRows = mssql_num_rows($result);   
echo < h1> . $numRows . Row .($numRows == 1 ? : s) . Returned </ h1>;   
while($row = mssql_fetch_array($result))   
{   
    echo < li> . $row[Employee] . < /li>;   
}   
?>  

 

PHP连接ACCESS数据库

< ?  
$conn = new com("ADODB.Connection");   
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; 
DBQ=". realpath("data/db.mdb");   
$conn->Open($connstr);   
$rs = new com("ADODB.RecordSet");   
$rs->Open("select * from szd_t",$conn,1,1);   
while(! $rs->eof) {   
    $f = $rs->Fields(1);   
    echo $f->value;   
    $rs->MoveNext();   
}   
?>