prepare($strSQL); $stmt->execute(); $shop_array = $stmt->fetchAll(PDO::FETCH_ASSOC | PDO::FETCH_UNIQUE); // お知らせ $sql_where = ''; $id = !empty($_GET['id']) ? $_GET['id'] : ''; $preview = !empty($_GET['preview']) ? $_GET['preview'] : ''; $sql_where .= !empty($id) ? "AND a.id = '" . $id . "'" : ""; // データ取得 $sql = ''; $sql .= "SELECT a.* "; $sql .= "from sale AS a "; $sql .= "WHERE 1 "; $sql .= $sql_where; if ($preview <> 'true') { $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 "; } $db->query("SET NAMES utf8"); $stmt = $db->prepare($sql); $stmt->execute(); $sale = array(); $sale = $stmt->fetch(); // 前後レコード取得 $sql = ''; $sql .= "SELECT a.* "; $sql .= "from sale 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 "; $db->query("SET NAMES utf8"); $stmt = $db->prepare($sql); $stmt->execute(); $sale_array = array(); $sale_array = $stmt->fetchAll(PDO::FETCH_ASSOC | PDO::FETCH_UNIQUE); $prev_id = prev_key($sale_array, $id); $next_id = next_key($sale_array, $id); // 切断 $db = null; } catch (PDOException $e) { exit("エラーが発生しました。:{$e->getMessage()}"); } ?>

セール情報