Suppose I have a table (DeliveryEvent) like this grouped by delivery_id, where event_type 2 is an event of 'scheduled', 3 is an event of 'unscheduled', and 4 is an event of 'completed': id created event_type delivery_id extra 1 2022-10-27 18:04…
I have a two dimensional array of students from different schools and countries. I want them to be grouped by name of school and country. How can I create the nested key structure? Example: $students = [ [ "country" =>…
I have an array with two items, which are also arrays themselves: product and countries. There are cases in which the countries array is the same for more than one product, like basic and pro in the example below. Given…
I've got an old script from someone that I want to remodel but unfortunately I am not that experienced in PHP. What it does is, it reads article information from a CSV file into an array and then basically posts…
I need filter out duplicate rows in my 2d array and in the retained unique rows append an element that contains the count of how many times the unique row existed in the original array. I wanted to use array_unique($array,…
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…
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…
I need to group values in my flat array so that each non-integer value starts a new group/row in my result array and every integer value encountered until the next occurring non-integer should be pushed into a subarray in the…
Currently, I have 3 different aggregate queries which generate different counts based on grouping of companyRegNo. Is there a way to combine these 3 queries. The employeeActions data looks like this: { "email": "[email protected]", "companyRegNo" : 105, "event" : {…
I have a table containing data that has a column named id that looks like below: id value 1 value 2 value 3 1 244 550 1000 1 251 551 700 1 540 60 1200 ... ... ... ... 2…