php串連資料庫的四種方法

$conn = new Com("ADODB.Connection"); //執行個體化一個Connection對象 $connstr = "provider=sqloledb;datasource=.;uid=使用者名稱;pwd=密碼;database=資料庫;"; $conn->Open($connstr); $rs = new Com("ADODB.Recordset"); //執行個體化一個Recordcount對象 /*使用執行個體*/ $rs->Open('select * from News where bigclassid = 59 And LeadPostil is null', $conn, 1, 1); $count = $rs->RecordCount; // bbs.it-home.org echo "共有{$count}條紀錄 "; for($i = 0; $i < $count ; $i++){ $arr_result[$i]['Title'] = addslashes($rs->Fields('Title')->Value);//標題 $arr_result[$i]['Color'] = addslashes($rs->Fields('titlecolor')->Value?$rs->Fields('titlecolor')->Value:'');//標題顏色 $arr_result[$i]['WenHao'] = addslashes($rs->Fields('OtherText')->Value);//文號 } 複製代碼 方法2，odbc串連資料庫 $dbhost = ''; $dbuser = ''; //你的mssql使用者名稱 $dbpass = ''; //你的mssql密碼 $dbname = ''; //你的mssql庫名 $connect=odbc_connect("Driver={SQL Server};Server=$dbhost;Database=$dbname","$dbuser","$dbpass"); /*執行個體測試*/ $sql="select * from content"; $exec=odbc_exec($connect,$sql); while($row = (odbc_fetch_array($exec))) { $row['id'] //獲取欄位值 ... } 複製代碼 方法3，php內建函數串連：開啟裝有php5和apache的伺服器上的php.ini檔案 去掉;extension=php_mysql.dll前面的分號";"重啟apache伺服器。 $dbh=mysql_connect("主機名稱","使用者","密碼"); mssql_select_db("mydb", $dbh); ?> 複製代碼 方法4，串連Access資料方法 $db=$_SERVER['DOCUMENT_ROOT']."/PHP_ACCESS/include/#mydb.mdb"; //這裏最好用$_SERVER['DOCUMENT_ROOT']擷取路徑 $conn = new COM('ADODB.Connection') or die('can not start Active X Data Objects'); $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db"); $rs = $conn->Execute('SELECT * FROM contents order by id desc'); while(!$rs->EOF) { echo $rs->Fields['name']->Value; $rs->MoveNext(); } /*釋放資源*/ $rs->Close(); $conn->Close(); $rs = null; $conn = null; 複製代碼

