";
if($_SERVER['REQUEST_METHOD'] == "POST"){
if(isset($_POST['go'])){
//start sql make
// $sql = "SELECT * FROM ob";
$word = post_text($_POST['word']);
$_SESSION['word'] = $word;
$word = sql_escape($word);
$ken = $_POST['ken'];
$_SESSION['ken'] = $ken;
$sort = $_POST['sort'];
$_SESSION['sort'] = $sort;
$view = $_POST['view'];
$_SESSION['view'] = $view;
if(strlen($word) > 0 || strlen($ken) > 0){
$sql .= " WHERE";
}
if(strlen($ken) > 0){
$sql .= " ken='$ken'";
}
if(strlen($ken) > 0 && strlen($word) > 0){ $sql .= " AND"; }
if(strlen($word) > 0){
$sql .= " gr REGEXP '$word' || name REGEXP '$word' || year REGEXP '$word' || tel REGEXP '$word' || mail REGEXP '$word' || ken REGEXP '$word' || addr REGEXP '$word' || cont REGEXP '$word' || url REGEXP '$word' || post REGEXP '$word' || kana REGEXP '$word'";
}
if(strlen($sort) > 0){
switch($sort){
case "1": $by = " ORDER BY logno ASC"; break;
case "2": $by = " ORDER BY logno DESC"; break;
case "3": $by = " ORDER BY kana ASC"; break;
case "4": $by = " ORDER BY kana DESC"; break;
// case "5": $by = " ORDER BY addr ASC"; break;
// case "6": $by = " ORDER BY addr DESC"; break;
}
}
if(strlen($view) > 0){
switch($view){
case "1": $limit = "5"; break;
case "2": $limit = "10"; break;
case "3": $limit = "20"; break;
case "4": $limit = ""; $_SESSION['limit'] = ""; break;
}
}
$_SESSION['by'] = $by;
$_SESSION['limit'] = $limit;
if(strlen($by) > 0){ $sql .= $by; }
$_SESSION['sql'] = $sql;
//echo $_SESSION['sql']."
";
//end sql make
}
}
// echo $_SESSION['sql'];
//exit;
//start get page
// $_SESSION['sql'] = $sql;
$list = 1;
// echo $_SESSION['sql']."
";
if($_SERVER['REQUEST_METHOD'] == "GET"){
if(isset($_GET['list'])){
$list = $_GET['list'];
$sql = $_SESSION['sql'];
$limit = $_SESSION['limit'];
$ken = $_SESSION['ken'];
$sort = $_SESSION['sort'];
$view = $_SESSION['view'];
$word = $_SESSION['word'];
}
}
// echo $limit."
";
// echo $sql."
";
// echo $by."
";
// echo $limit;
if(strlen($limit) > 0){
$mysql -> query($sql);
$all = $mysql -> rows();
$max = @intval($all/$limit);
if($all % $limit > 0){ $max++; }
$start = ($list-1)*$limit;
}
// echo $all."
";
$back = $list-1;
$next = $list+1;
if($back <= 1){ $back = 1; }
if(isset($max) && $next >= $max){ $next = $max; }
if(isset($max) && $max > 1){
$x = 0;
$page_link = '';
for($i = 1;$i <= $max;$i++){
if($list == $i){
$link_tag = $i;
}else{
$link_tag = ''.$i.'';
}
if($x == 0){
$page_link .= $link_tag;
}else{
$page_link .= $link_tag;
}
$x++;
}
$page_link .= '';
}
$count_start = $start+1;
$count_end = $start+10;
//end get page
//start get result
if(strlen($limit) > 0){ $sql .= " LIMIT $start,$limit"; }
if($sql == "SELECT * FROM ob"){ $sql .= " ORDER BY logno ASC"; }
$mysql -> query($sql);
if($mysql -> rows() > 0){
$c = 0;
while($row = $mysql -> fetch()){
if($c == 0){
$style = "space_6";
}else{
$style = "space_18";
}
// echo $style."
";
$post = $row['post'];
$gr = $row['gr'];
$name = $row['name'];
$year = $row['year'];
$pref = $row['ken'];
$addr = $pref.$row['addr'];
if(strlen($post) > 0){
$addr = "〒".$post." ".$addr;
}
$cont = nl2br($row['cont']);
$tel = $row['tel'];
$mail = $row['mail'];
$url = strlen($row['url']) > 0 ? ''.$row['url']."":'';
/*$result .= <<
| 企業・団体名 |
$gr |
| ＯＢ名・役職 |
$name |
卒業年
|
$year |
| 事業概要 |
$cont |
| 住所 |
$addr |
| 電話番号 |
$tel |
| メールアドレス |
$mail |
| ＵＲＬ |
$url |
EOT;*/
$result .= '
| 企業・団体名 |
'.$gr.' |
| ＯＢ名・役職 |
'.$name.' |
卒業年
|
'.$year.' |
| 事業概要 |
'.$cont.' |
| 住所 |
'.$addr.' |
| 電話番号 |
'.$tel.' |
| メールアドレス |
'.$mail.' |
| ＵＲＬ |
'.$url.' |
';
$c++;
}
}elseif($mysql -> rows() == 0){
$result = 'ご指定の検索条件に該当するものはありませんでした。
';
}
//echo $sql;
// end get result
$sort_array = array("1"=>"登録順","2"=>"新着順","3"=>"企業名あいうえお順(昇順)","4"=>"企業名あいうえお順(降順)");
$sort_op = "";
$view_array = array("1"=>"5件ずつ","2"=>"10件ずつ","3"=>"20件ずつ","4"=>"全て表示");
$view_op = "";
$word = isset($_SESSION['word']) ? $_SESSION['word']:'';
?>
OBタウンページ --- 同志社ラグビー部 公式ホームページ
