¹ØÓÚ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
Ïà¹ØÎÊ´ð£º
¸÷λ´óÏÀ ÇóÒ»¶Îphp´úÂë ¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ ¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½ Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡ Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7 µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡ ÔÚPHPÎļþÀï ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......