×ðÁú¿­Ê±¹ÙÍøµÇ¼

laravelÅÌÎÊÌõÊý

laravelÊÇÒ»ÖÖºÜÊÇÊ¢ÐеÄphp¿ò¼Ü£¬¾ßÓмòÆÓÒ×Óá¢À©Õ¹ÐԺõÈÌصã¡£ÔÚʹÓÃlaravel¾ÙÐпª·¢Ê±£¬ÅÌÎÊÊý¾ÝÊÇ×î³£ÓõĹ¦Ð§Ö®Ò»¡£¶øÅÌÎÊÊý¾ÝÖУ¬ÅÌÎÊÌõÊýÒ²ÊÇÒ»¸öºÜÊÇÖ÷ÒªµÄ²Ù×÷¡£ÏÂÃ潫Ϊ¸÷ÈËÏÈÈÝÔÚlaravelÖÐÔõÑù¾ÙÐÐÅÌÎÊÌõÊýµÄÏà¹Ø²Ù×÷¡£

ÅÌÎÊÌõÊýµÄÒªÁì

ÔÚLaravelÖУ¬ÅÌÎÊÌõÊýµÄÒªÁìºÜÊǼòÆÓ£¬Ö»ÐèҪʹÓÃcount()ÒªÁì¼´¿É¡£count()ÒªÁìÎüÊÕÒ»¸ö²ÎÊý£¬¼´ÐèÒªÅÌÎÊÌõÊýµÄ×ֶλòÕßÕû¸ö±í¡£ÒÔÏÂÊÇcount()ÒªÁìµÄʹÓÃʾÀý£º

$count = DB::table('table_name')->count(); //ÅÌÎʱíÖÐ×ܹ²Óм¸¶àÌõÊý¾Ý
$count = DB::table('table_name')->where('condition', 'value')->count(); //ÅÌÎÊÇкÏÌõ¼þµÄÊý¾ÝÌõÊý

µÇ¼ºó¸´ÖÆ

ÉÏÊö´úÂëÖУ¬$countÊÇÅÌÎÊЧ¹ûµÄ×ÜÌõÊý¡£µÚÒ»ÐдúÂëÖУ¬Ê¹ÓÃcount()ÒªÁìÅÌÎÊÁËÕû¸ö±íÖÐÊý¾ÝµÄ×ÜÌõÊý¡£µÚ¶þÐдúÂëÖУ¬ÔòÊÇÅÌÎÊÇкÏÌõ¼þµÄÊý¾ÝÌõÊý¡£

ÈôÊÇÒªÅÌÎʶàÖÖÌõ¼þµÄÊý¾ÝÌõÊý£¬¿ÉÒÔʹÓöà¸öwhere()ÒªÁì¡£ÈçÏÂËùʾ£º

$count = DB::table('table_name')
        ->where('condition_1', 'value_1')
        ->where('condition_2', 'value_2')
        ->count();

µÇ¼ºó¸´ÖÆ

ÉÏÊö´úÂëÖУ¬Ê¹ÓÃÁËÁ½¸öwhere()ÒªÁ죬»®·ÖÅÌÎÊÁËÌõ¼þ1ºÍÌõ¼þ2ϵÄÊý¾ÝÌõÊý¡£

¾ÛºÏº¯Êýͳ¼Æ

ÔÚLaravelÖУ¬ÉÐÓÐÒ»ÖÖÔ½·¢¸ß¼¶µÄÅÌÎÊÒªÁ죬¿ÉÒÔʹÓþۺϺ¯ÊýÀ´ÊµÏÖÅÌÎÊͳ¼Æ¡£³£ÓõľۺϺ¯ÊýÓÐSUM¡¢AVG¡¢MAX¡¢MINºÍCOUNT¡£ÒÔÏÂÊÇʹÓÃSUMº¯ÊýÅÌÎÊÊý¾Ý×ÜÁ¿µÄʾÀý£º

$sum = DB::table('table_name')->sum('column_name');

µÇ¼ºó¸´ÖÆ

ÉÏÊö´úÂëÖУ¬Ê¹ÓÃsum()ÒªÁìÅÌÎÊÁ˱íÖÐij¸ö×ֶεÄ×ܺÍ¡£Ê¹ÓÃAVG¡¢MAX¡¢MINº¯ÊýÓësum()ÒªÁìµÄʹÓÃÒªÁìÀàËÆ¡£

ËäÈ»£¬Ê¹ÓÃCOUNTº¯ÊýÒ²¿ÉÒÔʵÏÖÅÌÎÊÌõÊýµÄ¹¦Ð§¡£ÒÔÏÂÊÇʹÓÃCOUNTº¯ÊýµÄʾÀý£º

$count = DB::table('table_name')
        ->select(DB::raw('count(*) as count'))
        ->get()[0]->count;

µÇ¼ºó¸´ÖÆ

ÉÏÊö´úÂëÖУ¬Ê¹ÓÃselect()ÒªÁìÖ¸¶¨ÐèÒªÅÌÎʵÄ×ֶΣ¬È»ºó´«ÈëCOUNT(*)º¯Êý×÷ΪÅÌÎÊÌõ¼þ¡£ÓÉÓÚÅÌÎÊЧ¹û·µ»ØµÄÊÇÒ»¸ö¹¤¾ßÊý×飬Òò´ËÐèҪʹÓÃget()[0]»ñÈ¡µÚÒ»¸ö¹¤¾ß£¬²¢Ê¹ÓÃ->count»ñÈ¡count×ֶεÄÖµ¡£

ͨ¹ýʹÓÃCOUNTº¯Êý£¬»¹¿ÉÒÔʵÏÖ·Ö×éÅÌÎÊͳ¼ÆµÄ¹¦Ð§¡£ÒÔÏÂÊÇʹÓÃCOUNTº¯Êý¾ÙÐзÖ×éÅÌÎÊͳ¼ÆµÄʾÀý£º

$results = DB::table('table_name')
        ->select('category', DB::raw('count(*) as count'))
        ->groupBy('category')
        ->get();

µÇ¼ºó¸´ÖÆ

ÉÏÊö´úÂëÖУ¬Ê¹ÓÃgroupBy()ÒªÁì¶Ôcategory×ֶξÙÐзÖ×飬ȻºóʹÓÃCOUNT(*)º¯Êýͳ¼Æÿ¸ö·Ö×éµÄÊý¾ÝÌõÊý¡£ÅÌÎÊЧ¹û½«·µ»ØÒ»¸ö¹¤¾ßÊý×飬°üÀ¨Ã¿¸ö·Ö×éµÄÊý¾Ýͳ¼ÆЧ¹û¡£

×ܽá

ÔÚLaravel¿ò¼ÜÖУ¬ÅÌÎÊÊý¾ÝÖÐÅÌÎÊÌõÊýÊÇÒ»¸öºÜÊÇÖ÷ÒªµÄ²Ù×÷¡£Í¨¹ýʹÓÃcount()ÒªÁìºÍ¾ÛºÏº¯Êý£¬ÎÒÃÇ¿ÉÒÔ¿ìËÙ¡¢Àû±ãµØ¾ÙÐÐÌõÊýÅÌÎʺÍͳ¼Æ¡£ÔÚÏÖʵ¿ª·¢ÖУ¬ÐèҪƾ֤²î±ðµÄÓªÒµÐèÇó£¬Ñ¡Ôñ²î±ðµÄÅÌÎÊÒªÁìºÍ¾ÛºÏº¯Êý£¬ÒÔÖª×㿪·¢µÄÒªÇó¡£

ÒÔÉϾÍÊÇlaravelÅÌÎÊÌõÊýµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í×ðÁú¿­Ê±¹ÙÍøµÇ¼ÂËÓÍ»úÍø¹Ù·½Á¢³¡£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼

18523999891

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎ壬9:30-18:30£¬½ÚãåÈÕÐÝÏ¢

QR code
ÍøÕ¾µØͼ