query($sql_sl);
$topicscnt = $res_sl->num_rows;
$res_sl->free;
$sql_sl .= " LIMIT $p,10";
$res_tl = $conn->query($sql_sl);
while($dblg=$res_tl->fetch_assoc()){
$topics_nm[] = $dblg['staff_nm'];
$topics_shop[] = $dblg['shop_nm'];
$topics_ttl[] = $dblg['bbs_title'];
$topics_body[] = strip_tags($dblg['bbs_text']);
$topics_url[] = 'https://yo-ru-navi.com/'.$dblg['shop_id'].'/blogs/detail.php?no='.$dblg['bbs_no'].'&f='.$dblg['staff_id'];
$topics_upd[] = date("Y年n月j日",strtotime($dblg['bbs_upd']));
if (preg_match("/src=\"([^\"]+)\.jpg\"/i", $dblg['bbs_text'], $match1)) {
$match1[1] = str_replace('imgdata/s/','imgdata/400/',$match1[1]);
$topics_img[] = "https://yo-ru-navi.com".$match1[1].".jpg";
}elseif($dblg['staff_img']){
$topics_img[] = "https://yo-ru-navi.com/staffimg/400/".$dblg['staff_img'];
}else{
$topics_img[] = '';
}
}
$res_tl->free;
if($topicscnt<($p + 10)){
$next = 0;
//echo 'topicscnt='.$topicscnt.' p='.$p;
}else{
$next = $p + 10;
}
$prev = $p - 10;
?>
ブログトピックス【Destiny acro】powered by YoruNavi
BLOG情報 高松ホスト Destiny acro