PHP - Converting Array From Other Software Format Into Php Array.

Is their a way to format lr.submit_time in every record that is returned in the $results array without doing like a for/foreach loop? Like array_walk() or something similar?

$query = "
				SELECT
					lr.*,
					l.make,
					l.model,
					l.part_number,
					l.description,
					pd.job_number,
					pd.line_item,
					pd.enterprise,
					pd.description,
					pd.qty AS order_qty,
					log.name AS user_full_name
				FROM
					leds_requests lr
				LEFT JOIN
					leds l
				ON
					l.id = lr.product_id
				LEFT JOIN
					production_data pd
				ON
					pd.id = lr.order_id
				LEFT JOIN
					login log
				ON
					log.user_id = lr.user_id
				WHERE
					lr.id IN(
					SELECT
						MAX(id)
					FROM
						leds_requests
					WHERE
						status_id = 0
					GROUP BY
						order_id,
						product_id
				) AND lr.id NOT IN(
					SELECT
						id
					FROM
						leds_requests
					WHERE
						lr.id = id AND status_id IN(1, 2, 3, 4)
				)
				GROUP BY
					order_id,
					product_id,
					job_number
	";
	$statement = $pdo->prepare($query);
	$statement->execute();
	$results = $statement->fetchAll();
	
	echo json_encode($results);

I'm currently looping on an array with this structu

    Categories{
        CategoryName
        CategoryCode
        CategoryDescription

        Products{
            product_info{
                product_code
                product_type{
                    CountNumber
                    ProductDescription
                }
            }
            prices{
            "wholesale":"250",
            "retail":"400"
            }
        }    
    }

I'm looping on the above array at each level, and I've declared an array so that I can put all my needed values into it

    $priceResult = array();

    foreach($prices->categories as $category){ 
        $categoryName = $category->category_name;
        $categoryCode = $category->category_code;
        $categoryDescription = $category->category_desc;

        foreach($category->products as $product){

            foreach($product->product_info as $info){
                $product_code = $info->product_code;
                foreach($info->product_type as $type){
                    $CountNumber = $type->CountNumber;
                    $ProductDescription = $type->ProductDescription;
                }
            }
            foreach ($product->prices as $price => $amount) {
                $price_amount = $amount;
                
            }
        }
    }

The problem I'm having is I don't know how to properly push into that new ```$priceResult``` array so that I can use PHPExcel to put it into a format with a subheader.

The format I would want from the above example would be something like this

        Test Category 1  |  123  |   Category for Testing
        ==================================================
        PRD123 |  12  |  Product for Testing  |  150.00
        PRD112 |  17  |  Product for Testing  |  250.00

        Test Category 2  |  321  |   New Category for Testing
        =====================================================
        PRD189 |  16  |  Product for Testing  |  450.00
        PRD139 |  34  |  Product for Testing  |  350.00

So basically I want to call PHPExcel on my $priceResult array in order to get that format where I can list my category info, and for each product within that category, I'd have a product row. Everything would be grouped by the category main header

        $build = Excel::create($name, function ($excel) use ($priceResult) {

        $excel->setTitle('Test Products');

UPDATE:

SO I'm thinking my desired resulting array would be something like:

    CategoryCode : 123
    CategoryName : TestCategory
    CategoryDescription: For Testing
        Products{
            0{
                Product_code : 123,
                CountNumber : 12,
                ProductDescription: Test Product,
                price_amount : 150.00
            },
            1{
                Product_code : 112,
                CountNumber : 32,
                ProductDescription: Test Product 2,
                price_amount : 250.00
            }
        }

    
That way each category can be a header and all of its products can be rows for each category

NOTE - Please read the information first as it contains important information to understand the problem.

Rules →

• There are 9 Columns(C1,C2,C3,C4,C5,C6,C7,C8,C9) [ Max columns will be 9]

• The number of Rows can vary from 3,6,9,12,15,18 (Max). In this case Number of Rows shall be 12

Number of Rows = No of Tickets (Max Allowed 6) x Rows Per Ticket (Max Allowed 3). Thus, Max Rows can be 18

• Each Row is required to have 4 Blank Spaces and 5 Filled with Numbers

• All numbers available in the Column Array have to be utilized

• This configuration of an shall create a matrix of 9 Columns & 12 Rows (3 x 4 Tickets), which is 108 MATRIX BLOCKS where only a maximum of 60 numbers can be filled out of 108 available blocksrandomly with the above conditions being met 100%.

• The numbers in column must be arranged / sorted in ASCENDING ORDER (For coding logic purpose, as soon as the number is assigned to the new MATRIX MAP use array_shift() or unset() the number so as to avoid repetition

Example - Row 1 and Column 1 shall generate a MATRIX BLOCK - R1C1

Row 3 and Column 7 shall generate a MATRIX BLOCK - R3C7

Matrix Block can also be termed as Matrix Cell for your ease (if needed)

MASTER SET OF ARRAY WITH NUMBERS

array( "C1"=> array( 1, 2, 3, 5, 6, 7, 9 ), //7 Numbers "C2"=> array( 13, 14, 15, 17, 18, 19 ), //6 Numbers "C3"=> array( 21, 22, 23, 24, 25, 26, 30 ), //7 Numbers "C4"=> array( 31, 33, 34, 36, 37, 38, 39 ), //7 Numbers "C5"=> array( 41, 42, 46, 47, 48, 49, 50 ), //7 Numbers "C6"=> array( 51, 52, 53, 54, 55, 57, 58 ), //7 Numbers "C7"=> array( 61, 62, 64, 65, 69, 70 ), //6 Numbers "C8"=> array( 71, 74, 75, 76, 77, 78 ), //6 Numbers "C9"=> array( 82, 83, 85, 87, 88, 89, 90 ) //7 Numbers );

The above array has 60 Numbers to be filled out of 108 MATRIX BLOCK / CELL which meets the condition that for a FULL BLOCK containing 4 MINI BLOCKS WITH 3 ROWS (max. allowed) EACH

I have been able to generate this without any issue meeting all the conditions of the Columns

My Allocation Matrix Array will look like

array( "R1"=> array( "C1"=> true, // Means that MATRIX BLOCK R1C1 will be NOT EMPTY "C2"=> false, // Means that MATRIX BLOCK R1C2 will be EMPTY "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> false ), "R2"=> array( "C1"=> false, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> true, "C8"=> true, "C9"=> false ), "R3"=> array( "C1"=> true, "C2"=> true, "C3"=> true, "C4"=> true, "C5"=> false, "C6"=> false, "C7"=> false, "C8"=> false, "C9"=> true ), "R4"=> array( "C1"=> true, "C2"=> true, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> false ), "R5"=> array( "C1"=> false, "C2"=> false, "C3"=> false, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> true, "C8"=> true, "C9"=> true ), "R6"=> array( "C1"=> true, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ), "R7"=> array( "C1"=> false, "C2"=> false, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> true ), "R8"=> array( "C1"=> true, "C2"=> false, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> true ), "R9"=> array( "C1"=> true, "C2"=> false, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ), "R10"=> array( "C1"=> false, "C2"=> true, "C3"=> true, "C4"=> true, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> false, "C9"=> false ), "R11"=> array( "C1"=> false, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> true, "C9"=> false ), "R12"=> array( "C1"=> true, "C2"=> false, "C3"=> true, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ) );

In the above array R stands for Row, C for Column, TRUE/FALSE (Boolean) means that if TRUE a Number can be filled in the resulting MATRIX BLOCK / CELL ( Row[Number]Column[Number] ) else if FALSE the MATRIX BLOCK / CELL shall be EMPTY

The result for the above shall be

PROBLEM : 

I am unable to understand what should possibly be the logic & loop used here for creating a MATRIX ALLOCATION MAP as shown above

I have tried while, foreach & for but unable determine the perfect combination which would meet the conditions.

(Tried all of the above with Nested Loops also)

$sql = "
SELECT 
	student, sum( test_score ) as score
FROM 
	test
INNER JOIN 
	level 
ON 
	test.level_id = level.level_id
GROUP BY 
	student"
$result = $mysqli->query($sql, MYSQLI_STORE_RESULT);
if($result)
{
      while ($row = $result->fetch_array(MYSQLI_ASSOC))
       {
	    var_dump($row);
       }
}

array (size=2)
  'John' => string 'English' (length=2)
  'Score' => string '20' (length=3)

array (size=2)
  'Mary' => string 'Math' (length=3)
  'Score' => string '35' (length=3)

array (size=2)
  'Samuel' => string 'Physics' (length=3)
  'Score' => string '5' (length=3)

So I'm trying to create an Array from a comma separated string containing array{s}. How can I take a string full of comma separated hex values such as : 

<?php
    $myStr = (
        "00ffff", "00cccc", "009999", 
        "007777", "004444", "001111", 
        "01ffff", "01cccc", "019999"
    );
?>

& turn it into 3 separated arrays like : 

<?php
    $myNewArrs = [
        Array1 ( 3 ), 
        Array2 ( 3 ), 
        Array3 ( 3 ), 
    ];
?>

which REALLY looks like : 

<?php
    $myNewArrs = [
        Array ( "00ffff", "00cccc", "009999" ), 
        Array ( "007777", "004444", "001111" ), 
        Array ( "01ffff", "01cccc", "019999" ), 
    ];
?>

?

Any assistance is most-definitely appreciated!

Thank you & have a great afternoon!