"北部", "M" => "中部", "S" => "南部", "W" => "東部", "O" => "其他" ); $limit = ''; if (isset($_GET['filter_area']) && in_array($_GET['filter_area'],array_keys($z))){ $limit = ' and workshop_area = "'.$_GET['filter_area'].'"'; $zv = $_GET['filter_area']; } if (isset($_GET['filter_type']) && $_GET['filter_type'] !=''){ $limit .= ' and workshop_type = "'. filter_var( $_GET['filter_type'], FILTER_SANITIZE_EMAIL).'"'; $tv = $_GET['filter_type']; } if (isset($_GET['filter_ceu']) && $_GET['filter_ceu'] !=''){ $limit .= ' and workshop_ceu = '. filter_var( floatval($_GET['filter_ceu']), FILTER_SANITIZE_NUMBER_FLOAT).''; $cv = $_GET['filter_ceu']; } if (isset($_GET['filter_kw']) && $_GET['filter_kw'] !=''){ $limit .= " and workshop_title like '%". filter_var($_GET['filter_kw'], FILTER_SANITIZE_MAGIC_QUOTES) ."%'"; $kw = $_GET['filter_kw']; } $sql = new Stanoo\Sccms\ftable("workshop"); $sql->page_limit = 12; $sql->select = " * "; $sql->query_where = "where enable = 'Y' and (workshop_start is null or workshop_start < '". date("Y-m-d H:i:s")."') and (workshop_end is null or workshop_end > '". date("Y-m-d H:i:s")."') $limit "; //echo $sql->query_where; $sql->query_orderby = "ORDER BY orderby , workshop_serno desc"; $sql->orderby_method = "-1"; if (isset($_GET['page']) && is_numeric($_GET['page'])){ $page = filter_var($_GET['page'], FILTER_VALIDATE_INT); } else { $page = 1; } $data_array = $sql->data($page); $page = $sql->page; $lessons = "select * from workshop where enable = 'Y' and (workshop_start is null or workshop_start < '". date("Y-m-d H:i:s")."') and (workshop_end is null or workshop_end > '". date("Y-m-d H:i:s")."') "; $alldata = $sql->sql_exec($lessons); $zone = array(); $brand = array(); $ceus = array(); $z = array( "N" => "北部", "M" => "中部", "S" => "南部", "W" => "東部", "O" => "其他" ); $b =array( "TWI" => "TWI", "AFAA" => "AFAA", "Zumba" => "Zumba" ); foreach($alldata as $da){ $zone[$da['workshop_area']] = true; $brand[$da['workshop_type']] = true; $ceus[$da['workshop_ceu']] = true; } ?> TWI

研習課程

查看所有課程

'; ?>

pagination_section() ?>