PHPÍæתMySQLÖ®Íâ¼üÔ¼Êø
ÄÏÈý·½
ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Ñ§Ï°ÈçºÎͨ¹ýPHP 5µÄÒ»¸ö»ù±¾³éÏóÀàʹÓÃÍâ¼üÔ¼ÊøÀ´¸üÐÂÁ½¸öInnoDB±íµÄÊý¾Ý¡£ ÎÒÃǽ«Í¨¹ý¾ßÌåʾÀýÀ´ËµÃ÷ÈçºÎͨ¹ý·þÎñÆ÷¶Ë½Å±¾ÓïÑÔÀ´Ê¹ÓÃÍâ¼üÔ¼Êø¡£
¡¡¡¡Ò»¡¢ÀûÓÃÍâ¼üÔ¼Êø¸üÐÂMySQLÖеÄÊý¾Ý
¡¡¡¡ÏÖÔÚ£¬×îÁ÷ÐеĿªÔ´¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ·ÇMySQLĪÊô£¬¶øMySQLÓÖÖ§³Ö¶à¸ö´æ´¢ÒýÇ棬ÆäÖÐĬÈϵÄÒ²ÊÇËٶȽϿìµÄ´æ´¢ÒýÇæΪMyISAM£¬¶ÔÐí¶à¶ÁÕßÀ´Ëµ£¬ÔÚ¿ª·¢×Ô¼ºÊý¾Ý¿âÇý¶¯µÄwebÓ¦ÓóÌÐò֮ǰ£¬¿ÉÄÜÒѾʹÓÃÁËËüºÜ³¤Ò»¶Îʱ¼äÁË¡£
¡¡¡¡È»¶ø£¬ÓÐʱºòÎÒÃǵÄÏîÄ¿¿ÉÄÜÐèÒª¶îÍâµÄÌØÐÔ£¬ÀýÈçÐèÒª´¦ÀíÍâ¼üÔ¼Êø£¬ÕâʱÎÒÃǾÍÐèÒªÓõ½ÆäËüÀàÐ͵ÄMySQL´æ´¢ÒýÇæ¡£ÔÚÕâÖÖÇé¿öÏ£¬InnoDB±í½«·Ç³£ÊʺÏÎÒÃǵÄÒªÇ󣬾¡¹ÜÔÚÐÔÄÜ·½Ãæ¿ÉÄܱÈMyISAM±íÒªÉÔÑ·Ò»³ï¡£´ó¼ÒÖªµÀ£¬Ê¹ÓÃInnoDB±íÍâ¼üÔ¼ÊøÖ÷ÒªÓŵãÖ®Ò»¾ÍÊÇ£¬ËüʹÎÒÃÇ¿ÉÒÔÔÚÊý¾Ý¿â¼¶±ð´¦ÀíºÍά»¤¶à¸ö±íÖ®¼äµÄ¹Øϵ£¬¶øÎÞÐ轫´ËÈÎÎñÍƸøÓëÕâЩ±í´ò½»µÀµÄÓ¦ÓóÌÐòµÄijЩģ¿é»òÕß³ÌÐò¿â¡£
¡¡¡¡µ±È»£¬Ç°ÃæµÄ¼¸ÆªÎÄÕÂÖУ¬ÎÒÃÇÒѾ¾ÍIndoDB±íµÄÍâ¼üÔ¼Êø×ö¹ýÏàÓ¦½éÉÜ£¬µ«ÊÇÄÇÀﶼÊÇͨ¹ýÊÖ¹¤·½Ê½À´²Ù×÷Íâ¼üÔ¼ÊøµÄ¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«ËµÃ÷ÈçºÎÔÚ¸üкÍɾ³ý¸¸±íÖеÄÊý¾Ýʱ£¬ÈçºÎͨ¹ý½Å±¾ÓïÑÔÀ´´¥·¢ÏàÓ¦×Ó±íµÄ¼¶Áª¸üкÍɾ³ý²Ù×÷¡£
¡¡¡¡ÕâÀÎÒÃDz©¿ÍÓ¦ÓóÌÐòµÄÊý¾Ý²ãÓÉÁ½¸ö±í¹¹³É£¬ÔÚÇ°ÃæµÄʾÀýÖУ¬¶ÔÕâЩ±íµÄ²Ù×÷£¬¶¼ÊÇͨ¹ýÊÖ¹¤¼üÈëSQLÃüÁîÍê³ÉµÄ£¬ÏÖÔÚ£¬ÎÒÃǽ«½éÉÜÈçºÎʹÓÃPHP³ÌÐòÉè¼ÆÓïÑÔÀ´Íê³ÉÕâЩ¹¤×÷¡£Ö®ËùÒÔÑ¡ÔñPHP£¬ÊÇÒòΪËüÄ¿Ç°MySQL×î³£¼ûµÄ´îÅäÓïÑÔ£¬ÏÂÃæÎÒÃÇÒÔPHP 5ΪÀýÀ´ËµÃ÷ÈçºÎÍâ¼üÔ¼Êø²Ù×÷Á½¸öInnoDB±í¡£ ͨ¹ýÔĶÁ±¾ÎÄ£¬Äú½«¸ü¼ÓÕæÇеØÌå»áµ½Íâ¼üÔ¼ÊøµÄÌØÐÔ¡£
¡¡¡¡ÏÖÔÚ£¬ÎÒÃÇ¿ªÊ¼¼ûÖ¤PHP 5ºÍÍâ¼üÔ¼Êø½áºÏÔÚÒ»ÆðËù´øÀ´µÄÍþÁ¦°É!
¡¡¡¡¶þ¡¢ÒÔ¼¶Áª·½Ê½¸üкÍɾ³ýÊý¾Ý¿âÖеÄÊý¾Ý
¡¡¡¡¹ÅÈËÔÆ£¬Î¹ʶø֪У¬ÄÇôÏÈÈÃÎÒÃÇÀ´»Ø¹ËÒ»ÏÂÇ°Ãæѧ¹ýµÄÄÚÈÝ°É¡£Ö®Ç°£¬ÎÒÃǽéÉܹýÈçºÎÔËÓÃÍâ¼üÔ¼Êø¼¶Áª¸üкÍɾ³ý´æ·Å²©¿ÍÎÄÕÂÆÀÂÛµÄInnoDB±íÖеÄÊý¾Ý¡£Èç¹ûÄúÉÐδÔĶÁÇ°ÃæµÄÎÄÕÂÒ²²»Òª½ô£¬ÏÂÃæÎÒÃǼòµ¥»Ø¹ËÕâЩÄÚÈÝ¡£
¡¡¡¡ÕâÀïÊÇÎÒÃǵÄʾÀýÖÐÓõ½µÄÁ½¸ö±íµÄ¶¨Ò壬ÈçÏÂËùʾ£º
Code highlighting produced by Actipro CodeHighlighter (freeware)
DROP TABLE IF EXISTS `test`.`blogs`;
CREATE TABLE `test`.`blogs` (
`id` INT(10) UNSIGNED AUTO_INCREMENT,
`title` TEXT,
`content` TEXT,
`author` VARCHAR(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE
Ïà¹ØÎĵµ£º
ÈÎÎñÐèÇó£ºÒ»¸ö»áÒéͶ¸åϵͳ£¬ÔÚ×÷ÕßÌá½»ÂÛÎÄժҪʱ×Ô¶¯Ïò×÷Õß·¢ËÍÒ»·âÈ·ÈÏÓʼþ¡£
(×¢£ºÍ¶¸åϵͳʹÓõÄÊÇmyreview
)
×Ðϸ¿¼ÂÇһϣ¬Õâ¸öÈÎÎñ¿ÉÒÔÓÐÒÔϼ¸ÖÖ·½Ê½Íê³É£º
ÔÚ·þÎñÆ÷ÉÏÅäÖÃsendmail·þÎñ£¬Ê¹ÓÃphpÖеĵÄmailº¯Êý·¢ËÍÓʼþ£»
ÔÚ·þÎñÆ÷ÉÏ°²×°mutt + msmtp£¬»òÕßÔÚ·þÎñÆ÷ÉÏ°²×°ÆäËüµÄsmtp¿Í»§¶Ë³ÌÐò£¬Ê¹ÓÃsmtp¿Í» ......
¼ÙÉèÓбí tb1
ID £ü name£ü
----+--------+
1 £ü2toon£ü
2 £ü1*xyz£ü
Óï¾ä1£º
select * from tb1 where ID='2toon' or name ='2toon';
mysql·þÎñÆ÷ÔÚijģʽÏ£¬¿ÉÒÔÖ´ÐÐÕâÌõ¾ä£¬¾Í³É¹¦·µ»ØÁ½Ìõ¼Ç¼£¬ÔÒòÔÚÓÚ ID=‘2toon’ ¼ÓÁ˵¥ÒýºÅ£¬mysql½âÊÍΪ ID=2.
Óï¾ä2
select * fro ......
Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬
ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£
·½·¨Ò»
ʹÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬
²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
·½·¨¶þ
ʹÓÃmysqladmin£¬ÕâÊÇÇ°ÃæÉùÃ÷µÄÒ»¸öÌØÀý¡£
mysqladmin -u root -p password mypas ......
create procedure all_joiner_message( in captions varchar(255), in contents text, in objectid int, in types int , out count int)
begin
declare userids int;
DECLARE _done IN ......
windowsÏÂ:
1.ÏÂÔØÓÃÓÚ Windows µÄ Instant Client Basic ³ÌÐò°ü:http://download.oracle.com/otn/nt/instantclient/111070/instantclient-basic-win32-11.1.0.7.0.zip
2.½âѹËõ
´´½¨Ò»¸ö×ÓĿ¼£¨ÀýÈ磬d:\oci£©£¬È»ºó´ÓѹËõÎļþÖи´ÖÆÒÔÏ¿⣺
oraociei10.dll
orannzsbb10.dll
oci.dll
µ½´ËĿ¼ÏÂ
´ò¿ªPHP.ini ......