- 
						
						for($i=0;$i<$k_cnt;$i++){
							?>
							
- 
								
									- =$k_nm[$i]?>- =$k_naiyo[$i]?> 
 }
						?>
include($_SERVER['DOCUMENT_ROOT'] . '/sys/auto_style.php');
require_once($_SERVER['DOCUMENT_ROOT'] . '/sys/mysql_func.php');
$conn = MYDB_CONTACT2($MYSQLHOST, $MYSQLUSERNAME, $MYSQLPASSWORD, $MYSQLDATABASE);
include($_SERVER['DOCUMENT_ROOT'].'/sys/kihon2.php');
require_once($_SERVER['DOCUMENT_ROOT'].'/sys/user_loginchk.php');
include($_SERVER['DOCUMENT_ROOT'].'/sys/pager.class.php');
// ページャ
$px = 0;
if($_GET['page']){
	$p = $_GET['page'];
	$px = $p * 30 - 30;
}
	
// 新着情報
$sql_k = "SELECT * FROM kosin k JOIN shop s ON k.shop_id=s.shop_id 
			AND s.shop_visible = 1 
			ORDER BY kosin_id DESC LIMIT $px,30";
$res_k = $conn->query($sql_k);
$k_cnt = 0;
while($d = $res_k->fetch_assoc()){
	$nai      = $d['kosin_naiyo'];
	if($d['shop_id']=='yorunavi'){
		if(preg_match("/href=\"([^\"]+)\"/i", $nai, $nx)){
			$k_url[]= $nx[1];
		}else{
			$k_url[]= '/';
		}
		$nai = strip_tags($nai,'
');
		$k_logo[] = '/img/logo_120.png';
	}else{
		$k_url[]= 'https://yo-ru-navi.com/'.$d['shop_id'].'/';
		$k_logo[] = 'https://yo-ru-navi.com/'.$d['shop_id'].'/img/logo.png';
	}
	$k_nm[] = $d['shop_nm'];
	$k_naiyo[]  = $nai;
	$k_upd[]    = $d['kosin_upd'];
	
	$k_cnt++;
}
$res_k->free;
$Pager = new Pager;		// ページャオブジェクト準備
$p_str = $Pager->doIt(3000);	// ページャ生成
?>
=$ken?>の飲み屋情報ならヨルナビ
ヨルナビ店舗更新情報一覧
=$k_naiyo[$i]?>