Take a look at this loop My table, id date income expense 1 2022-05-01 00:00:00 20 10 2 2022-06-01 00:00:00 40 30 3 2022-07-01 00:00:00 60 50 In desire one, I want to push custom key and value with specific columns from an associative array ($row) like this, In also desire two, Final output is like below, I w…
Tag: associative-array
In PHP, for a specific key in an associative array, find identical keys and combine values into a single string variable
I have found many references for similar questions on SO but nothing close to what I’m trying to do. I have this array output: I would like to now use ‘kp_uid’ to locate all common values and then combine the ‘full_name’ values for each key into a string (with comma separation). …
PHP OO – Associative array of object instances, resetting on each click
My first ever question on here as I’m completely stuck, so apologies if I leave out any key information – please let me know! I am creating a PHP Battleships game and trying to use full OO. I’m really close, however, an array for one of my classes does not hold any updates I make to it. Firs…
Sorting an associative array with a string in PHP
I’m working on a php issue with an associative array and attempting to sort it. What I have looks something like this: I want to sort it so it looks like this: I’ve thought about exploding along the | and then taking the 0.0.0.111 and comparing it to everything else. What I tried look like this: I…
Get the first element of my array $_POST[‘tableFields’]
I’m trying to get the first element of my asociative array $_POST[‘tableFields’]. I tryied using reset() method but doesn’t show anything. Answer It is JSON format so its a string value. You must do print_r(json_decode($_POST[‘tableFields’],1)[0]); or reset(json_decode($_PO…
how to create associative array from NOAA data
I’m trying to convert this to an associative array with json_decode but I’m messing up somewhere. $noaaRaw looks like: How do I convert that to an associative array? Answer file returns an array of lines. You want to use file_get_contents to get a string to decode: It is also possible after that, …
Join two associative arrays in PHP
I have two associative arrays, one is called $events and one is called $wikipedia. I want an efficient way to join “extract” and “thumbnail” from $wikipedia to $events where “name” in $events matches “title” in $wikipedia. Original $events $wikipedia Modified $e…
Compare array values and selecting specific one
I need a bit of help with the below concept. I have an array: I would like to loop through it and select the “first IN” and “last OUT” based on “dateTime”. So I should be getting: How is it possible to achieve this? Appreciate any help. Thanks, Answer The way I would approa…
Group rows of data by a column value and restructure into an associative multi-dimensionsl array
I am trying to change an indexed array of arrays into a new array structure. My data is as follows: I would like to recreate a new array thats groups them into the same year. The best I can come up with is designating the year as the key so any row that has that year gets added to that
Can I call a stored procedure on each iteration of an array? PHP
I want to loop through an associative array that represents a table’s columns and values, and call a stored procedure on each iteration that will insert each value into its respective column. The assoc. array and loop looks like this: The stored procedure looks like this: Is this possible to do? Or is t…