How to group by name of key name in object and sum its value in php
I have some data in mongoDB and i want to group and sum it in object key - value: { '_id': '1', 'value': { A: 1, B: 2, C: 3 } }, { '_id': '2', 'value': { B: 2, C:…
Sort array values by their existence in a blacklist array, then alphabetically – PHP
I have the following code: $check = array('person a','person c'); $data = array('person c','person a','person d','person e'); define('check',$check); //asort($data); print'<pre>';print_r($data);print'</pre>'; usort($data,function($a,$b){ return empty(check[$a]) ? 1 : $a <=> $b; }); print'<pre>';print_r($data);print'</pre>'; exit; What I am trying to achieve is: person…
PostgreSQL -How to use jsonb_array_length in where clause
We have a PostgreSQL table with jsonb column. Some of the nodes in the json can come in as array or object in the input. I am trying to write a query that will give me the array length, if…
separate an array into multiple arrays with a separator kay value pair php
$test = [ 0 => [ 'type' => 'separator', 'data' => 'separator1' ], 1 => [ 'type' => 'image', 'data' => 'image1url' ], 3 => [ 'type' => 'separator', 'data' => 'separator2' ], 4 => [ 'type' => 'video', 'data'…
Get n number of random values from an array and prevent consecutively repeated values – PHP
I want to populate a result array containing values randomly drawn from an input array, but the result array must not have two identical consecutive values. Additional rules: The input array of values will contain only unique values and will…
Split ascending integers when non-consecutive and assign sequences to values in another array – PHP
I have 2 flat arrays which are Leaders and Members. These arrays are populated while incrementing ids. I would like to associate one leader id with a sequence of consecutive ids in the members array. If there are too many…
Xcode – How to calculate number of rows of 2D char array inside a function which takes such an input?
Here is the function: void printArray(const char arr[][3], int rows, int cols) { // rows == 3 && cols == 3 is currently a placeholder. I have to confirm whether these are // actually correct. if (rows == 3 &&…
mongodb will keep creating a new cart instead of using the previously created cart How do I fix this?
I am trying to add a product to a shopping cart in mongodb but the code I have written does not work. It was previously working but when I switched from local mongodb to mongodb atlas cloud and then back…
Send timestamp array parameter to PostgreSQL function
i have developed a pgplsql function to receive array of dates the return the maximum date, but its not able to call the function: select 1, arcfm.array_max_date('{2022-02-03, 2022-06-05}'::timestamp[]) as max_date_time; CREATE OR REPLACE FUNCTION arcfm.array_max_date(in dates_array timestamp[]) RETURNS timestamp LANGUAGE…
Group and sum 1d array data by casting all keys to uppercase – PHP
I have the following code that case-insensitively groups associative elements in a flat array and sums the related values, but I don't really understand how it works. function add_array_vals($arr) { $sums = []; foreach ( $arr as $key => $val…