require $KoolControlsFolder . "/KoolComboBox/koolcombobox.php";
require $KoolControlsFolder . "/KoolAjax/koolajax.php";
/*
if ($koolajax->isCallback) {
sleep(1);
}
*/
$selected_id = 'n';
if (isset($_POST["kcb_selectedValue"])) {
$selected_id = $_POST["kcb_selectedValue"];
}
$kcb = new KoolComboBox("kcb");
$kcb->scriptFolder = $KoolControlsFolder . "/KoolComboBox";
$kcb->styleFolder = "default";
$kcb->width = "185px";
$kcb->additem('年', 'n', NULL, $selected_id == 'n');
$kcb->additem('月', 'y', NULL, $selected_id == 'y');
switch ($selected_id) {
case 'n':
$format = '%X';
break;
case 'y':
$format = '%X-%c';
break;
}
$db = new DB_Connect();
$query = "select DATE_FORMAT(reg_date,'" . $format . "') date,count(*) from student group by (date)";
if ($stmt = $db->prepare($query)) {
$stmt->execute();
$date = $stmt->fetchAll(PDO::FETCH_NUM | PDO::FETCH_COLUMN, 0);
$stmt->execute();
