Obtain the count of a two-value array from a Laravel controller and pass it to JavaScript

Question

Obtain the count of a two-value array from a Laravel controller and pass it to JavaScript

I need help with a query that calculates the count based on conditions for genders "male" and "female".

$users[] =  User::whereIn('gender',array('male', 'female'))->count()->get();
    return view('/',compact('users[]'));

The counts are then displayed in a bar chart.

function drawStacked() {
        var genders[] = {{ $users[] }}
        var data = google.visualization.arrayToDataTable([
            ['Element', '', { role: 'style' }, { role: 'annotation' } ],
            ['Male', '#000', genders[0]],
            ['Female', '#000', genders[1]],
        ]);
    }

However, only the count of gender male is being shown.

javascript json laravel charts highcharts

Answer 1

Answer №1

To achieve the desired outcome, it is necessary to run two separate queries:

$malePopulation = User::where('gender', 'male')->count();
$femalePopulation = User::where('gender', 'female')->count();
return view('/', compact('malePopulation', 'femalePopulation'));

Answer 2

To achieve the desired outcome, it is necessary to run two separate queries:

$malePopulation = User::where('gender', 'male')->count();
$femalePopulation = User::where('gender', 'female')->count();
return view('/', compact('malePopulation', 'femalePopulation'));

Answer 3

Answer №2

The solution provided by Alexey Mezenin is effective, but I prefer to consolidate it into a single location and return an array that can be displayed in JavaScript. For instance:

genders[0] for male and genders[1] for female

Answer 4

The solution provided by Alexey Mezenin is effective, but I prefer to consolidate it into a single location and return an array that can be displayed in JavaScript. For instance:

genders[0] for male and genders[1] for female

Answer 5

Answer №3

To store Alexey's solution in an array, simply follow these steps:

$totals = [
    'men' => User::where('gender', 'male')->count(),
    'women' => User::where('gender', 'female')->count()
];

return view('/', compact('totals'));

Once stored, you can retrieve the values in your view using the following code:

$totals['men']
// or
$totals['women']

Answer 6

To store Alexey's solution in an array, simply follow these steps:

$totals = [
    'men' => User::where('gender', 'male')->count(),
    'women' => User::where('gender', 'female')->count()
];

return view('/', compact('totals'));

Once stored, you can retrieve the values in your view using the following code:

$totals['men']
// or
$totals['women']

Obtain the count of a two-value array from a Laravel controller and pass it to JavaScript

Answer №1

Answer №2

Answer №3

Similar questions

Utilizing Jquery's .GET method to retrieve and handle JSON data

When I tried using $.Post with Json in ASP.NET MVC 1.0, I encountered an error indicating that the maximum length had

Error: The property 'match' is undefined and cannot be read by Object.j during rendering in angular-datatables.min.js at line 6

Revive the JavaScript library for handling mouse wheel events

How can you begin using version 4.4.0 of nuxtjs/axios in nuxt.js?

Avoiding metacharacters and utilizing them as a string variable for selection

Error: Unforeseen JSON reply from node

The global class variable encounters an error when trying to assign the value of "socket" to it

Is it possible to count the number of days in between and then apply a specific class to each of those days

Shader in THREE.js only appears when the window is resized

Using Alamofire to retrieve data from a JSON API

Issue with rendering Backbone subview correctly

Exploring Ruby on Rails: JSON representation of validation error codes

Cursor starts to move to the front of the input line after every single letter with a 1 millisecond delay while browsing certain websites, such as the comments section on Youtube

Having trouble incorporating autocomplete search results into an HTML table using Jquery, Ajax, and JSP

Methods to Maintain Consistent HTML Table Dimensions utilizing DOM

Converting data into a hierarchical structure for a JSON file

Create HTML content dynamically with JavaScript and then utilize AngularJS to interpret and render it

Create a time of 00:19:59 using JavaScript

How to Override package.json Scripts in NPM