Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2014
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.50 KB | None | 0 0
  1. $base = Array(
  2. Array
  3. (
  4. "month" => '2010-01',
  5. "KFC" => '0',
  6. "PZH" => '0',
  7. "SUB" => '0'
  8. ),
  9.  
  10. Array
  11. (
  12. "month" => '2010-02',
  13. "KFC" => '0',
  14. "PZH" => '0',
  15. "SUB" => '0'
  16. ),
  17.  
  18. Array
  19. (
  20. "month" => '2010-03',
  21. "KFC" => '0',
  22. "PZH" => '0',
  23. "SUB" => '0'
  24. ),
  25.  
  26. Array
  27. (
  28. "month" => '2010-04',
  29. "KFC" => '0',
  30. "PZH" => '0',
  31. "SUB" => '0'
  32. ),
  33.  
  34. Array
  35. (
  36. "month" => '2010-05',
  37. "KFC" => '0',
  38. "PZH" => '0',
  39. "SUB" => '0'
  40. ),
  41.  
  42. Array
  43. (
  44. "month" => '2010-06',
  45. "KFC" => '0',
  46. "PZH" => '0',
  47. "SUB" => '0'
  48. ),
  49.  
  50. Array
  51. (
  52. "month" => '2010-07',
  53. "KFC" => '0',
  54. "PZH" => '0',
  55. "SUB" => '0'
  56. ),
  57.  
  58.  
  59. Array
  60. (
  61. "month" => '2010-08',
  62. "KFC" => '0',
  63. "PZH" => '0',
  64. "SUB" => '0'
  65. ),
  66.  
  67. Array
  68. (
  69. "month" => '2010-09',
  70. "KFC" => '0',
  71. "PZH" => '0',
  72. "SUB" => '0'
  73. ),
  74.  
  75.  
  76. Array
  77. (
  78. "month" => '2010-10',
  79. "KFC" => '0',
  80. "PZH" => '0',
  81. "SUB" => '0'
  82. ),
  83.  
  84. Array
  85. (
  86. "month" => '2010-11',
  87. "KFC" => '0',
  88. "PZH" => '0',
  89. "SUB" => '0'
  90. ),
  91.  
  92. Array
  93. (
  94. "month" => '2010-12',
  95. "KFC" => '0',
  96. "PZH" => '0',
  97. "SUB" => '0'
  98. )
  99. );
  100.  
  101. $result = mysqli_query($con, "SELECT brand,
  102. DATE_FORMAT( date_time, '%Y' ) AS 'year',
  103. DATE_FORMAT( date_time, '%m' ) AS 'month',
  104. SUM(brand='PZH') AS PZH,
  105. SUM(brand='KFC') AS KFC,
  106. SUM(brand='SUB') AS SUB
  107. FROM scan_report WHERE DATE_FORMAT( date_time, '%Y' ) =2010 AND id = ".$_SESSION['userinfo']['id']."
  108. GROUP BY DATE_FORMAT( date_time, '%Y%m' )") or die(mysqli_error($con));
  109. $num_rows = 1;
  110.  
  111. while ($row = mysqli_fetch_array($result)) {
  112. foreach($base as &$value) {
  113.  
  114. echo $num_rows;
  115. if ($value['month'] == $row['year'].'-'.$row['month']){
  116. $value['KFC'] = $row['KFC'];
  117. $value['PZH'] = $row['PZH'];
  118. $value['SUB'] = $row['SUB'];
  119.  
  120. }
  121.  
  122. }
  123. $num_rows++;
  124. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement