<?php
class Db{
        public $pdo;
        public function connect (){
            $dsn="mysql:host=127.0.0.1;dbname=Forum";
            $user="root";
            $pwd="troiswa";
            $this->pdo = new PDO($dsn,$user,$pwd);
        }
        /*public function __construct($user, $password, $dbname) {
            $this->pdo = new \PDO('mysql:host=127.0.0.1;dbname='.$dbname, $user, $password);
            $this->pdo->exec('set names utf8');
        }*/
        public function titre($filter){
            $sqlTitre = "SELECT topic.id,topic.titre,topic.date,topic.classe,users.login FROM topic INNER JOIN users ON topic.user_id=users.id WHERE topic.classe LIKE ('".$filter."%')";
            $stmt=$this->pdo->prepare($sqlTitre);
            $stmt->execute();
            $dataTitle=$stmt->fetchAll(PDO::FETCH_ASSOC);
            return $dataTitle;
        }
        public function messages($filter){
            $sql = "SELECT topic.id,topic.titre,topic.date,topic.message,users.login FROM topic INNER JOIN users ON topic.user_id=users.id WHERE topic.id LIKE ('".$filter."%')";
            $stmt=$this->pdo->prepare($sql);
            $stmt->execute();
            $dataMessage=$stmt->fetchAll(PDO::FETCH_ASSOC);
            return $dataMessage;
        }
        public function question($titre,$message,$auteur,$classe){
            $sqlNew="INSERT INTO topic (titre,message,user_id,classe) VALUES (?,?,?,?)";
            $stmt=$this->pdo->prepare($sqlNew);
            $stmt->execute(array($titre,$message,$auteur,$classe));
        }
        public function allArt(){
            $sql="SELECT articles.* FROM articles";
            $stmt=$this->pdo->prepare($sql);
            $stmt->execute();
            $dataLog=$stmt->fetchAll(PDO::FETCH_ASSOC);
            return !!count($dataLog);
        }
        public function commentaires($select){
            $sql = "SELECT commentaires.*,users.login\n"
            . "FROM commentaires\n"
            . "inner JOIN users ON commentaires.auteur_id=users.id\n"
            . "inner JOIN topic ON commentaires.article_id=topic.id\n"
            . "WHERE article_id=?";
            $stmt=$this->pdo->prepare($sql);
            $stmt->execute(array($select));
            $dataCom=$stmt->fetchAll(PDO::FETCH_ASSOC);
            return $dataCom;
        }
        public function answer($article,$auteur,$message){
            $sqlNew="INSERT INTO commentaires (texte,auteur_id,article_id) VALUES (?,?,?)";
            $stmt=$this->pdo->prepare($sqlNew);
            $stmt->execute(array($article,$auteur,$message));
        }
    }
/*

    echo "<pre>";
    echo var_dump();
    echo "</pre>";

*/
?>