prepare($strSQL); $stmt->execute(); $shop_array = $stmt->fetchAll(PDO::FETCH_ASSOC | PDO::FETCH_UNIQUE); // データ取得 $sql = ''; $sql .= "SELECT a.* "; $sql .= "from news AS a "; $sql .= "WHERE 1 "; $sql .= "AND a.pub = 1 "; $sql .= "AND a.date_start <= NOW() "; $sql .= "AND (a.date_end >= NOW() OR a.date_end = '0000-00-00 00:00:00') "; $sql .= "ORDER BY a.date_start DESC,a.id DESC "; $sql .= "LIMIT 3 "; $db->query("SET NAMES utf8"); $stmt = $db->prepare($sql); $stmt->execute(); $news_array = array(); $news_array = $stmt->fetchAll(); // データ取得 $sql = ''; $sql .= "SELECT a.* ,b.title AS blog_cat_title "; $sql .= "FROM blog AS a "; $sql .= "LEFT JOIN blog_cat AS b ON a.cat = b.id "; $sql .= "WHERE 1 "; $sql .= "AND a.pub = 1 "; $sql .= "AND a.date_start <= NOW() "; $sql .= "AND (a.date_end >= NOW() OR a.date_end = '0000-00-00 00:00:00') "; $sql .= "ORDER BY a.date_start DESC,a.id DESC "; $sql .= "LIMIT 3 "; $db->query("SET NAMES utf8"); $stmt = $db->prepare($sql); $stmt->execute(); $blog_array = array(); $blog_array = $stmt->fetchAll(); // 切断 $db = null; } catch (PDOException $e) { exit("エラーが発生しました。:{$e->getMessage()}"); } ?>

おすすめ定額プラン

地区の風習・寺社の墓地・霊園・宗教にあわせた、35万円、55万円、88万円、110万円のプラン。
やまきの耐震補強工事が標準の安心施工と10年品質保証。

やまきのお墓 施工日誌