duannan3959 2016-10-17 13:52
浏览 11

如果未填充周数,则将0插入变量

For my admin page I created a graph which shows my registerd members per week for 2016 and 2015.

The Mysql query is working fine but when in a certain week no members has registerd the graph just moves one position to the left.

Mysql query

    SELECT WEEKOFYEAR( date) AS weekno, COUNT( 1 ) AS signup, 
           SUBDATE( date, INTERVAL WEEKDAY( date) DAY ) AS date_of_week
    FROM members
    WHERE YEAR( date) = '".$year."'
    GROUP BY WEEKOFYEAR( date);

What I (asume) need to do is check the array for missing weekno and if so fill the (new?) array with the missing weekno and add value 0 to signups.

foreach($oMember as $val) {
    $signups = $val[signups];
    $weekno = $val[weekno];
    if(empty($val)) { $val = '0'; }
}

This is what I tried but stil without any good working solution, also array search from Halil:

 array_search(strtolower($search), array_map('strtolower', $array));

Hope someone can help.

Best regards. Jan

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 如何在scanpy上做差异基因和通路富集?
    • ¥20 关于#硬件工程#的问题,请各位专家解答!
    • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
    • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
    • ¥30 截图中的mathematics程序转换成matlab
    • ¥15 动力学代码报错,维度不匹配
    • ¥15 Power query添加列问题
    • ¥50 Kubernetes&Fission&Eleasticsearch
    • ¥15 報錯:Person is not mapped,如何解決?
    • ¥15 c++头文件不能识别CDialog