PHP PDO »ù´¡
PHP PDO »ù´¡
http://blog.csdn.net/nailwl/archive/2009/10/27/4733655.aspx
PDOÊÇÒ»¸ö“Êý¾Ý¿â·ÃÎʳéÏó²ã”£¬×÷ÓÃÊÇͳһ¸÷ÖÖÊý¾Ý¿âµÄ·ÃÎʽӿڣ¬ÓëmysqlºÍmysqliµÄº¯Êý¿âÏà±È£¬PDOÈÿçÊý¾Ý¿âµÄʹÓøü¾ßÓÐÇ׺ÍÁ¦£»ÓëADODBºÍMDB2Ïà±È£¬PDO¸ü¸ßЧ¡£Ä¿Ç°¶øÑÔ£¬ÊµÏÖ“Êý¾Ý¿â³éÏó²ã”ÈÎÖØ¶øµÀÔ¶£¬Ê¹ÓÃPDOÕâÑùµÄ“Êý¾Ý¿â·ÃÎʳéÏó²ã”ÊÇÒ»¸ö²»´íµÄÑ¡Ôñ¡£
PDO->beginTransaction() — ±êÃ÷»Ø¹öÆðʼµã
PDO->commit() — ±êÃ÷»Ø¹ö½áÊøµã£¬²¢Ö´ÐÐSQL
PDO->__construct() — ½¨Á¢Ò»¸öPDOÁ´½ÓÊý¾Ý¿âµÄʵÀý
PDO->errorCode() — »ñÈ¡´íÎóÂë
PDO->errorInfo() — »ñÈ¡´íÎóµÄÐÅÏ¢
PDO->exec() — ´¦ÀíÒ»ÌõSQLÓï¾ä£¬²¢·µ»ØËùÓ°ÏìµÄÌõÄ¿Êý
PDO->getAttribute() — »ñȡһ¸ö“Êý¾Ý¿âÁ¬½Ó¶ÔÏó”µÄÊôÐÔ
PDO->getAvailableDrivers() — »ñÈ¡ÓÐЧµÄPDOÇý¶¯Æ÷Ãû³Æ
PDO->lastInsertId() — »ñȡдÈëµÄ×îºóÒ»ÌõÊý¾ÝµÄÖ÷¼üÖµ
PDO->prepare() — Éú³ÉÒ»¸ö“²éѯ¶ÔÏó”
PDO->query() — ´¦ÀíÒ»ÌõSQLÓï¾ä£¬²¢·µ»ØÒ»¸ö“PDOStatement”
PDO->quote() — Ϊij¸öSQLÖеÄ×Ö·û´®Ìí¼ÓÒýºÅ
PDO->rollBack() — Ö´Ðлعö
PDO->setAttribute() — Ϊһ¸ö“Êý¾Ý¿âÁ¬½Ó¶ÔÏó”É趨ÊôÐÔ
PDOStatement->bindColumn() — Bind a column to a PHP variable
PDOStatement->bindParam() — Binds a parameter to the specified variable name
PDOStatement->bindValue() — Binds a value to a parameter
PDOStatement->closeCursor() — Closes the cursor, enabling the statement to be executed again.
PDOStatement->columnCount() — Returns the number of columns in the result set
PDOStatement->errorCode() — Fetch the SQLSTATE associated with the last operation on the statement handle
PDOStatement->errorInfo() — Fetch extended error information associated with the last operation on the statement handle
PDOStatement->execute() — Executes a prepared statement
PDOStatement->fetch() — Fetches the next row from a result set
PDOStatement->fetchAll(
Ïà¹ØÎĵµ£º
Zend_Search_Lucene ÊÇÒ»¸öÍêÈ«ÓÉ PHP 5 ±àдµÄͨÓÃÎı¾ËÑË÷ÒýÇæ¡£ÓÉÓÚÆä½«Ë÷Òý±£´æÔÚÎļþϵͳÖжø²»ÐèÒªÊý¾Ý¿âÖ§³Ö£¬Òò´ËËü¼¸ºõ¿ÉÒÔΪÈκÎÓÉ PHP Çý¶¯µÄÍøÕ¾Ôö¼ÓËÑË÷ÄÜÁ¦¡£Zend_Search_Lucene Ö§³ÖÏÂÁÐÌØÐÔ£º
¾ßÓÐÅÅÃû¹¦ÄܵÄËÑË÷——×î·ûºÏÒªÇóµÄ½á¹û³öÏÖÔÚ×îÇ°Ãæ
Ðí¶àÇ¿´óµÄ²éѯÀàÐÍ£º¶ÌÓï²éѯ¡¢Í¨Åä·û²éѯ ......
ÈÏʶORMÆäʵ×îÔçÔ´×ÔÒ»³¡ÕùÂÛ£¬¸÷¸ö¿ò¼Ü¶¼Éù³Æ¾ß±¸Á¼ºÃµÄORMʵÏÖ£¬µ«ÊÇʹ
Óúó·¢ÏÖ£¬Èç¹û½ö½öÊÇÇ¿ÖÆ·µ»ØÊý¾Ý¶ÔÏó»¹Éù³Æ×Ô¼ºÊÇORMµÄ»°£¬ÄǾÍêÝЦ´ó·½ÁË¡£ÄÇÖ»ÄÜ˵ÊÇαORM»òÊÇORA£¨array£©¶øÒÑ¡£ºÜÏÔÈ»·µ»ØµÄ¶ÔÏó³ýÁË
ÊôÐÔÖµÍ⣬»¹Ó¦¸Ã°üÀ¨¿ÉÖ´Ðз½·¨£¬ÊµÏÖ¶ÔÊý¾ÝµÄ²Ù×÷ÔËÓá£
ºóÀ´¹¤×÷¸ÄÓÃsymfony
¿ò¼Ü£¬¸Ã¿ò¼ÜÄÚÖÃÁ˶ ......
Êý×é
ÔÚʹÓà PHP ½øÐпª·¢µÄ¹ý³ÌÖУ¬»òÔç»òÍí£¬Äú»áÐèÒª´´½¨Ðí¶àÏàËÆµÄ±äÁ¿¡£ÎÞÐèºÜ¶àÏàËÆµÄ±äÁ¿£¬Äã¿ÉÒÔ°ÑÊý¾Ý×÷ÎªÔªËØ´æ´¢ÔÚÊý×éÖС£Êý×éÖеÄÔªËØ¶¼ÓÐ×Ô¼ºµÄ ID£¬Òò´Ë¿ÉÒÔ·½±ãµØ·ÃÎÊËüÃÇ¡£
ÓÐÈýÖÖÊý×éÀàÐÍ£º
ÊýÖµÊý×é
´øÓÐÊý×Ö ID ¼üµÄÊý×é
¹ØÁªÊý×é
Êý×éÖеÄÿ¸ö ID ¼ü¹ØÁªÒ»¸öÖµ
¶àάÊý×é
°üº¬Ò»¸ö»ò¶à¸öÊý×éµÄ ......
ǰÑÔ
¡¡¡¡
¡¡¡¡·Ï»°²»¶à˵£¬WebServiceÕâ¸öÈȰ¡£¬PHPÕâ¸ö»ð°¡£¬ÏëÓÃPHP¿ª·¢WebServiceÊÇÀíËùµ±È»µÄÊ¡£Ê²Ã´£¿²»¶®WebService£¿Ã»Ê£¬°Ù¶ÈһϾÍÖªµÀÁË¡£°¡£¿¿´²»¶®£¿²»¶®Ò²Ã»¹ØÏµ£¬Ö±½Ó¿´´óÉÙүдµÄ°É£º£©
¡¡¡¡´óÉÙÒ¯ÊǸö¼¤½ø·Ö×Ó£¬Ï²»¶Ö±½ÓÄôúÂë˵Ê£¬²»¹ýÔÚ°Ñ¿ÉÁ¯µÄ¶ÁÕßŪµÃһͷÎíˮ֮ǰ£¬»¹ÊÇÏÈ´óÖÂ˵һϱ¾ÎĵÄÄ¿ ......
ÏÈ×¼±¸ºÃÈí¼þ£º
·Ö±ðÔÚApache¹Ù·½¡¢php¹Ù·½¡¢mysql¹Ù·½ÏÂÔØ×îлòÎȶ¨°æ±¾
Ò»¡¢°²×°Apache£¬ÅäÖóɹ¦Ò»¸öÆÕÍ¨ÍøÕ¾·þÎñÆ÷
ÔËÐÐÏÂÔØºÃµÄ“apache_2.0.55-win32-x86-no_ssl.msi”£¬³öÏÖÈçϽçÃæ£º
³öÏÖApache HTTP Server 2.0.55µÄ°²×°Ïòµ¼½çÃæ£¬µã“Next”¼ÌÐø
È·È ......