Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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>";
- */
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement