å è½½æ¹æ³å¾ç®åï¼å¨ææçåºæ件åé¢æ·»å ä¸å¦ä¸ä¸¤å¥ï¼
ãã;æå¨æ·»å çphpçpdoç驱å¨æ©å±æ¯æ
ããextension=php_pdo.dll
ããextension=php_pdo_sqlite.dll
ããä¸é¢è¿æä¸ä¸ªå¾éè¦çå·¥ä½ï¼å°±æ¯æ们è¦ææ©å±åºçè·¯å¾åè¯phpå¦åï¼PHPä¸ç¥éå»åªéæ¾è¿äºå°å®è´äº^_^ ,æ们æ¥æ¾å°å¦ä¸çè¡ï¼ï¼æ¥æ¾å
³é®åï¼extension_dirï¼ï¼
ãã; Directory in which the loadable extensions (modules) reside.
ããextension_dir = "c:\php\ext"
ããæå®è®¾ç½®ä¸ºå¨æåºåæ¹çè·¯å¾ï¼æ们è¿éæ¯ï¼c:\php\ext
ãã好äºPHPçé
ç½®æ件æ们修æ¹å¥½äºï¼ä¿åå
³éã
ããæ们ä¸é¢å¼å§å³å»ç¶ææ éé¢é£ä¸ªå°ç¾½æ¯çå¾æ ï¼éæ©âOpen Apache Monitorâæå¼Apacheçè§çªå£ï¼æ们éæ©å³è¾¹ä¸åæé®éé¢çâStopâæé®ï¼å°æå¡ææ¶å
³æãç¶åæ们æå¼âå¼å§-ãç¨åº-ãApache HTTP Server 2.0.54-ãConfigure Apache Server-ãEdit the Apache httpd.conf Configuration Fileâèåï¼æå¼Apacheçé
ç½®æ件httpd.confãå¨è¿éé¢æ们è¦æphpå½ä½Apacheçä¸ä¸ªæ¨¡åå è½½è¿æ¥ãæ们å¨é
ç½®æ件çæåé¢å ä¸å¦ä¸ä¸¤å¥ã请注æè·¯å¾é®é¢å¦ï¼
ããLoadModule php5_module "c:/php/php5apache2.dll"
ããAddType application/x-httpd-php .php
ããè¿æ ·å½Apacheå¯å¨çæ¶åå°±æPHPå è½½è¿æ¥äºãå寻æ¾ä¸é¢çè¡
ããï¼æ¥æ¾å
³é®åï¼DocumentRootï¼ï¼
ãã#
ããDocumentRoot "D:\website"
ãã设置æ们ç«ç¹çæ ¹ç®å½ãæéå¨D:\websiteä¸é¢ã
ããæ们è¿è¦å¯»æ¾å¦ä¸çè¡ï¼ï¼æ¥æ¾å
³é®åï¼DirectoryIndexï¼
ãã#
ããDirectoryIndex index.html index.html.var
ããè¿éæ们å¯ä»¥è®¾ç½®èªå·±çé¦é¡µå称,å¨åé¢å ä¸æ们使ç¨çæ件åå³å¯.ä¸é´ä½¿ç¨ç©ºæ ¼åéã
ããä¾å¦ï¼
ãã#
ããDirectoryIndex index.html index.html.var index.php default.php
ããè³æ¤ï¼æ们ææçé
ç½®å®æäºï¼è¯·å¤§å®¶ä¿åå
³éãç¶åå次å¯å¨Apacheçè§çªå£ï¼éæ©å³è¾¹çâStartâæé®ï¼å¯å¨Apacheæå¡å¨ï¼
ããæåæ~~
ããå¦æè¦æµè¯SQLiteæ°æ®åºçè¯ï¼æ们使ç¨ä¸äºSQLite建表工å
·ï¼å»ºä¸ä¸ªæ°æ®åºè·ä¸äºè¡¨ï¼ç¶åè¾å
¥ä¸äºæ°æ®å段ï¼æå使ç¨èªå·±å欢çç¼è¾å¨ï¼å¨éé¢è¾å
¥å¦ä¸ä»£ç ï¼
ããphp
ãã// Connect to an ODBC database using driver invocation
ãã$dsn = 'sqlite:c:\sql.db';
ããtry {
ãã$dbh = new PDO($dsn, $user, $password);
ããecho 'PDO Connection Ok','
ãã';
ãã$dbh->exec("CREATE TABLE PKU(id integer,name varchar(255))");
ããecho 'Create Table ok','
ãã';
ãã$dbh->exec("INSERT INTO PKU values(1,'jarjin')");
ããecho 'Insert Data ok','
ãã';
ãã$dbh->beginTransaction();
ãã$sth = $dbh->prepare('SELECT *FROM PKU');
ãã$sth->execute();
ãã$result = $sth->fetchAll();
ããprint_r($result);
ãã$dsn=null;
ãã} catch (PDOException $e) {
ããecho 'Connection failed: ' . $e->getMessage();
ãã$dsn=null;
ãã}
ãã?>
ãã(注æï¼PHP5èªèº«å¸¦çSQLiteæ¯2çæ¬ï¼ä¸è½æ§è¡3çæ¬çè¿æ¥è·æä½ï¼PODå°±æ¯è§£å³è¿ä¸ªé®é¢çæ¡¥æ¢ï¼å®ä½¿PHP5è¿æ¥å¹¶ä¸æä½3çæ¬çSQLiteï¼å æ¤ï¼PHP5èªèº«å¸¦çSQLite å½æ°åºæ¯æ æ³æä½SQLIte3çï¼å¿
须使ç¨PHP5æåéé¢PDOçå½æ°æ¥é´æ¥é©±å¨SQLite3æ°æ®åº)
ããä¿åå°æ们ç«ç¹çæ ¹ç®å½ä¸é¢ï¼æ¯å¦å«åï¼default.php å¦æä¸åºå
¶ä»é®é¢çè¯ï¼æ们å¯å¨IEï¼å¨å°åæ éè¾å
¥
http://localhost/ å车åï¼ççåºç°äºä»ä¹ã^_^