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;
//end sql make
}
}
//start get page
$list = 1;
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."
";
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 gr"){ $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";
}
$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 | '.$url.' |
ご指定の検索条件に該当するものはありませんでした。
'; } // 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 = $_SESSION['word']; ?>