php - SQL/Laravel 构建查询-6ren

php - SQL/Laravel 构建查询

转载作者：行者123 更新时间：2023-11-29 10:52:05

我目前对此感到非常沮丧，我非常感谢任何帮助!

我有一个 SQL 表，用于跟踪人们何时单击网站上的某些按钮。每当有人单击该按钮时，它就会在桌面上创建一个事件。

我目前正在做的是构建一个页面，在 Google 可视化图表上显示这些统计信息。我已经让它工作了，但我 100% 确定有一种更快、更干净的方法来做到这一点。

添加更多详细信息

我想做的是将数据库列类型分组，然后我想计算每组的数量并将其显示在图 TableView 上。这目前正在工作，但我想学习如何缩短 Controller 中的功能。

我是 SQL 新手，最近才学习基础知识，因此希望获得更多指导。

这是数据库的示例:

database image

这是 Controller 中的函数

public function UsedCarsSearch() {      

    // Used Car Search

    $searchmodeldropdown              = UsedCarsAnalytics::where('type', '=', 'search-model-dropdown')->count();
    $searchmanufacturerdropdown       = UsedCarsAnalytics::where('type', '=', 'search-manufacturer-dropdown')->count();
    $searchvehiclesbutton             = UsedCarsAnalytics::where('type', '=', 'search-vehicles-button')->count();
    $searchfueltypedropdown           = UsedCarsAnalytics::where('type', '=', 'search-fuel-type-dropdown')->count();
    $searchtransmissiondropdown       = UsedCarsAnalytics::where('type', '=', 'search-transmission-dropdown')->count();
    $searchenginesizedropdown         = UsedCarsAnalytics::where('type', '=', 'search-engine-size-dropdown')->count();
    $searchdoorsdropdown              = UsedCarsAnalytics::where('type', '=', 'search-doors-dropdown')->count();
    $refinesearchmobilebutton         = UsedCarsAnalytics::where('type', '=', 'refine-search-mobile-button')->count();
    $searchseatsdropdown              = UsedCarsAnalytics::where('type', '=', 'search-seats-dropdown')->count();
    $searchmaxpricedropdown           = UsedCarsAnalytics::where('type', '=', 'search-max-price-dropdown')->count();
    $menulinkmobilemenusearchbutton   = UsedCarsAnalytics::where('type', '=', 'menu-link-mobile-menu-search-button')->count();
    $searchmaxmileagedropdown         = UsedCarsAnalytics::where('type', '=', 'search-searchbox-dropdown')->count();
    $searchsearchboxdropdown          = UsedCarsAnalytics::where('type', '=', 'search-max-mileage-dropdown')->count();
    $searchminpricedropdown           = UsedCarsAnalytics::where('type', '=', 'search-min-price-dropdown')->count();
    $searchpostcodedropdown           = UsedCarsAnalytics::where('type', '=', 'search-postcode-dropdown')->count();
    $search                           = UsedCarsAnalytics::where('type', '=', 'search')->count();
    $searchminmileagedropdown         = UsedCarsAnalytics::where('type', '=', 'search-min-mileage-dropdown')->count();
    $searchvehiclesbuttonmobiletop    = UsedCarsAnalytics::where('type', '=', 'search-vehicles-button-mobile-top')->count();
    $approvedusedsearchtab            = UsedCarsAnalytics::where('type', '=', 'approved-used-search-tab')->count();
    $resetsearchbutton                = UsedCarsAnalytics::where('type', '=', 'reset-search-button')->count();
    $newsearchtab                     = UsedCarsAnalytics::where('type', '=', 'new-search-tab')->count();
    $servicesearchtab                 = UsedCarsAnalytics::where('type', '=', 'service-search-tab')->count();
    $searchminadvancedpaymentdropdown = UsedCarsAnalytics::where('type', '=', 'search-min-advanced-payment-dropdown')->count();
    $searchmaxadvancedpaymentdropdown = UsedCarsAnalytics::where('type', '=', 'search-max-advanced-payment-dropdown')->count();
    $resetsearchbuttonmobiletop       = UsedCarsAnalytics::where('type', '=', 'reset-search-button-mobile-top')->count();
    $searchmaxmonthlypaymentdropdown  = UsedCarsAnalytics::where('type', '=', 'search-max-monthly-payment-dropdown')->count();
    $searchminmonthlypaymentdropdown  = UsedCarsAnalytics::where('type', '=', 'search-min-monthly-payment-dropdown')->count();


    // Vehicle Spec Interest

    $accordionopenaccordiondriverconvenience    = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-driver-convenience')->count();
    $accordionopenaccordioninteriorfeatures     = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-interior-features')->count();
    $accordionopenaccordionexteriorfeatures     = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-exterior-features')->count();
    $accordionopenaccordionentertainment        = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-entertainment')->count();
    $accordionopenaccordionsafety               = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-safety')->count();
    $accordionopenaccordionsecurity             = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-security')->count();
    $accordionopenaccordionfuelconsumption      = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-fuel-consumption')->count();
    $accordionopenaccordionperformance          = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-performance')->count();
    $accordionopenaccordionwheels               = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-wheels')->count();
    $accordionopenaccordiongeneral              = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-general')->count();
    $accordionopenaccordiontechnical            = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-technical')->count();
    $accordionopenaccordionemissions            = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-emissions')->count();
    $accordionopenaccordionengineanddrivetrain  = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-engine-and-drive-train')->count();
    $accordionopenaccordiontyres                = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-tyres')->count();
    $accordionopenaccordiontrim                 = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-trim')->count();
    $accordionopenaccordionweightandcapacities  = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-weight-and-capacities')->count();
    $accordionopenaccordionvehicledimensions    = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-vehicle-dimensions')->count();
    $accordionopenaccordionpacks                = UsedCarsAnalytics::where('type', '=', 'accordion-open accordion-packs')->count();
    $accordionopeninteriorfeatures              = UsedCarsAnalytics::where('type', '=', 'accordion-open interior-features')->count();

    // Bodystyle Interest

    $hatchback      = UsedCarsAnalytics::where('type', '=', 'hatchback-option-checkbox')->count();
    $estate         = UsedCarsAnalytics::where('type', '=', 'estate-option-checkbox')->count();
    $suv            = UsedCarsAnalytics::where('type', '=', 'suv-option-checkbox')->count();
    $fourxfour      = UsedCarsAnalytics::where('type', '=', '4x4-option-checkbox')->count();
    $mpv            = UsedCarsAnalytics::where('type', '=', 'mpv-option-checkbox')->count();
    $saloon         = UsedCarsAnalytics::where('type', '=', 'saloon-option-checkbox')->count();
    $sport          = UsedCarsAnalytics::where('type', '=', 'sport-option-checkbox')->count();
    $convertible    = UsedCarsAnalytics::where('type', '=', 'convertible-option-checkbox')->count();
    $coupes         = UsedCarsAnalytics::where('type', '=', 'coupes-option-checkbox')->count();
    $pickup         = UsedCarsAnalytics::where('type', '=', 'pickup-option-checkbox')->count();
    $crewvan        = UsedCarsAnalytics::where('type', '=', 'crew-van-option-checkbox')->count();
    $doublecab      = UsedCarsAnalytics::where('type', '=', 'double-cab-option-checkbox')->count();
    $minibus        = UsedCarsAnalytics::where('type', '=', 'minibus-option-checkbox')->count();
    $tipper         = UsedCarsAnalytics::where('type', '=', 'tipper-option-checkbox')->count();
    $dropside       = UsedCarsAnalytics::where('type', '=', 'dropside-option-checkbox')->count();
    $luton          = UsedCarsAnalytics::where('type', '=', 'luton-option-checkbox')->count();
    $chassis        = UsedCarsAnalytics::where('type', '=', 'chassis-option-checkbox')->count();
    $box            = UsedCarsAnalytics::where('type', '=', 'box-option-checkbox')->count();
    $curtainslider  = UsedCarsAnalytics::where('type', '=', 'curtainslider-option-checkbox')->count();
    $platformcab    = UsedCarsAnalytics::where('type', '=', 'platform-cab-option-checkbox')->count();
    $refridgerated  = UsedCarsAnalytics::where('type', '=', 'refridgerated-option-checkbox')->count();
    $freezer        = UsedCarsAnalytics::where('type', '=', 'freezer-option-checkbox')->count();


    // Options Interest

    $airconditioning    = UsedCarsAnalytics::where('type', '=', 'air-conditioning-option-checkbox')->count();
    $bluetooth          = UsedCarsAnalytics::where('type', '=', 'bluetooth-option-checkbox')->count();
    $satnav             = UsedCarsAnalytics::where('type', '=', 'sat-nav-option-checkbox')->count();
    $cruisecontrol      = UsedCarsAnalytics::where('type', '=', 'cruise-control-option-checkbox')->count();
    $parkingsensors     = UsedCarsAnalytics::where('type', '=', 'parking-sensors-option-checkbox')->count();
    $heatedwindscreen   = UsedCarsAnalytics::where('type', '=', 'heated-windscreen-option-checkbox')->count();
    $cdplayer           = UsedCarsAnalytics::where('type', '=', 'cd-player-option-checkbox')->count();
    $dabradio           = UsedCarsAnalytics::where('type', '=', 'dab-radio-option-checkbox')->count();
    $auxinput           = UsedCarsAnalytics::where('type', '=', 'aux-input-option-checkbox')->count();
    $parkassist         = UsedCarsAnalytics::where('type', '=', 'park-assist-option-checkbox')->count();
    $phonenav           = UsedCarsAnalytics::where('type', '=', 'phone-nav-option')->count();
    $heatedseats        = UsedCarsAnalytics::where('type', '=', 'heated-seats-option-checkbox')->count();
    $parkingcamera      = UsedCarsAnalytics::where('type', '=', 'parking-camera-option-checkbox')->count();
    $leatherinterior    = UsedCarsAnalytics::where('type', '=', 'leather-interior-option-checkbox')->count();
    $keylessentry       = UsedCarsAnalytics::where('type', '=', 'keyless-entry-option-checkbox')->count();
    $dvdplayer          = UsedCarsAnalytics::where('type', '=', 'dvd-player-option-checkbox')->count();
    $metallicpaint      = UsedCarsAnalytics::where('type', '=', 'metallic-paint-option-checkbox')->count();
    $mp3player          = UsedCarsAnalytics::where('type', '=', 'mp3-player-option-checkbox')->count();
    $spoiler            = UsedCarsAnalytics::where('type', '=', 'spoiler-option-checkbox')->count();


    // Image Interests

    $interiorinterests      = UsedCarsAnalytics::where('type', '=', 'interior-images-tab')->count();
    $exteriorinterests      = UsedCarsAnalytics::where('type', '=', 'exterior-images-tab')->count();
    $featuresinterests      = UsedCarsAnalytics::where('type', '=', 'features-images-tab')->count();
    $allinterests           = UsedCarsAnalytics::where('type', '=', 'all-images-tab')->count();
    $imagesonlyinterests    = UsedCarsAnalytics::where('type', '=', 'images-only-option-checkbox')->count();


    // Sort By Button

    $sortByButton           = UsedCarsAnalytics::where('type', '=', 'sort-bar-dropdown')->count();

    return View::make('reports.used-cars-search', compact(
        'searchmodeldropdown',
        'searchmanufacturerdropdown',
        'searchvehiclesbutton',
        'searchfueltypedropdown',
        'searchtransmissiondropdown',
        'searchenginesizedropdown',
        'searchdoorsdropdown',
        'refinesearchmobilebutton',
        'searchseatsdropdown',
        'searchmaxpricedropdown',
        'menulinkmobilemenusearchbutton',
        'searchmaxmileagedropdown',
        'searchsearchboxdropdown',
        'searchminpricedropdown',
        'searchpostcodedropdown',
        'search',
        'searchminmileagedropdown',
        'searchvehiclesbuttonmobiletop',
        'approvedusedsearchtab',
        'resetsearchbutton',
        'newsearchtab',
        'servicesearchtab',
        'searchminadvancedpaymentdropdown',
        'searchmaxadvancedpaymentdropdown',
        'resetsearchbuttonmobiletop',
        'searchmaxmonthlypaymentdropdown',
        'searchminmonthlypaymentdropdown',
        'accordionopenaccordiondriverconvenience',
        'accordionopenaccordioninteriorfeatures',
        'accordionopenaccordionexteriorfeatures',
        'accordionopenaccordionentertainment',
        'accordionopenaccordionsafety',
        'accordionopenaccordionsecurity',
        'accordionopenaccordionfuelconsumption',
        'accordionopenaccordionperformance',
        'accordionopenaccordionwheels',
        'accordionopenaccordiongeneral',
        'accordionopenaccordiontechnical',
        'accordionopenaccordionemissions',
        'accordionopenaccordionengineanddrivetrain',
        'accordionopenaccordiontyres',
        'accordionopenaccordiontrim',
        'accordionopenaccordionweightandcapacities',
        'accordionopenaccordionvehicledimensions',
        'accordionopenaccordionpacks',
        'accordionopeninteriorfeatures',
        'hatchback',
        'estate',
        'suv',
        'fourxfour',
        'mpv',
        'saloon',
        'sport',
        'convertible',
        'coupes',
        'pickup',
        'crewvan',
        'doublecab',
        'minibus',
        'tipper',
        'dropside',
        'luton',
        'chassis',
        'box',
        'curtainslider',
        'platformcab',
        'refridgerated',
        'freezer',
        'airconditioning',
        'bluetooth',
        'satnav',
        'cruisecontrol',
        'parkingsensors',
        'heatedwindscreen',
        'cdplayer',
        'dabradio',
        'auxinput',
        'parkassist',
        'phonenav',
        'heatedseats',
        'parkingcamera',
        'leatherinterior',
        'keylessentry',
        'dvdplayer',
        'metallicpaint',
        'mp3player',
        'spoiler',
        'interiorinterests',
        'exteriorinterests',
        'featuresinterests',
        'allinterests',
        'imagesonlyinterests',
        'sortByButton'
    ));

这是 View Blade :

@extends('templates/master')

@section('content')

<style type="text/css">
    .analytics-charts {
        display: inline-block;
        width: 32.2%;
        height: 400px;
        border: 1px solid #ddd;
        vertical-align: top;
        border-radius: 10px;
        background: #f5f5f5;
        padding: 20px;
        margin-right: 1.45%;
        margin-bottom: 1.45%;
    }

    .analytics-single {
        display: inline-block;        
        border: 1px solid #ddd;
        vertical-align: top;
        border-radius: 10px;
        background: #f5f5f5;
        padding: 20px;
        margin-right: 1.45%;
        margin-bottom: 1.45%;
    }
</style>

<h1>Used Car Search Web Analytics</h1>

<div class="analytics-charts">
    <h2>Used Car Search</h2>
    <h3>Click Count</h3>
    <div id="pieChart"></div>
</div>

<div class="analytics-charts">
    <h2>Vehicle Spec Interest</h2>
    <h3>Click Count</h3>
    <div id="pieChartVehicle"></div>
</div>

<div class="analytics-charts">
    <h2>Bodystyle Interests</h2>
    <h3>Click Count</h3>
    <div id="pieChartBody"></div>
</div>

<div class="analytics-charts">
    <h2>Options Interests</h2>
    <h3>Click Count</h3>
    <div id="pieChartOptIn"></div>
</div>

<div class="analytics-charts">
    <h2>Image Interests</h2>
    <h3>Click Count</h3>
    <div id="pieChartImgInt"></div>
</div>

<div class="analytics-single">
    <h2>Sort By</h2>
    <h3>Click Count {{ $sortByButton }}</h3>
</div>

@stop
@section('scripts')
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

    <!-- Used Car Search Pie -->
    <script>

        google.charts.load('current', {'packages': ['corechart']});
        google.charts.setOnLoadCallback(drawChart);
        function drawChart() {

            var data = new google.visualization.DataTable();
            data.addColumn('string', 'Used Car Search');
            data.addColumn('number', 'Click Count');
            data.addRows([      
                ['Model', <?php echo $searchmodeldropdown ?>],
                ['Manufacturer', <?php echo $searchmanufacturerdropdown ?>],
                ['Vehicles Button', <?php echo $searchvehiclesbutton ?>],
                ['Fuel Type', <?php echo $searchfueltypedropdown ?>],
                ['Transmission', <?php echo $searchtransmissiondropdown ?>],
                ['Engine Size', <?php echo $searchenginesizedropdown ?>],
                ['Doors', <?php echo $searchdoorsdropdown ?>],
                ['Refine Search Mobile', <?php echo $refinesearchmobilebutton ?>],
                ['Seats', <?php echo $searchseatsdropdown ?>],
                ['Max Price', <?php echo $searchmaxpricedropdown ?>],
                ['Menu Link Mobile Menu Search', <?php echo $menulinkmobilemenusearchbutton ?>],
                ['Max Mileage', <?php echo $searchmaxmileagedropdown ?>],
                ['Searchbox', <?php echo $searchsearchboxdropdown ?>],
                ['Min Price', <?php echo $searchminpricedropdown ?>],
                ['Postcode', <?php echo $searchpostcodedropdown ?>],
                ['Search', <?php echo $search ?>],
                ['Min Mileage', <?php echo $searchminmileagedropdown ?>],
                ['Vehicles Button Mobile Top', <?php echo $searchvehiclesbuttonmobiletop ?>],
                ['Approved Used Search Tab', <?php echo $approvedusedsearchtab ?>],
                ['Reset Search Button', <?php echo $resetsearchbutton ?>],
                ['New Search Tab', <?php echo $newsearchtab ?>],
                ['Service Search Tab', <?php echo $servicesearchtab ?>],
                ['Min advanced Payment', <?php echo $searchminadvancedpaymentdropdown ?>],
                ['Max advanced Payment', <?php echo $searchmaxadvancedpaymentdropdown ?>],
                ['Reset Search Button Mobile Top', <?php echo $resetsearchbuttonmobiletop ?>],
                ['Search Max Monthly Payment', <?php echo $searchmaxmonthlypaymentdropdown ?>],
                ['Search Min Monthly Payment', <?php echo $searchminmonthlypaymentdropdown ?>],
            ]);

            var options = {
                title: 'My Daily Activities',
            };

            options.chartArea = {left: 0, 'width': '90%', 'height': '90%'}

            var chart = new google.visualization.PieChart(document.getElementById('pieChart'));

            chart.draw(data, options);
        }
    </script>

    <!-- Vehicle Spec Interest Pie -->
    <script>       
        google.charts.load('current', {'packages': ['corechart']});
        google.charts.setOnLoadCallback(drawChartVehicle);
        function drawChartVehicle() {

            var data = new google.visualization.DataTable();
            data.addColumn('string', 'Used Car Search');
            data.addColumn('number', 'Click Count');
            data.addRows([                      
                ['Driver Convenience', <?php echo $accordionopenaccordiondriverconvenience ?>],
                ['Interior Features', <?php echo $accordionopenaccordioninteriorfeatures ?>],
                ['Exterior Features', <?php echo $accordionopenaccordionexteriorfeatures ?>],
                ['Entertainment', <?php echo $accordionopenaccordionentertainment ?>],
                ['Safety', <?php echo $accordionopenaccordionsafety ?>],
                ['Security', <?php echo $accordionopenaccordionsecurity ?>],
                ['Fuel Consumption', <?php echo $accordionopenaccordionfuelconsumption ?>],
                ['Performance', <?php echo $accordionopenaccordionperformance ?>],
                ['Wheels', <?php echo $accordionopenaccordionwheels ?>],
                ['General', <?php echo $accordionopenaccordiongeneral ?>],
                ['Technical', <?php echo $accordionopenaccordiontechnical ?>],
                ['Emissions', <?php echo $accordionopenaccordionemissions ?>],
                ['Engine and Drivetrain', <?php echo $accordionopenaccordionengineanddrivetrain ?>],
                ['Tyres', <?php echo $accordionopenaccordiontyres ?>],
                ['Trim', <?php echo $accordionopenaccordiontrim ?>],
                ['Weight and Capacities', <?php echo $accordionopenaccordionweightandcapacities ?>],
                ['Vehicle Dimensions', <?php echo $accordionopenaccordionvehicledimensions ?>],
                ['Packs', <?php echo $accordionopenaccordionpacks ?>],
                ['Interior Features', <?php echo $accordionopeninteriorfeatures ?>]
            ]);

            var options = {
                title: 'My Daily Activities',
            };

            options.chartArea = {left: 0, 'width': '90%', 'height': '90%'}

            var chart = new google.visualization.PieChart(document.getElementById('pieChartVehicle'));

            chart.draw(data, options);
        }
    </script>

    <!-- Bodystyles Pie -->
    <script>       
        google.charts.load('current', {'packages': ['corechart']});
        google.charts.setOnLoadCallback(drawChartBodyInt);
        function drawChartBodyInt() {

            var data = new google.visualization.DataTable();
            data.addColumn('string', 'Used Car Search');
            data.addColumn('number', 'Click Count');
            data.addRows([                      
                ['Hatchback', <?php echo $hatchback ?>],
                ['Estate', <?php echo $estate ?>],
                ['Suv', <?php echo $suv ?>],
                ['4x4', <?php echo $fourxfour ?>],
                ['Mpv', <?php echo $mpv ?>],
                ['Saloon', <?php echo $saloon ?>],
                ['Sport', <?php echo $sport ?>],
                ['Convertible', <?php echo $convertible ?>],
                ['Coupes', <?php echo $coupes ?>],
                ['Pickup', <?php echo $pickup ?>],
                ['Crewvan', <?php echo $crewvan ?>],
                ['Doublecab', <?php echo $doublecab ?>],
                ['Minibus', <?php echo $minibus ?>],
                ['Tipper', <?php echo $tipper ?>],
                ['Dropside', <?php echo $dropside ?>],
                ['Luton', <?php echo $luton ?>],
                ['Chassis', <?php echo $chassis ?>],
                ['Box', <?php echo $box ?>],
                ['Curtainslider', <?php echo $curtainslider ?>],
                ['Platformcab', <?php echo $platformcab ?>],
                ['Refridgerated', <?php echo $refridgerated ?>],
                ['Freezer', <?php echo $freezer ?>],                
            ]);

            var options = {
                title: 'My Daily Activities',
            };

            options.chartArea = {left: 0, 'width': '90%', 'height': '90%'}

            var chart = new google.visualization.PieChart(document.getElementById('pieChartBody'));

            chart.draw(data, options);
        }
    </script>

    <!-- Options Interest Pie -->
    <script>       
        google.charts.load('current', {'packages': ['corechart']});
        google.charts.setOnLoadCallback(drawChartOptInt);
        function drawChartOptInt() {

            var data = new google.visualization.DataTable();
            data.addColumn('string', 'Used Car Search');
            data.addColumn('number', 'Click Count');
            data.addRows([                      
                ['Air Conditioning', <?php echo $airconditioning ?>],
                ['Bluetooth', <?php echo $bluetooth ?>],                
                ['Sat Nav', <?php echo $satnav ?>],
                ['Cruise Control', <?php echo $cruisecontrol ?>],
                ['Parking Sensors', <?php echo $parkingsensors ?>],
                ['Heated Windscreen', <?php echo $heatedwindscreen ?>],
                ['Cd Player', <?php echo $cdplayer ?>],
                ['Dab Radio', <?php echo $dabradio ?>],
                ['Aux Input', <?php echo $auxinput ?>],
                ['Park Assist', <?php echo $parkassist ?>],
                ['Phone Nav', <?php echo $phonenav ?>],
                ['Heated Seats', <?php echo $heatedseats ?>],
                ['Parking Camera', <?php echo $parkingcamera ?>],
                ['Leather Interior', <?php echo $leatherinterior ?>],
                ['Keyles Sentry', <?php echo $keylessentry ?>],
                ['Dvd Player', <?php echo $dvdplayer ?>],
                ['Metallic Paint', <?php echo $metallicpaint ?>],
                ['Mp3 Player', <?php echo $mp3player ?>],
                ['Spoiler', <?php echo $spoiler ?>]
            ]);

            var options = {
                title: 'My Daily Activities',
            };

            options.chartArea = {left: 0, 'width': '90%', 'height': '90%'}

            var chart = new google.visualization.PieChart(document.getElementById('pieChartOptIn'));

            chart.draw(data, options);
        }
    </script>

    <!-- Image Interest Pie -->
    <script>       
        google.charts.load('current', {'packages': ['corechart']});
        google.charts.setOnLoadCallback(drawChartImgInt);
        function drawChartImgInt() {

            var data = new google.visualization.DataTable();
            data.addColumn('string', 'Used Car Search');
            data.addColumn('number', 'Click Count');
            data.addRows([                      
                ['Interior', <?php echo $interiorinterests ?>],
                ['Exterior', <?php echo $exteriorinterests ?>],
                ['Features', <?php echo $featuresinterests ?>],
                ['All', <?php echo $allinterests ?>],
                ['Images Only', <?php echo $imagesonlyinterests ?>]
            ]);

            var options = {
                title: 'My Daily Activities',
            };

            options.chartArea = {left: 0, 'width': '90%', 'height': '90%'}

            var chart = new google.visualization.PieChart(document.getElementById('pieChartImgInt'));

            chart.draw(data, options);
        }
    </script>
@stop

最佳答案

$records = UsedCarsAnalytics::selectRaw('COUNT(id) as count, type')->groupBy('type')->get();

您将获得每种类型的带有 count 的对象。

foreach($records as $record){
    echo $record->type." - ".$record->count."<br>";
}
/* You will get someting like:
search-model-dropdown - 62
search-manufacturer-dropdown - 113
.
.
.
*/

然后你可以创建变量......你需要什么。重要的是，您将只有一个 SQL 选择，但它应该会加快速度。

关于php - SQL/Laravel 构建查询，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/43541342/

文章推荐： php - 如何将我的查询更改为 laravel eloquent ORM？

文章推荐： javascript - 将场景渲染为纹理 Three.js

文章推荐： ios - 其他 View 上的 UILabel 换行符

文章推荐： javascript - 链接对象时如何使用相同的方法？

php - 输出 PHP 分隔符 ()，PHP 不解释分隔符
我在 JavaScript 文件中运行 PHP，例如...... var = '';). 我需要使用 JavaScript 来扫描字符串中的 PHP 定界符(打开和关闭 PHP 的 )。我已经知道使
php - PHP 是否具有确定与给定 PHP 脚本兼容的最旧 PHP 版本的内置方法？还是会永远？
我希望能够做这样的事情: php --determine-oldest-supported-php-version test.php 并得到这个输出: 7.2 也就是说，php 二进制检查 test.
php - 在没有 php 框架的情况下将 php 框架用于现有的 php 应用程序是个好主意吗？
我正在开发一个目前不使用任何框架的大型 php 站点。我的大问题是，随着时间的推移慢慢尝试将框架融入应用程序是否可取，例如在创建的新部件和更新的旧部件中？比如所有的页面都是直接通过url服务的，有几
php - 如何在同一 php 页面上的其他 php 脚本中使用 php 变量
下面是我的源代码，我想在同一页面顶部的另一个 php 脚本中使用位于底部 php 脚本的变量 $r1。我需要一个简单的解决方案来解决这个问题。我想在代码中存在的更新查询中使用该变量。 $name)
php - PHP 重定向后 PHP 是否继续执行？
我正在制作一个网站，根据不同的情况进行大量 PHP 重定向。就像这样...... header("Location: somesite.com/redirectedpage.php"); 为了安全起见
php - 如何避免在 php 文件中写入
我有一个旧网站，我的 php 标签从因为短标签已经显示出安全问题，并且在未来的版本中将不被支持。关于php - 如何避免在 php 文件中写入

php - 需要建议通过 php 编辑 php
我有一个用 PHP 编写的配置文件，如下所示，所以我想用PHP开发一个接口(interface)，它可以编辑文件值，如$WEBPATH , $ACCOUNTPATH和 const值(value)观
php - 无法发布 “PHP file” PHP
我试图制作一个登录页面来学习基本的PHP，首先我希望我的独立PHP文件存储HTML文件的输入(带有表单)，但是当我按下按钮时(触发POST到PHP脚本) )我一直收到令人不愉快的错误。我已经搜索了S
php - PHP 是否有生成有效 PHP 表达式的打印函数？
我正在寻找一种让 PHP 以一种形式打印任意数组的方法，我可以将该数组作为赋值包含在我的(测试)代码中。 print_r 产生例如: Array ( [0] => qsr-part:1285 [1]
php - PHP 数组键有大小限制吗？ PHP 数组一般有哪些限制？
这个问题已经有答案了: 已关闭11 年前。 Possible Duplicate: What is the max key size for an array in PHP? 正如标题所说，我想知道
php - PHP 是否有生成有效 PHP 表达式的打印函数？
我正在寻找一种让 PHP 以一种形式打印任意数组的方法，我可以将该数组作为赋值包含在我的(测试)代码中。 print_r 产生例如: Array ( [0] => qsr-part:1285 [1]
php - 让函数在 php 刷新时执行 (PHP)
关闭。这个问题需要多问focused 。目前不接受答案。想要改进此问题吗？更新问题，使其仅关注一个问题 editing this post . 已关闭 9 年前。 Improve this ques
php - 按时间段显示菜单 PHP PHP MySQL
我在 MySQL 数据库中有一个表，其中存储餐厅在每个工作日和时段提供的菜单。表结构如下: i_type i_name i_cost i_day i_start i_
php - 将参数发送到嵌套在 PHP 页面内的动态 PHP
我有两页。 test1.php 和 test2.php。我想做的就是在 test1.php 上点击提交，并将 test2.php 显示在 div 中。这实际上工作正常，但我需要向 test2.php
php - 文本区域 -> php -> mysql -> php
我得到了这个代码。我想通过textarea更新mysql。我在textarea中回显我的MySQL，但我不知道如何更新它，我应该把所有东西都放进去吗，因为_GET模式没有给我任何东西，我也尝试_GET
php - 我如何将一个 php 的值解析为另一个 php
首先，我是 php 的新手，所以我仍在努力学习。我在 Wordpress 上创建了一个表单，我想将值插入一个表(data_test 表，我已经管理了)，然后从 data_test 表中获取所有列(id
php - php 中的安全首选项、php 函数来清理输入
我有以下函数可以清理用户或网址的输入: function SanitizeString($var) { $var=stripslashes($var); $va
php - HTML/PHP 登录重定向到 php
我有一个 html 页面，它使用 php 文件查询数据库，然后让用户登录，否则拒绝访问。我遇到的问题是它只是重定向到 php 文件的 url，并且从不对发生的事情提供反馈。这是我第一次使用 html、
php - onClick php PHP 函数然后重定向
我有一个页面充满了指向 pdf 的链接，我想跟踪哪些链接被单击。我以为我可以做如下的事情，但遇到了问题: query($sql); if($result){
php - 有没有办法从 PHP 代码加载的文件中解析 PHP？
我正在使用从外部文本文件加载 HTML/PHP 代码 $f = fopen($filename, "r"); while ($line = fgets($f, 4096)) { print $l

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

php - SQL/Laravel 构建查询