error_reporting(E_ALL);
ini_set('display_errors', '1');
//include "../includes/functions.php";
include "includes/db.php";
require_once "Objects/FunctionClass.php";
$id = isset($_GET['id']) ? $_GET['id'] : "";
$month = isset($_GET['month']) ? $_GET['month'] : "";
$username = isset($_GET['username']) ? $_GET['username'] : "";
$password = isset($_GET['password']) ? $_GET['password'] : "";
$date = date("Y-m%", strtotime("-" . $month . " month"));
//echo $date;
$json = array();
try {
$functionObject = new FunctionClass('./');
$member_id = $functionObject->getIdMembre($username, $password);
$abonnementArray = $functionObject->getJournauxForCurrentAbonnement($member_id);
$STH = $DBH->prepare("\n\tSELECT editions.id, editions.id_journal, editions.datePublication, editions.downloadPath, editions.imagePath, editions.quantite, \n\tjournal.nom, journal.type, journal.categorie, subscription.until\n\tFROM editions \n\tLEFT JOIN journal ON journal.id = editions.id_journal \n\tLEFT JOIN subscription ON journal.id = subscription.journal_id AND until > NOW() AND member_id = '" . (int) $member_id . "'\n\tWHERE editions.id_journal = :id \n\tAND editions.visible = 1 \n\tAND editions.datePublication LIKE :date \n\tORDER BY datePublication ASC\n\t");
$STH->bindParam(":id", $id);
$STH->bindParam(":date", $date);
$STH->execute();
$STH->setFetchMode(PDO::FETCH_ASSOC);
$x = 0;
while ($row = $STH->fetch()) {
//print_r($row);
$temp_journal = array();
$temp_journal['id'] = $row['id'];
$temp_journal['id_journal'] = $row['id_journal'];
$temp_journal['nom'] = $row['nom'];
$temp_journal['type'] = $row['type'];
$temp_journal['categorie'] = $row['categorie'];
$temp_journal['datePublication'] = $row['datePublication'];
