php 可变变量实例

最新推荐文章于 2021-03-31 20:54:30 发布

「已注销」

最新推荐文章于 2021-03-31 20:54:30 发布

阅读量449

点赞数

分类专栏：笔记文章标签： php 可变变量实例

本文链接：https://blog.csdn.net/ghostyusheng/article/details/52227966

版权

笔记专栏收录该内容

169 篇文章 2 订阅

订阅专栏

public function getValidCouponNum($website=''){
        $db = M('');
        $countDay = array();
        $decrese = 86400;
        for($i=0;$i<=7;$i++){
            $n = 'sql';
            $n .= $i;
            $allDecrese = $decrese * $i; //可变变量赋值sql0-sql7
            $$n = "select count(*) from
                    (
                    select * from app_coupon_api where website = '{$website}' and status = 'public' and UNIX_TIMESTAMP(STR_TO_DATE(left(end_date,10), '%m/%d/%Y')) > UNIX_TIMESTAMP(now()-$allDecrese)
                    union
                    select * from app_coupon_api where website = '{$website}' and status = 'public' and UNIX_TIMESTAMP(STR_TO_DATE(left(end_date,10), '%m/%d/%Y')) = 0
                    union
                    select * from app_coupon_api where website = '{$website}' and status = 'public' and end_date is null
                    )t
                    ";
        }
        // echo $sql7;
        for($i=0;$i<=7;$i++){
            $n = 'sql'.$i;
            $countDay[] = $db->query($$n);
        }
    }