-
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]?>