How to print mysql query data into php multidimensional array?

CeebLaj Thoj

I have the following format of php array:

$data = array(
  array(
 'label' => 'Sale',
 'color' => '#28d8b2',
 'data'  =>
    array(
       array('Jan', 27),
       array('Feb', 82),
       array('Mar', 56),
       array('Apr', 14),
       array('May', 28),
       array('Jun', 77),
       array('Jul', 23),
       array('Aug', 49),
       array('Sep', 81),
       array('Oct', 20),
       array('Nov', 23),
       array('Dec', 99)
    )
  )
);

And I want to put my data that query from mysql table to the sub array above as follow:

array(
       array('Jan', 27),
       array('Feb', 82),
       array('Mar', 56),
       array('Apr', 14),
       array('May', 28),
       array('Jun', 77),
       array('Jul', 23),
       array('Aug', 49),
       array('Sep', 81),
       array('Oct', 20),
       array('Nov', 23),
       array('Dec', 99)
    )

I tried to put those data that query from mysql database with the following code but still not what I want:

$get_date = dbQuery("SELECT MONTH(STR_TO_DATE(ors.order_date, '%Y-%m-%d')) AS month, SUM(ord.total_price) AS total FROM orders ors INNER JOIN order_detail ord ON (ors.order_id = ord.order_id) WHERE YEAR(STR_TO_DATE(ors.order_date, '%Y-%m-%d')) = '$year' GROUP BY month");
$count = $get_date->rowCount();
$index = 1;
$ar = array();
while($row = $get_date->fetch(PDO::FETCH_ASSOC))
    {
    $ar[$index] = $row;
    $index++;
}
print_r($ar);

So my question is I want to put my data to the existing php array as I mentioned above, even if any month not available in mysql database the script still need to give that month as 0.

e.g if any month not exist in database then put data to the array like this

array(
       array('Jan', 27),
       array('Feb', 0),
       array('Mar', 56),
       array('Apr', 14),
       array('May', 0),
       array('Jun', 77),
       array('Jul', 0),
       array('Aug', 0),
       array('Sep', 81),
       array('Oct', 0),
       array('Nov', 23),
       array('Dec', 0)
    )
P. Jensen
array_push($data[0]['data'], [$month_name, $month_value]);

Perhabs this will work. Have not tested it.

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

how to print data stored in multidimensional array and fetched from database using PHP?

分類Dev

Print multidimensional array using php , array stored in associative format

分類Dev

Inserting mysql database results into a multidimensional array in php

分類Dev

PHP extracting data from multidimensional array / JSON

分類Dev

PHP - How to get the sum of a multidimensional array?

分類Dev

how to print json array in php?

分類Dev

PHP: String to multidimensional array

分類Dev

Sort a multidimensional array in PHP

分類Dev

Php include with multidimensional array

分類Dev

How to build a multidimensional array tree from an associative array in PHP?

分類Dev

PHP How to search multidimensional array for a key from another multidimensional array remembering parent key

分類Dev

How to distribute mysql result set in an multidimensional array of 4 arrays

分類Dev

Get array element and use it in mysql query with php

分類Dev

How to print one element of an array of an object in PHP?

分類Dev

How to print json non array data

分類Dev

How to print array data following current date

分類Dev

PHP how to create a new multidimensional array with 1 or more of the keys are same?

分類Dev

How can I convert spectrogram data to a tensor (or multidimensional numpy array)?

分類Dev

How to search data in multidimensional array using range values

分類Dev

How to Display multidimensional Array?

分類Dev

PHP multidimensional array to flatten WITH KEYS

分類Dev

Looping through multidimensional php array

分類Dev

Multidimensional array JSON PHP iteration

分類Dev

How to hand over values to a double-pointer and print the values out as if it would be an multidimensional array? (C)

分類Dev

PHP / MySQL: How to query data from 2 tables linked with link table

分類Dev

php mysql select data where column array

分類Dev

How can I print multidimensional arrays in C?

分類Dev

Print data value of array

分類Dev

C# LINQ query on multidimensional array

Related 関連記事

  1. 1

    how to print data stored in multidimensional array and fetched from database using PHP?

  2. 2

    Print multidimensional array using php , array stored in associative format

  3. 3

    Inserting mysql database results into a multidimensional array in php

  4. 4

    PHP extracting data from multidimensional array / JSON

  5. 5

    PHP - How to get the sum of a multidimensional array?

  6. 6

    how to print json array in php?

  7. 7

    PHP: String to multidimensional array

  8. 8

    Sort a multidimensional array in PHP

  9. 9

    Php include with multidimensional array

  10. 10

    How to build a multidimensional array tree from an associative array in PHP?

  11. 11

    PHP How to search multidimensional array for a key from another multidimensional array remembering parent key

  12. 12

    How to distribute mysql result set in an multidimensional array of 4 arrays

  13. 13

    Get array element and use it in mysql query with php

  14. 14

    How to print one element of an array of an object in PHP?

  15. 15

    How to print json non array data

  16. 16

    How to print array data following current date

  17. 17

    PHP how to create a new multidimensional array with 1 or more of the keys are same?

  18. 18

    How can I convert spectrogram data to a tensor (or multidimensional numpy array)?

  19. 19

    How to search data in multidimensional array using range values

  20. 20

    How to Display multidimensional Array?

  21. 21

    PHP multidimensional array to flatten WITH KEYS

  22. 22

    Looping through multidimensional php array

  23. 23

    Multidimensional array JSON PHP iteration

  24. 24

    How to hand over values to a double-pointer and print the values out as if it would be an multidimensional array? (C)

  25. 25

    PHP / MySQL: How to query data from 2 tables linked with link table

  26. 26

    php mysql select data where column array

  27. 27

    How can I print multidimensional arrays in C?

  28. 28

    Print data value of array

  29. 29

    C# LINQ query on multidimensional array

ホットタグ

アーカイブ