include("dbconnect.php");
if($_REQUEST["vid"] and $_REQUEST["vn"]){
$result = mysql_query("select * from tbl_vender where system_id = '".$system_id."' and vender_id = '".(int)$_REQUEST["vid"]."'");
if($rows = mysql_num_rows($result)){
$arr_vender = mysql_fetch_array($result);
}
$pagetitle = $arr_vender["vender_name"]."の携帯サイト";
$img = "/i/img/".keta_awase($arr_vender["vender_id"],4)."line.gif";
$cr = "(C)".$arr_vender["vender_name"];
$navi1 = "<<トップページへ";
if(file_exists($_REQUEST["vid"].".conf")){
$arr = array();
include($_REQUEST["vid"].".conf");
}
$dt = "vt_bukken_s1_lm";
$item[1] = "信州大学松本キャンパス";
$item[3] = "vt_bukken_s1_lm";
}else{
$pagetitle = "信州大学特集 アパート携帯サイト";
$img = "/i/img/top.gif";
$cr = "(C)株式会社JOHO/(株)不動産情報社";
$navi1 = "<<fudousan.co.jpトップへ";
$dt = "vt_bukken_s1_lm";
$item[1] = "信州大学松本キャンパス";
$item[3] = "vt_bukken_s1_lm";
}
?>
Notice: Undefined variable: pagetitle in /var/www/html/i/sdai on line 32
include("koukai.php"); ?>
//条件
$sql = "";
if($item[1]){
$sql .= " landmark = '".$item[1]."'";
}
if($_REQUEST["jiscode"]){
$sql = " jiscode = '".$_REQUEST["jiscode"]."'";
}
if(substr($_REQUEST["k"],0,1) == "a"){
$kubun = str_replace(substr($_REQUEST["k"],0,1),"",$_REQUEST["k"]);
if($kubun){
if($sql){
$sql .= " and";
}
$sql .= " kubun3 = '".$kubun."'";
}
}else{
$kubun = str_replace(substr($_REQUEST["k"],0,1),"",$_REQUEST["k"]);
if($kubun){
if($sql){
$sql .= " and";
}
$sql .= " kubun2 = '".$kubun."'";
}
}
if($_REQUEST["address1"]){
$_REQUEST["address1"] = $_REQUEST["address1"];
//全角スペースのを半角スペースへ
$_REQUEST["address1"] = str_replace(" "," ",$_REQUEST["address1"]);
// 文字列の前後の空白文字を取り除く
$_REQUEST["address1"] = trim($_REQUEST["address1"]);
// 二つ以上連続する空白文字を一つにする。
$_REQUEST["address1"] = ereg_replace("[[:blank:]]+"," ",$_REQUEST["address1"]);
}
//検索
$sql1 = "";
if($_REQUEST["address1"]){
//キーワードを分解
$keyword = explode(" ",$_REQUEST["address1"]);
$rows_keyword = count($keyword);
if($rows_keyword){
$sql1 = " and ";
for($ckey = 0;$ckey < $rows_keyword;$ckey++){
if($ckey){
$sql1 .= " and ";
}
$sql1 .= "(address1 like '%".$keyword[$ckey]."%' or address2 like '%".$keyword[$ckey]."%')";
}
}
}
if($_REQUEST["kakaku1"]){
$sql .= " and kakaku_amt >= '".$_REQUEST["kakaku1"]."'";
}
if($_REQUEST["kakaku2"]){
$sql .= " and kakaku_amt <= '".$_REQUEST["kakaku2"]."'";
}
if($_REQUEST["mdkazu"]){
$sql .= " and room_count = '".$_REQUEST["mdkazu"]."'";
}
if($_REQUEST["rmd"]){
$sql .= " and roomlayout_short = '".$_REQUEST["rmd"]."'";
}
if($_REQUEST["menseki1"]){
$sql .= " and land_m2 >= '".$_REQUEST["menseki1"]."'";
}
if($_REQUEST["menseki2"]){
$sql .= " and land_m2 <= '".$_REQUEST["menseki2"]."'";
}
if($_REQUEST["vid"]){
$sql .= " and vender_id = '".(int)$_REQUEST["vid"]."'";
}
//ソート
if(!$_REQUEST["orderby"] or $_REQUEST["orderby"] == "1"){
$sql2 = " order by kakaku_amt";
}else{
$sql2 = " order by land_m2";
}
//ページ処理
$sql3 = " limit 10";
$o_pg = $_REQUEST["pg"] * 10;
if($_REQUEST["pg"] > 0){
$sql3 .= " offset ".$o_pg;
}
if($dt){
//echo "select * from ".$dt." where".$sql."".$sql1."".$sql2."".$sql3;
$result = mysql_query("select * from ".$dt." where".$sql."".$sql1."".$sql2."".$sql3);
$rows = mysql_num_rows($result);
$result_all = mysql_query("select * from ".$dt." where".$sql."".$sql1."".$sql2);
$rows_all = mysql_num_rows($result_all);
}
?>
if(substr($_REQUEST["k"],0,1) == "a"){
include("./disp/list_a_top.php");
}
?>
$result1 = mysql_query("select * from tbl_jiscode where system_id = '".$system_id."' and pref_cd = '".substr($_REQUEST["jiscode"],0,2)."' and city_cd = '".substr($_REQUEST["jiscode"],2)."'");
if($rows1 = mysql_num_rows($result1)){
$karr_jiscode = mysql_fetch_array($result1);
echo $karr_jiscode["city_name_full"];
}
?>
echo $rows_all; ?>件 echo $_REQUEST["pg"]+1; ?>/ if(ceil($rows_all/10)){ echo ceil($rows_all/10); }else{ echo "1"; } ?>ページ
if(!$_REQUEST["pg"]){ ?>
<<前へ
}else{ ?>
if($_REQUEST["k"]){ ?>&k= echo urlencode($_REQUEST["k"]); ?> } ?> if($_REQUEST["vid"] and $_REQUEST["vn"]){ ?>&vid=
Notice: Undefined index: vid in /var/www/html/i/sdai on line 219
&vn=
Notice: Undefined index: vn in /var/www/html/i/sdai on line 219
} ?> if($_REQUEST["orderby"]){ ?>&orderby= echo urlencode($_REQUEST["orderby"]); ?> } ?> if($_REQUEST["jiscode"]){ ?>&jiscode= echo urlencode($_REQUEST["jiscode"]); ?> } ?> if($_REQUEST["address1"]){ ?>&address1= echo urlencode($_REQUEST["address1"]); ?> } ?> if($_REQUEST["kakaku1"]){ ?>&kakaku1= echo urlencode($_REQUEST["kakaku1"]); ?> } ?> if($_REQUEST["kakaku2"]){ ?>&kakaku2= echo urlencode($_REQUEST["kakaku2"]); ?> } ?> if($_REQUEST["menseki1"]){ ?>&menseki1= echo urlencode($_REQUEST["menseki1"]); ?> } ?> if($_REQUEST["menseki2"]){ ?>&menseki2= echo urlencode($_REQUEST["menseki2"]); ?> } ?> if($_REQUEST["mdkazu"]){ ?>&mdkazu= echo urlencode($_REQUEST["mdkazu"]); ?> } ?> if($_REQUEST["rmd"]){ ?>&rmd= echo urlencode($_REQUEST["rmd"]); ?> } ?>"><<前へ
} ?>
if($_REQUEST["pg"]+1 >= ($rows_all/10)){ ?>
次へ>>
}else{ ?>
if($_REQUEST["k"]){ ?>&k= echo urlencode($_REQUEST["k"]); ?> } ?> if($_REQUEST["vid"] and $_REQUEST["vn"]){ ?>&vid=
Notice: Undefined index: vid in /var/www/html/i/sdai on line 225
&vn=
Notice: Undefined index: vn in /var/www/html/i/sdai on line 225
} ?> if($_REQUEST["orderby"]){ ?>&orderby= echo urlencode($_REQUEST["orderby"]); ?> } ?> if($_REQUEST["jiscode"]){ ?>&jiscode= echo urlencode($_REQUEST["jiscode"]); ?> } ?> if($_REQUEST["address1"]){ ?>&address1= echo urlencode($_REQUEST["address1"]); ?> } ?> if($_REQUEST["kakaku1"]){ ?>&kakaku1= echo urlencode($_REQUEST["kakaku1"]); ?> } ?> if($_REQUEST["kakaku2"]){ ?>&kakaku2= echo urlencode($_REQUEST["kakaku2"]); ?> } ?> if($_REQUEST["menseki1"]){ ?>&menseki1= echo urlencode($_REQUEST["menseki1"]); ?> } ?> if($_REQUEST["menseki2"]){ ?>&menseki2= echo urlencode($_REQUEST["menseki2"]); ?> } ?> if($_REQUEST["mdkazu"]){ ?>&mdkazu= echo urlencode($_REQUEST["mdkazu"]); ?> } ?> if($_REQUEST["rmd"]){ ?>&rmd= echo urlencode($_REQUEST["rmd"]); ?> } ?>">次へ>>
} ?>
if($num_rows = mysql_num_rows($result)){
while($arr1 = mysql_fetch_array($result)){
if($arr1["address2"]){
$arr1["address2"] .= "丁目";
}
if($arr1["address23_non_flg"] != "1"){
$disp["address"] = $arr1["city_name1"]."".$arr1["city_name2"]."".$arr1["address1"]."".$arr1["address2"]."".$arr1["address3"];
}else{
$disp["address"] = $arr1["city_name1"]."".$arr1["city_name2"]."".$arr1["address1"]."".$arr1["address2"];
}
//物件名
$disp["bukken_name"] = "";
if($arr1["bukken_name_non_flg"] != "1"){
$disp["bukken_name"] = $arr1["bukken_name"]."".$arr1["room_number"];
}
if($arr1["kakaku_memo"]){
$disp["kakaku"] = $arr1["kakaku_memo"];
}else{
$disp["kakaku"] = $arr1["kakaku_amt"]."万円";
}
$disp["room"] = "";
if($arr1["room_count"] or $arr1["roomlayout_short"]){
$disp["room"] = $arr1["room_count"]."".$arr1["roomlayout_short"];
}
if($arr1["reikin_month"]){
$disp["reikin_month"] = $arr1["reikin_month"];
}else if($arr1["reikin_month"] == "0"){
$disp["reikin_month"] = $arr1["reikin_month"];
}else{
$disp["reikin_month"] = "";
}
if($arr1["shikkin_month"]){
$disp["shikkin_month"] = $arr1["shikkin_month"];
}else if($arr1["shikkin_month"] == "0"){
$disp["shikkin_month"] = $arr1["shikkin_month"];
}else{
$disp["shikkin_month"] = "";
}
$disp["kansei_yyyy"] = "";
if($arr1["kansei_yyyy"]){
$disp["kansei_yyyy"] = date("Y") - $arr1["kansei_yyyy"];
}
$disp["land_m2"] = "";
if($arr1["land_m2"]){
$disp["land_m2"] = $arr1["land_m2"];
}
$disp["land_tsubo"] = "";
if($arr1["land_tsubo"]){
$disp["land_tsubo"] = $arr1["land_tsubo"];
}
?>
include("disp/list_k.php"); ?>
}
}
?>
if(!$_REQUEST["pg"]){ ?>
<<前へ
}else{ ?>
if($_REQUEST["k"]){ ?>&k= echo urlencode($_REQUEST["k"]); ?> } ?> if($_REQUEST["vid"] and $_REQUEST["vn"]){ ?>&vid=
Notice: Undefined index: vid in /var/www/html/i/sdai on line 311
&vn=
Notice: Undefined index: vn in /var/www/html/i/sdai on line 311
} ?> if($_REQUEST["orderby"]){ ?>&orderby= echo urlencode($_REQUEST["orderby"]); ?> } ?> if($_REQUEST["jiscode"]){ ?>&jiscode= echo urlencode($_REQUEST["jiscode"]); ?> } ?> if($_REQUEST["address1"]){ ?>&address1= echo urlencode($_REQUEST["address1"]); ?> } ?> if($_REQUEST["kakaku1"]){ ?>&kakaku1= echo urlencode($_REQUEST["kakaku1"]); ?> } ?> if($_REQUEST["kakaku2"]){ ?>&kakaku2= echo urlencode($_REQUEST["kakaku2"]); ?> } ?> if($_REQUEST["menseki1"]){ ?>&menseki1= echo urlencode($_REQUEST["menseki1"]); ?> } ?> if($_REQUEST["menseki2"]){ ?>&menseki2= echo urlencode($_REQUEST["menseki2"]); ?> } ?> if($_REQUEST["mdkazu"]){ ?>&mdkazu= echo urlencode($_REQUEST["mdkazu"]); ?> } ?> if($_REQUEST["rmd"]){ ?>&rmd= echo urlencode($_REQUEST["rmd"]); ?> } ?>"><<前へ
} ?>
if($_REQUEST["pg"]+1 >= ($rows_all/10)){ ?>
次へ>>
}else{ ?>
if($_REQUEST["k"]){ ?>&k= echo urlencode($_REQUEST["k"]); ?> } ?> if($_REQUEST["vid"] and $_REQUEST["vn"]){ ?>&vid=
Notice: Undefined index: vid in /var/www/html/i/sdai on line 317
&vn=
Notice: Undefined index: vn in /var/www/html/i/sdai on line 317
} ?> if($_REQUEST["orderby"]){ ?>&orderby= echo urlencode($_REQUEST["orderby"]); ?> } ?> if($_REQUEST["jiscode"]){ ?>&jiscode= echo urlencode($_REQUEST["jiscode"]); ?> } ?> if($_REQUEST["address1"]){ ?>&address1= echo urlencode($_REQUEST["address1"]); ?> } ?> if($_REQUEST["kakaku1"]){ ?>&kakaku1= echo urlencode($_REQUEST["kakaku1"]); ?> } ?> if($_REQUEST["kakaku2"]){ ?>&kakaku2= echo urlencode($_REQUEST["kakaku2"]); ?> } ?> if($_REQUEST["menseki1"]){ ?>&menseki1= echo urlencode($_REQUEST["menseki1"]); ?> } ?> if($_REQUEST["menseki2"]){ ?>&menseki2= echo urlencode($_REQUEST["menseki2"]); ?> } ?> if($_REQUEST["mdkazu"]){ ?>&mdkazu= echo urlencode($_REQUEST["mdkazu"]); ?> } ?> if($_REQUEST["rmd"]){ ?>&rmd= echo urlencode($_REQUEST["rmd"]); ?> } ?>">次へ>>
} ?>
<<信大特集トップヘ
Notice: Undefined variable: navi1 in /var/www/html/i/sdai on line 322
Notice: Undefined variable: cr in /var/www/html/i/sdai on line 324