Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚPHP+MYsql´óÁ¿Êý¾Ý´¦ÀíµÄÎÊÌâ

ÎÒÏÖÔÚÓиöÊý¾Ý¿â£¬Àï±ßÖ÷ÒªÓÐÁ½¸ö±í£¬class,news
ÏÖÔÚnews±íÓÐ2.3G£¬35W¶àÌõ¼Ç¼£¬ÎҵIJéѯ´ó²¿·ÖÊÇÒÔÏÂÐÎʽ£¬
select a.*,b.* from news as a inner join class as b
    on a.classid=b.classid
ÆÚÖÐnews ±íÀﻹÓиö nodeµÄ×ֶΣ¬Ò²Òª¼Ó½øselectÀҲ¾ÍÊÇÍêÕûµÄÊÇ
select a.*,b.* from news as a inner join class as b
    on a.classid=b.classid where classid=2 or node like '|2|%'

Ò»¸öÒ³ÃæÖÐÖÁÉÙÓÐ4¸öÕâÑùµÄ²éѯÓï¾ä£¬ÏÖÔÚ»ù±¾ÉÏ´ò²»¿ªÒ³ÃæÁË£¬ÎÒÔÚmysqlÀïÖ±½Ó²éѯҲҪ4·Ö¶àÖÓ£¬ÇëÎÊÓÐʲô°ì·¨ÄÜÓÅ»¯Ò»ÏÂÄØ£¬¿ÉÒÔ´ÓÊý¾Ý¿â»ò³ÌÐòÖж¼ÐС£µ«ÊÇÒ»¸öÎÊÌâ¾ÍÊDz»ÄÜ·Ö±íÁË£¬news ±í¼º¾­²»Äܱ䡣

²¹³äһϣ¬news ±íÖ»ÉèÖÃÁËÖ÷¼üID
1 node,classid ¼ÓË÷Òý
2 limit×Ó¾ä
3 inner join»»left join
4 ÀûÓÃExplain»ñÈ¡µÄÐÅÏ¢À´ÊµÏÖmysqlÓÅ»¯

ºÇºÇ£¬ÄÚÁ¬½ÓÕâô¶àÊý¾Ý²»Âý²Å¹ÖÁË¡£
1.½¨Á¢Ë÷Òý£¬±ÈÈçÄãµÄclassid¡£
2.Èç¹ûÄãµÄ±íÀàÐÍÊÇinnodbÄÇôÇë¸Ä³ÉMyISAM
3.ÕâÑù´óµÄÊý¾Ý²éѯ»¹ÊÇÓô洢¹ý³Ì°É£¬µÚÒ»´ÎÓеãÂý£¬µ«ÒÔºó»á¿ìºÜ¶àµÄ
4.ÖØÐ¼ܹ¹Êý¾Ý¿â

ÒýÓÃ
1 node,classid ¼ÓË÷Òý
2 limit×Ó¾ä
3 inner join»»left join
4 ÀûÓÃExplain»ñÈ¡µÄÐÅÏ¢À´ÊµÏÖmysqlÓÅ»¯
jackeyºÃ¿ìŶ

ÎÒÕâÀï±ß»¹ÓÐÁ½¸ö×ֶΣ¬Ò»¸öÊÇtop int(5)£¬Ò»¸öÊÇisdel int(5)
topÖµÊÇ0-6,isdelÖµÊÇ0 or 1
ÎÒÊDz»ÊÇÒ²½¨Á¢Ë÷Òý»áºÃÒ»µã°¡£¿
»¹ÓУ¬ÎÒÓõÄÊÇMYSQL5

¼ÈÈ»Áª±í²Ù×÷
where classid=2 or node like '|2|%'  classid


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

¿Õ¼äÉÏphpÎļþ²»ÄÜä¯ÀÀ£¬ä¯ÀÀ¾ÍÏÂÔØphpÎļþ

ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´Ô­Òò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......

ASP³ÌÐòÔ±ÈçºÎתȥ×ö PHP »ò JSP

ASP³ÌÐòÔ±ÈçºÎתȥ×ö PHP »ò JSP
Õâ½áÌùÂÊ....
ASP ×öµÃºÃµÄ»°,תPHP,Äã»á·¢ÏÖ¸ü¼òµ¥.. ¸ü·½±ã...

²î±ð²»´óÂð

PHP²»ÊÇÒªÔÚLinux ÉÏ¿ª·¢µÄÂð WindowsÉÏÓÃÌ×¼þºÃÏñ²»Êµ¼ÊÁ˵㣬¹ãLinuxÕâ¸ö¿²¾ÍÄѹýÈ¥ÁË£¬IISÓ ......

jsÈçºÎ»ñÈ¡µ½PHPÀïµÄ±äÁ¿»òsession

±¾È˸սӴ¥PHP,ÍêÈ«²»´ó¶®µÄ,ÔÚPHPÒ³ÃæÓбäÁ¿$fID; $_SESSION['mid']
ÏÖÔÚJSÀïÒªÅжÏÊÇ·ñ´æÔڴ˱äÁ¿$fID; »òÊÇ·ñ´æÔÚ$_SESSION['mid']
ÔÚ1.jsÒ³ÃæÀïÕâÑùÅжÏÒ²²»ÐÐ
function showdiv()
{
var kk=<?= $fID ? ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ