How to insert the php array into another array using a loop?

Question

<?php
 include_once("connect.php");
$query = "
select date, sum(amount) as total
from expenses
where date <= NOW()
and date >= Date_add(Now(),interval - 7 day)
group by date;";
    $dateArray = Array();
    $result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
  // output data of each row
  while($row = mysqli_fetch_assoc($result)) {
    echo $row["total"];
    echo $row["date"];
      array_push($dateArray,$row);
  }}

echo $dateArray[0]["total"];
$dataPoints = array(
    array("y" => 25, "label" => "Sunday"),
    array("y" => 15, "label" => "Monday"),
    array("y" => 25, "label" => "Tuesday"),
    array("y" => 5, "label" => "Wednesday"),
    array("y" => 10, "label" => "Thursday"),
    array("y" => 0, "label" => "Friday"),
    array("y" => 20, "label" => "Saturday")
);
 
?>

I tried to run it like this and got an error, so not sure if I can set each of the array elements "y" as one of the amounts and "label" as a unique date like this

$dataPoints = array(

foreach($dateArray as $item) {
 array("y" => $dateArray("amount"), "label" => $dateArray("date"))
}
)

This question was asked before today.

mardubbles
– mardubbles

2022-05-23 00:08:58 +00:00
Commented May 23, 2022 at 0:08 — mardubbles
– mardubbles, Commented May 23, 2022 at 0:08

AlphaCoX · Accepted Answer · 2022-05-23 00:12:03Z

1

Try it as following:

$dataPoints = array();
foreach($dateArray as $item) {
    array_push($dataPoint, array("y" => $dateArray("amount"), "label" => $dateArray("date")));
}

answered May 23, 2022 at 0:12

AlphaCoX

3772 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert the php array into another array using a loop?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related