<?php

/**
 * @class  Msql
 * @author Afdal
 */
class Mysql {

    private $host = '';
    private $dbname = '';
    private $user = '';
    private $pass = '';

    public function __construct($host, $dbname, $user, $pass) {
        $this->host = $host;
        $this->dbname = $dbname;
        $this->user = $user;
        $this->pass = $pass;
    }

    public function DBconnection() {
        $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname;
        try {
            $connexion = new PDO($dsn, $this->user, $this->pass);
            echo "Connection établie";

            return $connexion;

        } catch (Exception $e) {
            echo 'Erreur : ' . $e->getMessage() . '<br />';
            echo 'N° : ' . $e->getCode() . '<br />';

            die('Une erreur est survenue !');
        }
    }

    /**
     * DATA MANIPULATION SQL QUERY
     * This function allows you to perfom sql queries like "SELECT * FROM User WHERE  User = 'TOTO'"
     * $query = The query that you want to execute
     * The result is returned in form of object $results
     */
    public function Sqlmanip($query) {
        $connexion = $this->DBconnection(); // we make the DB connection
        $results = $connexion->prepare($query); // we make a prepare query
        $results->execute(); // we execute the prepare statement
        $results->setFetchMode(PDO::FETCH_OBJ); // we make an pbject $results

        return $results;
    }

    /**
     * DATA DEFINITION SQL QUERY
     * This function allows you to perfom sql queries like "INSERT, UPDATE, DELETE"
     */
    public function Sqldef($query) {
        $connexion = $this->DBconnection();
        $results = $connexion->exec($query);   // $results retuned 1 if it's true or 0 if it's false   // Es que je devrais mettre prepare aà la place de exec ???
        if (isset($results) && $results == 1) {
            echo "reussi";
        } else {
            echo "echec";
        }
    }

}