[PHP] AppServ 安裝 pear 及與 MySQL 連結設定

From: Polin Wei

環境:
OS: WindowXP Sp3
AppServ Package: appserv-win32-2.5.10.exe 包含的服務如下:
Apache 2.2.8
PHP 5.2.6
MySQL 5.0.51b
phpMyAdmin-2.10.3


Step 01:
從 appservnetwork: 下載appserv-win32-2.5.10.exe 並依預設目錄 C:\AppServ 安裝 Apache, PHP, MySQL, phpMyAdmin

Step 02:
修改 c:\windows\php.ini 檔. DLL (動態連結檔) 先載入 php_mbstring.dll, 再載入 php_exif.dll 順序如下:

; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

; pear 要用的
extension=php_mbstring.dll
extension=php_exif.dll

Step 03: 安裝 PEAR
a. 重新啟動 Apache , 然後執行 C:\AppServ\php5\go-pear.bat,往後皆按Enter便可。
b. 最後會出現一段訊息，提醒使用者雙擊 c:\AppServ\php5\PEAR_ENV.reg ，登錄PEAR相關的註冊碼。

Step 04: 安裝 PEAR DB, 並使用"Pear list" 檢查是否安裝完成
C:\AppServ\php5>pear install DB
C:\AppServ\php5>pear list



Step 05 : 在 DB: test , 建立 Table: users 來測試
--
-- 資料庫: `test`
--
--------------------------------------------------------
--
-- 資料表格式： `users`
--

CREATE TABLE `users` (
`id` varchar(10) NOT NULL,
`username` varchar(30) NOT NULL,
`password` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 列出以下資料庫的數據： `users`
--

INSERT INTO `users` (`id`, `username`, `password`) VALUES ('1', 'polin', 'wei');


Step 06: 建立 pearDB.php 來測試

<?php

require_once("DB.php");

$dbh = DB::connect('mysql://root:mysql@localhost/test');
$result = $dbh->query('SELECT * FROM users ORDER BY id');
if ( $result->numRows($result) > 0 ) {
 echo "<table>\n<tr><th>ID</th><th>userName</th><th>Password</th></tr>\n";
  while ( $data = $result->fetchRow() ) {
  echo "<tr><td>$data[0]</td><td>$data[1]</td><td>$data[2]</td></tr>\n";
  }
  echo "</table>\n";
} else {
  echo "Ok;\n";
}

?>

 

成果如下:
ID userName Password
1 polin wei