我一直在研究项目上的请假模块。我想计算员工的休假天数(不包括国定假日和周末)。因此,我有一个名为Attendance的表,具有字段AttDate,当员工在场时,日期已存储在该表中。我只想知道如何将数据库日期值以函数形式预定义的数组形式导入变量dateOfWorker。
以下是我建议您尝试的方法:
<?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);
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句