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()}");
}
?>
