pdoÖ÷ÒªÊÇÓÃÀ´¶ÔÊý¾Ý¿â·ÃÎʵġ£²»Í¬Êý¾Ý¿âÔÚ·ÃÎÊʱ£¬²ÉÓÃÏàͬ·½·¨Ãû³Æ£¬
½â¾öÁËÊý¾Ý¿âÁ¬¿â²»Í³Ò»ÎÊÌâ¡£
mysql_connect ¡ª-mysql
oci_connect ¡ª-oracle
dbase_open ¡ª¡ªdbase
Á¬¿â¿ÉÒÔ£¬µ«ÊÇûÓÐͬÒâ±ê×¼£¬Ã¿´ÎÁ¬¿â£¬¶¼ÐèÒªÕÒ¶ÔÓ¦µÄÁ¬¿â·½·¨¡£
1.1 pdoÌص㣺
ÐÔÄÜ£º±È´«Í³·½Ê½Ð§Âʸߡ£
ÔËÐÐʱÀ©Õ¹£ºpdoÊÇÄ£¿é»¯µÄ¡£ÄÜÔÚÏîÄ¿ÔËÐÐʱ¼ÓÔØÊý¾Ý¿âµÄÇý¶¯¡£
1.2 pdoÈçºÎ°²×°
php.ini ²éÕÒ
ÕÒµ½À©Õ¹ÅäÖÃλÖà Ìí¼Óextension=php_pdo_mysql.dll Èç¹ûÓУ¬°ÑÇ°Ãæ·ÖºÅÈ¥µô¡£
extension=php_pdo.dll Ò²Òª´ò¿ª¡£
ÖØÆôapache
1¡¢´´½¨pdo¶ÔÏóµÄ¸ñʽ
$db = new PDO(¡°mysql:host=localhost;dbname=Êý¾Ý¿âÃû³Æ¡±,¡°Óû§Ãû¡±,¡°ÃÜÂ롱); //Á¬¿â
2 setAttribute()ΪÊý¾Ý¿âÁ¬½ÓÉèÖÃÊôÐÔ¡£
¸ñʽ£º
setAttribute(PDO::ATTR_CASE,PDO::CASE_UPPER);
PDO::ATTR_CASE »ñÈ¡½á¹û¼¯µÄʱºò£¬¹ØÁªÊý×éµÄË÷Òýʱ´óд»¹ÊÇСд¡£
PDO::CASE_UPPER £º´óд
PDO::CASe_LOWER: Сд¡£
PDO::CASE_NORMAL:ĬÈÏ¡£
3¡¢query()Ö´ÐÐsqlµÄ
$pdoObject->query($sql);
4¡¢setFetchMode(PDO::FETCH_ASSOC) ÉèÖûñÈ¡½á¹û¼¯µÄ·µ»ØÀàÐÍ¡£
PDO::FETCH_ASSOC Ö»·µ»Ø¹ØÁªÊý×é¡£
PDO::FETCH_NUM Ö»·µ»ØÊý×ÖϱêÊý×é¡£
PDO::FETCH_BOTH ĬÈϵģ¬¹ØÁªÊý×é+Êý×ÖϱêµÄÊý×é¡£
5 fetchAll()´Ó½á¹û¼¯µ«ÖгéÈ¡Êý¾Ý£¬·µ»ØÒ»¸öÊý×é¡£
6 exec Ö´ÐÐsqlÓï¾äÇÒ·µ»ØÊÜÓ°ÏìµÄÐÐÊý¡££¨insert delete update£©mysql_affected_rows
7 rowCount£¨£©//»ñÈ¡µÄÊÇselectµÄÐÐÊý¡£mysql_num_rows
±ØÐëÒªÏÈÈ¥µ½½á¹û¼¯¶ÔÏó£¬Óýá¹û¼¯¶ÔÏóµ÷Óá£
Àý×Ó£º
$sql = ¡°select * from category¡±;
$result = $db->query($sql); //Ö´ÐÐsql
$rowCount = $result->rowCount();
8 prepare()Éú³ÉÒ»¸ö²éѯ¶ÔÏó£¬select ,²»»áÁ¢¼´Ö´ÐС£
$obj = $db->prepare(¡°select * from test¡±);
9 execute() Ö´Ðвéѯ¶ÔÏó¡£
$obj->execute() //Ö´Ðвéѯ¶ÔÏó¡£ÓÐÑ»·À´±éÀú¡£
10 ´íÎóµÄ´¦Àí
²¶»ñÒì³£¡£
try{
//Õý³£
}catch(){
//´íÎ󲶻ñ¡£
}
try{
$db = new PDO(¡°mysql:host=localhost;dbname=test¡±,¡±root¡±,¡±root¡±);
}catch(PDOException $e){ //²¶»ñµÃ´íÎó¡£
echo $e->getMessage(); //´íÎóÐÅÏ¢
}
°ó¶¨Ê¼þ
1 bind£¨Ê¼þÃû³Æ£¬function(){}£©
2 ÔªËØ.ʼþÃû³Æ£¨function(){
}£©
ɾ³ýʼþ:
¸ñʽ£ºunbind(ʼþÀàÐÍ£¬ÒªÉ¾³ýµÄº¯Êý);
Ä£Äâ²Ù×÷
trigger£¨£© ×Ô¶¯´¥·¢Ê¼þ£¬ÔÚÒ³Ãæ¼ÓÔØÍê±Ïºó×Ô¶¯´¥·¢¡£
ÔªËØ.trigger(¡°Ê¼þÃû³Æ¡±)¡£
Àý×Ó£º
$(function(){ //µ±Ò³Ãæ¼ÓÔØÍê±Ïºó£¬»áΪbt°´Å¥°ó¶¨ÉÏclick£¬µ«ÊDz»µ¥»÷ÊDz»Ö´ÐС£
$(¡°#bt¡±).click(function(){
alert($(¡°#myDiv¡±).text());
})
$(¡°#bt¡±).trigger(¡°click¡±);//×Ô¶¯µ÷ÓÃbtµÄclick·½·¨¡£
})
aaaaaaaaa
×¢Ò⣺
trigger£¨²ÎÊý1£¬²ÎÊý2£©¿ÉÒÔÓвÎÊý
µÚÒ»¸ö²ÎÊýÊÇ×Ô¶¨ÒåʼþÃû³Æ¡£
µÚ¶þ¸ö²ÎÊýÊÇ´«¸øʼþ´¦Àíº¯ÊýµÄ¸½¼ÓÊý¾Ý£¬ÒÔÊý×éÐÎʽ´«µÝ¡£