php - 如何从数据库中获取日期并将它们存储到 php 中的数组中？

Question

我一直在为一个项目的 Leave 模块工作。我想计算不包括国定假日和周末的员工休假天数。因此，我有一个名为 attendance 的表，其中包含员工在场时存储日期的字段 AttDate。我只想知道如何将数据库日期值导入函数中预定义的数组形式的变量 datesOfWorker。

here is the function

Answer 1

以下是我建议您尝试的方法:

    <?php
        // DEFINE SOME DATABASE CONNECTION DATA... COULD BE DONE IN A SEPARATE FILE
        defined("HOST")         or define("HOST",           "localhost");
        defined("DBASE")        or define("DBASE",          "mydb");
        defined("USER")         or define("USER",           "root");        //<== YOUR USERNAME
        defined("PASS")         or define("PASS",           "root");        //<== YOUR PASSWORD

        function getDBH(){
            try {
                $dbHandle = new \PDO('mysql:host='.HOST.';dbname='. DBASE,USER,PASS);
                $dbHandle->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
                return $dbHandle;
            }catch(\PDOException $e){
                throw new \Exception($e->getMessage());
            }
        }

        $dbh        = getDBH();
        $output     = "";
        $sql        = "SELECT ATT.AttDate FROM `attendance` ATT";
        $query      = $dbh->prepare($sql);
        $query->execute();
        $results    = $query->fetchAll(\PDO::FETCH_OBJ);
        $arrDates   = array();

        foreach($results as $intKey=>$objAttDate){
            $arrDates[] = $objAttDate->AttDate;
        }

        // THE ARRAY YOU ARE LOOKING FOR IS $arrDates...

        var_dump($arrDates);