ptspzy / php_mvc

The simple MVC used PHP.

Reference

spl-autoload-register:http://php.net/manual/en/function.spl-autoload-register.php

a-most-simple-php-mvc-beginners-tutorial:A Most Simple PHP MVC Beginners Tutorial

php_mvc's Issues

Symfony 版

• echart:http://echarts.baidu.com/api.html#echarts
• select2:https://github.com/select2/select2
• bootstrap
• Symfony
• jQuery

Fix round error

$length = round(($endTime - $defaultBeginTime) / 86400);

$length = (int)(($endTime - $defaultBeginTime) / 86400) + 1;

后端返回订阅按天（按小时）统计数据

http://www.2cto.com/database/201308/236384.html

PHP 时间区间内的天数小时数

<?php 
$startdate=strtotime("2016-12-02 09:00:00");
$enddate=strtotime("2016-12-2 11:00:00");
echo ($enddate-$startdate);
echo '</br>';
$days=round(($enddate-$startdate)/3600);
echo $days;
?> 

SQL表中获取时间段里每一天的统计数据，如果表里没有这一天的记录数据就为0

How to Generate Entities from an Existing Database

php bin/console doctrine:mapping:import --force DemoBundle xml
php app/console doctrine:generate:entities DemoBundle

https://symfony.com/doc/3.0/doctrine/reverse_engineering.html

symfony sql

        $orm = $this->getDoctrine()->getManager();
        $query = $orm->createQuery(
            'SELECT
                count(p) AS num,
                from_unixtime( p.buytime , \'%Y-%m-%d\' ) AS time
            FROM
                DBBundle:JieqiArticleSale p
            WHERE
                p.articleid = :articleid
             and
                  p.buytime > :defaultBeginTime
             and
                  p.buytime < :endTime
            GROUP BY
                from_unixtime( p.buytime , \'%Y%m%d\' )
            ORDER BY
                p.buytime'
        )->setParameter('articleid', $article_id)
            ->setParameter('defaultBeginTime', $defaultBeginTime)
            ->setParameter('endTime', $endTime);

        $result_arr = $query->getArrayResult();