setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // [店舗基本データ]※店舗ページ共通 $sql = "SELECT shop.shopname, shop.address, shop.head_image, shop.priority FROM shop WHERE owner_id = :owner_id"; $stmt = $dbh->prepare($sql); $stmt->bindParam(':owner_id', $id); $stmt->execute(); $shop_data = $stmt->fetch(PDO::FETCH_ASSOC); // print_r($shop_data); // [写メログデータ] $sql = "SELECT id, created_at, file, subject, body, member_name, member_id FROM diary WHERE id = :did"; $stmt = $dbh->prepare($sql); $stmt->bindParam(':did', $did); $stmt->execute(); $diary = $stmt->fetch(PDO::FETCH_ASSOC); // print_r($diary); $member_name = $diary['member_name']; // [ページングのためにIDをまとめる] $sql = "SELECT id FROM diary WHERE member_id = :member_id ORDER BY created_at DESC"; $stmt = $dbh->prepare($sql); $stmt->bindParam(':member_id', $member_id); $stmt->execute(); $id_lists = $stmt->fetchAll(PDO::FETCH_ASSOC); // print_r($id_lists); // [前・次の準備] $prev_id = null; $next_id = null; // ひとつ前の(古い)投稿 foreach ($id_lists as $key=>$arr_id) { if ($arr_id['id'] == $did) { if ($key != (count($id_lists) - 1)) { $next_id = $id_lists[$key + 1]['id']; } if ($key != 0) { $prev_id = $id_lists[$key - 1]['id']; } } } if ($prev_id) { // [次の写メログデータ] $sql = "SELECT subject FROM diary WHERE id = :prev_id"; $stmt = $dbh->prepare($sql); $stmt->bindParam(':prev_id', $prev_id); $stmt->execute(); $prev_subject = $stmt->fetch(PDO::FETCH_ASSOC)['subject']; } if ($next_id) { // [前の写メログデータ] $sql = "SELECT subject FROM diary WHERE id = :next_id"; $stmt = $dbh->prepare($sql); $stmt->bindParam(':next_id', $next_id); $stmt->execute(); $next_subject = $stmt->fetch(PDO::FETCH_ASSOC)['subject']; } } catch (Exception $e) { echo exec('whoami'); echo 'DBエラー'; print_r($e); exit(); } function pagingLink($num) { global $id, $member_id; $url = 'https://xn--08jy26gy2cqzgfuj1p2g.com/shop/shop-diary/member-diary-detail.php?id='.$id.'&member_id='.$member_id.'&did='.$num; echo $url; } ?> 「<?= $member_name; ?>」の写メ日記 | <?= $shop_data['shopname']; ?> | <?= $shop_data['address']; ?> | <?= SITE_NAME; ?>

写メ日記

写メ日記
プロフィール
の投稿
checkBodyImageCommon(htmlspecialchars_decode($diary['body']), $data_address_top_domain); if (strpos($tmp_src, 'diary_image') !== false) { // [フーマッチで保存された画像のパスを調整する] // fuumatch => /uploads/diary_image/数字複数桁/ // 女性向け風俗 => /_uploads/diary/ $pattern = '/\/uploads\/diary_image\/\d{1,}\//'; $body = preg_replace($pattern, '/_uploads/diary/', htmlspecialchars_decode($diary["body"])); // フーマッチにアップロードされた画像をそのまま使用していたころの名残 // 上のbodyで不具合が出たらとりあえずこのbodyを使うようにするので暫くは削除しない // $body = str_replace('src="/uploads/diary_image', 'src="https://fuumatch.com/uploads/diary_image', htmlspecialchars_decode($diary["body"])); } else { // 新サーバ画像若しくは画像無し $body = htmlspecialchars_decode($diary['body']); } ?>
chevron_left
navigate_next