¹ØÓÚ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-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£ ¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......
ASP³ÌÐòÔ±ÈçºÎתȥ×ö PHP »ò JSP Õâ½áÌùÂÊ.... ASP ×öµÃºÃµÄ»°,תPHP,Äã»á·¢ÏÖ¸ü¼òµ¥.. ¸ü·½±ã... ²î±ð²»´óÂð PHP²»ÊÇÒªÔÚLinux ÉÏ¿ª·¢µÄÂð WindowsÉÏÓÃÌ×¼þºÃÏñ²»Êµ¼ÊÁ˵㣬¹ãLinuxÕâ¸ö¿²¾ÍÄѹýÈ¥ÁË£¬IISÓ ......
±¾È˸սӴ¥PHP,ÍêÈ«²»´ó¶®µÄ,ÔÚPHPÒ³ÃæÓбäÁ¿$fID; $_SESSION['mid'] ÏÖÔÚJSÀïÒªÅжÏÊÇ·ñ´æÔڴ˱äÁ¿$fID; »òÊÇ·ñ´æÔÚ$_SESSION['mid'] ÔÚ1.jsÒ³ÃæÀïÕâÑùÅжÏÒ²²»ÐÐ function showdiv() { var kk=<?= $fID ? ......