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'];