¸÷λºÃ£¡
ÎÊÌâÊÇÕâÑùµÄ£¿ÎÒÔÚZendÀïÉè¼ÆÇ°Ì¨Ò³Ãæ£¬Ö÷Òª·ÖΪÈýÀàheader.phtml,footer.phtml,Öм䲿·ÖµÄÊÇÔÚscriptsÀïµÄ£¬¿ÉÊÇÎÒ°ÑÑù×ÓÈ«·ÅÔÚheader.phtmlÀΪʲôÔÚÄÚÍø¿ÉÒÔä¯ÀÀ£¬ÓÃÍâÍø¾ÍÏÔʾ²»³öÀ´£¿
¶øÇÒ£¬header.phtmlÀïÑùʽʼÖÕÓдíÎó£¬ÓëϵĵÄÒ³ÃæºÃÏñÁ¬²»ÆðÀ´£¿
Ð ......
ÒÔÇ°Ôø¾Îʹý£¬Ã»Óнâ¾ö£¬½ñÌìÔÙ´ÎÌáµ½¡£
°ï¶¥Ï ²»»á
1¡¢Á´½Ó´®ºó¼ÓÈë±àÂë²ÎÊýcharacterEncoding=utf8&mysqlEncoding=utf8
2¡¢Êý¾Ý¿â±àÂëÓëÁ¬½Ó´®²ÎÊýͳһ
½ñÌì»Ø¼ÒÒ»ÊÔ£¬Ã÷ÌìÀ´Õâ»Ø¸´£¬Ð»Ð»Â¥ÉÏ
ÖÐÎÄÓ¦¸ÃÓÃGBK±àÂë,¶ø²»ÊÇutf-8°É
ÃæÒ³£¬Êý¾Ý¿âÁ¬½Ó£¬Êý¾Ý¿â±àÂëͳһ¾ÍOKÁË
1.ÄãÊý¾Ý¿âºÍÊý¾Ý¿â±í±Ø ......
selcect name from tableA where code in (select code from tableB where id='tableB_id')and sex='01';ÆäÖÐwhereÓï¾äºóÃæµÄandÓÐÖ´ÐÐ˳ÐòÂð£¬ÊÇÏÈÖ´ÐÐcode in (select code from tableB where id='tableB_id') »¹ÊÇÏÈÖ´ÐÐsex='01'?¼±£¬ÎÒÏëÏÈÖ´ÐÐsex='01'Ìá¸ßЧÂÊ¡£ÎÒµÄÊý¾Ý¿âÊÇ ......
ßÀº¹£¬ÎÊÌ⻹û¸ãÇå³þ¾Í¼±×ŰÑÕâ¸öÌù×Ó½áÁË£¬
http://topic.csdn.net/u/20091115/16/ae3fa852-32d7-4c97-ac9f-44e33ed3d382.html?154770355
ÕâÀïÔÙ¿ªÒ»ÌùÎʰɡ£¡£
½âÊÍÒ»ÏÂΪʲômysql5ÀïÃæselect 1 union select 'a'
½á¹û¾ÍÊÇ
1
a
ÄØ£¬aΪʲôûÓб»×ª»»£¿ MYSQLµ½µ×ÊÇÈçºÎ½øÐÐÊý¾ÝÀ ......
ÎÒÓÐÁ½¸ö±í.
a±íÖÐÓлý·Ö×Ö¶Î.
b±íÒ²Óиö»ý·Ö×Ö¶Î.
ÒòΪa±íºÍb±íÊôÓÚ²»Í¬Á½¸öƽ̨.
Èç¹û×öµ½Í¬²½?¾ÍÊÇa±íÐ޸ĵÄʱºòͬʱÐÞ¸Äb±í.ͬʱb±íÐ޸ĵĻ°Ò²ÐÞ¸Äa±í.
±í 1
bbs_members(ÂÛ̳Óû§±í)
×Ö¶Î
uid(Óû§id),extcredits1(»ý·Ö),extcredits2(½ðÇ®)
±í 2
dede_m ......
±íA
×Ö¶ÎÃû id flag pid
1 1 111
2 3 222
3 1 111
4 1 333
5 2 222
±íB
×Ö¶ÎÃû id opention pid
1 1 111
2 1 111
3 2 111
4 1 222
5 2 222
±íC
id name
111 A
222 B
333 C
ÇëÎÊÈçºÎͳ¼ÆA±íÖÐflagΪ1ºÍflagΪ2ÒÔ¼°B±íÖÐopenti ......