<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF8">
<title>ようこそ</title>
</head>
<body>
<form action="index.php" methid="get">
<select name="SC">
<option value="all" <?php if(@$_GET['SC']=='all') echo 'selected' ?> >全て</option>
<option value="青春学園中等部" <?php if(@$_GET['SC']=='青春学園中等部') echo 'selected' ?>>青春学園中等部</option>
<option value="不動峰中学校" <?php if(@$_GET['SC']=='不動峰中学校') echo 'selected' ?>>不動峰中学校</option>
<option value="氷帝学園中等部" <?php if(@$_GET['SC']=='氷帝学園中等部') echo 'selected' ?>>氷帝学園中等部</option>
<option value="立海大付属中学校" <?php if(@$_GET['SC']=='立海大付属中学校') echo 'selected' ?>>立海大付属中学校</option>
<option value="四天宝寺中学校" <?php if(@$_GET['SC']=='四天宝寺中学校') echo 'selected' ?>>四天宝寺中学校</option>
<option value="比嘉中学校" <?php if(@$_GET['SC']=='比嘉中学校') echo 'selected' ?>>比嘉中学校</option>
</select>
<select name="GK">
<option value="all" <?php if(@$_GET['GK']=='all') echo 'selected' ?>>全て</option>
<option value="1年" <?php if(@$_GET['GK']=='1年') echo 'selected' ?>>1年</option>
<option value="2年" <?php if(@$_GET['GK']=='2年') echo 'selected' ?>>2年</option>
<option value="3年" <?php if(@$_GET['GK']=='3年') echo 'selected' ?>>3年</option>
</select>
<input type="submit" />
</form>
<?php
try {
$pdo = new PDO("mysql:host=localhost; dbname=test",
"yukitora", "5106");
$stmt = $pdo->query("SET NAMES utf8;");
$sql = 'SELECT * FROM tennis ' ;
$where = array() ;
$asc = array() ;
$desc = array() ;
if(@$_GET['SC']!=""&&@$_GET['SC']!="all") {
$where[] .= '学校名="'.$_GET['SC'].'"' ;
}
if(@$_GET['GK']!=""&&@$_GET['GK']!="all") {
$where[] .= '学年立場 like "%'.$_GET['GK'].'%"' ;
}
if(@$_GET['ASC']!="") {
$asc[] .= $_GET['ASC'] ;
}
if(@$_GET['DESC']!="") {
$desc[] .= $_GET['DESC'].' DESC' ;
}
// var_dump($where) ;
if(count($where)>0) {
$sql .= 'WHERE '.implode(" AND ", $where) ;
}
if(count($asc)+count($desc)>0) {
$sql .= 'ORDER BY '.implode(",", $desc).implode(",", $asc) ;
}
echo $sql ;
$stmt = $pdo->query($sql);
echo '<table border=1>' ;
$row = $stmt->fetch(PDO::FETCH_ASSOC) ;
if($row != null) {
echo '<tr>' ;
foreach($row as $key=>$value) {
if($key=='身長') {
$desc = "index.php?DESC=身長" ;
$asc = "index.php?ASC=身長" ;
if(@$_GET['SC']!="") {$desc.="&SC=".$_GET['SC'] ;$asc.="&SC=".$_GET['SC'] ; }
if(@$_GET['GK']!="") {$desc.="&GK=".$_GET['GK'] ;$asc.="&GK=".$_GET['GK'] ; }
echo '<td>'.$key.'<a href="'.$desc.'">▲</a> <a href="'.$asc.'">▼</a></td>' ;
} else {
echo '<td>'.$key.'</td>' ;
}
}
echo '</tr>' ;
echo '<tr>' ;
foreach($row as $key=>$value) {
echo '<td>'.$value.'</td>' ;
}
echo '</tr>' ;
}
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
echo '<tr><td>' ;
echo implode("</td><td>", $row) . PHP_EOL;
echo '</td></tr>' ;
}
echo '</table>' ;
} catch (PDOException $e){
var_dump($e->getMessage());
}
$pdo = null;
?>
</body>
</html>
最終更新:2011年07月10日 16:08