\n"); print("\n"); print("\n"); print("\n"); print("$str\n"); print("\n"); print("\n"); exit(); } ######################################## ### ヘッダ情報の出力 ######################################## function put_header(){ header("Content-type: text/html; charset=utf-8"); header("Expires: Thu, 01 Dec 1994 16:00:00 GMT"); header("Last-Modified: ". gmdate("D, d M Y H:i:s"). " GMT"); header("Cache-Control: no-cache, must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); } ######################################## ### magic_quoteのチェック ######################################## function all_stripslashes(&$value,$key){ $value = stripslashes($value); } function check_magic_quotes(){ if (get_magic_quotes_gpc()){ $result = array_walk($_GET,'all_stripslashes'); $result = array_walk($_POST,'all_stripslashes'); $result = array_walk($_COOKIE,'all_stripslashes'); } } ######################################## ### おすすめ物件の表示 ######################################## function print_pickup(){ $db = opendb(); $query = ""; $query .= "SELECT * "; $query .= "FROM ( "; $query .= "( "; $query .= "SELECT 'c' as kubun,number,bukken_mei,point,filename_01,touroku "; $query .= "FROM tbl_chintai "; $query .= "WHERE point_check='1' and active='1' "; $query .= ") "; $query .= "UNION ALL "; $query .= "( "; $query .= "SELECT 'b' as kubun,number,bukken_mei,point,filename_01,touroku "; $query .= "FROM tbl_baibai "; $query .= "WHERE point_check='1' and active='1' "; $query .= ") "; $query .= ") as AAA "; ###$query .= "ORDER BY AAA.touroku desc "; $query .= "ORDER BY rand() "; $query .= "LIMIT 0,5 "; $result = query_sql($db,$query); $row_count = query_rows($result); closedb($db); $source = ""; if($row_count > 0){ while($aryCol = query_fetch($result)){ $source .= "
"; $source .= "
"; if($aryCol['kubun'] == 'c'){ $source .= ""; } else{ $source .= ""; } $source .= ""; $source .= ""; $source .= "
"; $source .= "

"; $source .= htmlspecialchars($aryCol['bukken_mei']); $source .= "

"; if($aryCol['kubun'] == 'c'){ $source .= "[賃貸]"; } else{ $source .= "[売買]"; } $source .= htmlspecialchars($aryCol['point']); $source .= "
"; } } return $source; } //////////////////////////////////////////////////////////////////////////////// /// データベース関数 //////////////////////////////////////////////////////////////////////////////// ######################################## ### データベース接続 ######################################## function opendb(){ $con = mysqli_connect(DB_HOST,DB_USER,DB_PASS,DB_NAME); if(!$con){ print_error("データベース接続時にエラーが発生しました。"); } ///mysqli_select_db(DB_NAME); ///mysqli_query($con,"SET NAMES utf8"); return($con); } ######################################## ### データベース切断 ######################################## function closedb($db){ $con = mysqli_close($db); if(!$con){ print_error("データベース切断時にエラーが発生しました。"); } return($con); } ######################################## ### SQLクエリーの実行 ######################################## function query_sql($db,$sql){ ///mysql_select_db(DB_NAME); $result = mysqli_query($db,$sql); if(!$result){ $message = mysqli_error($db); print_error("SQLクエリー実行時にエラーが発生しました。

" . $sql . "

" . $message); } return($result); } ######################################## ### SQLクエリーの結果(件数取得) ######################################## function query_rows($result){ $row = mysqli_num_rows($result); return($row); } ######################################## ### SQLクエリーの結果(フェッチ) ######################################## function query_fetch($result){ $aryCol = mysqli_fetch_array($result,MYSQLI_ASSOC); return($aryCol); } ######################################## ### エスケープ処理 ######################################## function query_escape($str){ return($str); } ######################################## ### スマートフォン判定 ######################################## function is_smartphone () { $useragents = array( 'iPhone' // Apple iPhone ,'iPod' // Apple iPod touch ,'Android' // 1.5+ Android ); $pattern = '/'.implode('|', $useragents).'/i'; return preg_match($pattern, $_SERVER['HTTP_USER_AGENT']); } //////////////////////////////////////////////////////////////////////////////// /// 定数 //////////////////////////////////////////////////////////////////////////////// $array_chintai_bukken_type = array( '1' => 'マンション・アパート', '2' => '戸建て', '3' => '事業用', '4' => '土地', '5' => '駐車場' ); $array_baibai_bukken_type = array( '1' => 'マンション・アパート', '2' => '戸建て', '3' => '事業用', '4' => '土地', '5' => '投資用', ); $array_sakimono_bukken = array ( '0' => '', '1' => '先物物件' ); $array_point_check = array ( '0' => '', '1' => 'おすすめ公開する' ); ?>