PHP PDO ѧϰ±Ê¼Ç
¡öPDOΪºÎÎ
POD£¨PHP Data Object£©À©Õ¹ÔÚPHP5ÖмÓÈ룬PHP6Öн«Ä¬ÈÏʶÓÃPDOÁ¬½ÓÊý¾Ý¿â£¬ËùÓзÇPDOÀ©Õ¹½«»áÔÚPHP6±»´ÓÀ©Õ¹ÖÐÒƳý¡£¸ÃÀ©Õ¹ÌṩPHPÄÚÖÃÀà PDOÀ´¶ÔÊý¾Ý¿â½øÐзÃÎÊ£¬²»Í¬Êý¾Ý¿âʹÓÃÏàͬµÄ·½·¨Ãû£¬½â¾öÊý¾Ý¿âÁ¬½Ó²»Í³Ò»µÄÎÊÌâ¡£
ÎÒÊÇÅäÖÃÔÚwindowsÏÂ×ö¿ª·¢Óõġ£
¡öPDOµÄÄ¿±ê
ÌṩһÖÖÇáÐÍ¡¢ÇåÎú¡¢·½±ãµÄ API ͳһ¸÷ÖÖ²»Í¬ RDBMS ¿âµÄ¹²ÓÐÌØÐÔ£¬µ«²»Åųý¸ü¸ß¼¶µÄÌØÐÔ¡£ ͨ¹ý PHP ½Å±¾Ìṩ¿ÉÑ¡µÄ½Ï´ó³Ì¶ÈµÄ³éÏó/¼æÈÝÐÔ¡£
¡öPDOµÄÌص㣺
ÐÔÄÜ¡£PDO ´ÓÒ»¿ªÊ¼¾ÍÎüÈ¡ÁËÏÖÓÐÊý¾Ý¿âÀ©Õ¹³É¹¦ºÍʧ°ÜµÄ¾Ñé½Ìѵ¡£ÒòΪ PDO µÄ´úÂëÊÇȫеģ¬ËùÒÔÎÒÃÇÓлú»áÖØпªÊ¼Éè¼ÆÐÔÄÜ£¬ÒÔÀûÓà PHP 5 µÄ×îÐÂÌØÐÔ¡£ ÄÜÁ¦¡£PDO Ö¼ÔÚ½«³£¼ûµÄÊý¾Ý¿â¹¦ÄÜ×÷Ϊ»ù´¡Ìṩ£¬Í¬Ê±Ìṩ¶ÔÓÚ RDBMS ¶ÀÌع¦Äܵķ½±ã·ÃÎÊ¡£ ¼òµ¥¡£PDO Ö¼ÔÚʹÄúÄܹ»ÇáËÉʹÓÃÊý¾Ý¿â¡£API ²»»áÇ¿ÐнéÈëÄúµÄ´úÂ룬ͬʱ»áÇå³þµØ±íÃ÷ÿ¸öº¯Êýµ÷ÓõĹý³Ì¡£ ÔËÐÐʱ¿ÉÀ©Õ¹¡£PDO À©Õ¹ÊÇÄ£¿é»¯µÄ£¬Ê¹ÄúÄܹ»ÔÚÔËÐÐʱΪÄúµÄÊý¾Ý¿âºó¶Ë¼ÓÔØÇý¶¯³ÌÐò£¬¶ø²»±ØÖØбàÒë»òÖØа²×°Õû¸ö PHP ³ÌÐò¡£ÀýÈ磬PDO_OCI À©Õ¹»áÌæ´ú PDO À©Õ¹ÊµÏÖ Oracle Êý¾Ý¿â API¡£»¹ÓÐһЩÓÃÓÚ MySQL¡¢PostgreSQL¡¢ODBC ºÍ Firebird µÄÇý¶¯³ÌÐò£¬¸ü¶àµÄÇý¶¯³ÌÐòÉÐÔÚ¿ª·¢¡£
¡ö°²×°PDO
ÎÒÕâÀïÊÇWINDOWSÏ¿ª·¢ÓõÄPDOÀ©Õ¹£¬ÒªÊÇÄãÒªÔÚLinuxÏ°²×°ÅäÖã¬Çëµ½±ðµÄµØ·½Ñ°ÕÒ¡£
°æ±¾ÒªÇó£º
php5.1ÒÔ¼°ÒÔºó°æ±¾µÄ³ÌÐò°üÀïÒѾ´øÁË£»
php5.0.xÔòÒªµ½pecl.php.netÏÂÔØ£¬·Åµ½ÄãµÄÀ©Õ¹¿â£¬¾ÍÊÇPHPËùÔÚµÄÎļþ¼ÐµÄextÎļþ¼ÐÏ£»
ÊÖ²áÉÏ˵5.0֮ǰµÄ°æ±¾²»ÄÜÔËÐÐPDOÀ©Õ¹¡£
ÅäÖãº
ÐÞ¸ÄÄãµÄphp.iniÅäÖÃÎļþ,ʹËüÖ§³Öpdo.£¨php.iniÕâ¸ö¶«Î÷ûÓÐŪ¶®µÄ»°£¬ÏÈŪÇå³þ£¬ÒªÐ޸ĵ÷ÓÃÄãµÄphpinfo()º¯ÊýËùÏÔʾµÄÄǸöphp.ini£©
°Ñ
extension=php_pdo.dllÇ°ÃæµÄ·ÖºÅÈ¥µô£¬·ÖºÁÊÇphpÅäÖÃÎļþ×¢ÊÍ·ûºÅ,Õâ¸öÀ©Õ¹ÊDZØÐëµÄ¡£
ÍùÏ»¹ÓÐ
;extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_informix.dll
;extension=php_pdo_mssql.dll
;extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
¸÷¸÷À©Õ¹Ëù¶ÔÓ¦µÄÊý¾Ý¿âÊÇ£º
Driver nameSupported databasesPDO_DBLIBFreeTDS / Microsoft SQL Server / SybasePDO_FIREBIRDFirebird/Interbase 6PDO_INFORMIXIBM Informix Dynamic Ser
Ïà¹ØÎĵµ£º
; ±¾ÎIJ¢·ÇÊǶÔÓ¢ÎÄ°æ php.ini µÄ¼òµ¥·Ò룬¶øÊDzο¼ÁËÖÚ¶à×ÊÁÏÒԺ󣬽áºÏ×Ô¼ºµÄÀí½â£¬Ôö¼ÓÁËÐí¶àÄÚÈÝ£¬
; °üÀ¨ÔÚÔÓÐ php.ini »ù´¡ÉÏÔö¼ÓÁËһЩʵÓÃÄ£¿éµÄÅäÖÃ˵Ã÷£¬Í¬Ê±¶ÔÎļþÄÚÈݵİ²ÅŽøÐÐÁ˵÷Õû¡£
; ÓÉÓÚ×÷Õß²»Ï²»¶ no-free µÄÍæÒâ¶ù£¬ËùÒÔɾ³ýÁ˳ý MySQL ºÍ PostgreSQL ÒÔÍâµÄÆäËûÊý¾Ý¿âÄ£¿éÅäÖÃÑ¡Ïî¡£
;;;;;;;;;; ......
php.ini µÄËÑË÷·¾¶ÈçÏ£¨°´Ë³Ðò£©£º
* SAPI Ä£¿éËùÖ¸¶¨µÄλÖã¨Apache 2 ÖÐµÄ PHPIniDir Ö¸ÁCGI ºÍ CLI ÖÐµÄ -c ÃüÁîÐÐÑ¡ÏNSAPI ÖÐµÄ php_ini ²ÎÊý£¬THTTPD ÖÐµÄ PHP_INI_PATH »·¾³±äÁ¿£©
*HKEY_LOCAL_MACHINE\SOFTWARE\PHP\IniFilePath£¨Windows ×¢²á±íλÖã©
&nb ......
//½«ÍøÖ·µÄ²ÎÊýתΪ±äÁ¿,Èç:xxx.php?a=1&b=2,
//ÔËÐз½·¨ºó,echo $a."|".$b, ½á¹û:1|2
extract($_GET);
//unicodeתutf8£¬Èç:中»ò \u9865 ת ³É ÖÐÎÄ
function unescape($str) {
$str = rawurldecode($str);
preg_match_all("/(?:%u.{4})|&#x.{4};|&am ......
¡¡¡¡×î½üÔÚ×ö¸öÒ³Ãæʱ£¬Óöµ½ÒªPHP³ÌÐòÖÐʵÏÖÑÓ³Ùµ±Ç°½ø³ÌÎÊÌâ¡£ÓÉÓÚ½Ó´¥PHPʱ¼äÓÐÏÞ£¬Ï뵱ȻµÄÈÏΪPHPÖÐʵÏִ˹¦Äܵĺ¯ÊýÒ²ÊÇsleep()¡£ÊÂʵÉÏ£¬ÔÚPHPÖеÄÈ·ÓÐÕâ¸öº¯Êý£¬µ«ÔÚÎÒ³¢ÊÔÁË°ëÌìºó£¬È´Ê¼ÖÕ²»ÄÜʵÏÖÎÒÒªµÄÂß¼¡£PHP5ÊÖ²áÖУ¬¶ÔÕâ¸öº¯ÊýÊÇÕâÑùÃèÊöµÄ£ºsleep -- Delay execution¡£µ±ÎÒ°Ù¶ÈÁËÒԺ󣬲ÅÖªµÀÕ⸠......
Êý¾Ý¿âÉè¼Æ£º
--
-- Êý¾Ý¿â: `test`
--
-- --------------------------------------------------------
--
-- ±íµÄ½á¹¹ `menu`
--
CREATE TABLE IF NOT EXISTS `menu` (
`ID` int(10) unsigned NOT NULL auto_increment,
`PID` int(11) NOT NULL,
`TITLE` varchar(200) NOT NULL,
`REMARK` varchar(200) NOT ......