Exemple #1
0
function lire_infos_utilisateur($id_utilisateur)
{
    $pdo = PDO2::getInstance();
    $requete = $pdo->prepare("SELECT nom_utilisateur, mot_de_passe, adresse_email, date_inscription, hash_validation\n        FROM membres\n        WHERE\n        id = :id_utilisateur");
    $requete->bindValue(':id_utilisateur', $id_utilisateur);
    return $requete->execute() ? $requete->fetch(PDO::FETCH_ASSOC) : false;
}
Exemple #2
0
function maintain_angry()
{
    $pdo = PDO2::getInstance();
    $query = $pdo->prepare("UPDATE tbl_rabbit_skill SET skill_angry = skill_angry - :maintain_value");
    $query->bindValue(":maintain_value", 10);
    return $pdo->execute();
}
function ajouter_user_dans_bd($firstname, $lastname, $username, $password, $repassword, $email)
{
    $bdd = PDO2::getInstance();
    $bothSame = $bdd->prepare("SELECT nom_utilisateur FROM membres WHERE nom_utilisateur = ':user'");
    $bothSame->bindParam(':user', $username);
    $bothSame->execute();
    if ($bothSame->rowCount() > 0) {
        echo 'Désolé l\'utilisateur que vous essayer de prendre est déjà utilisé dans la base de données' . 'Veuillez en choisir un autre.';
    } else {
        $req = $bdd->prepare('INSERT INTO membres(prenom, nom_famille, nom_utilisateur, mot_de_passe, adresse_email, date_inscription) VALUES(:firstname,:lastname,:utilisateur, :password, :email, NOW()');
        $req->bindValue(':firstname', $firstname);
        $req->bindValue(':lastname', $lastname);
        $req->bindValue(':utilisateur', $username);
        $req->bindValue(':password', $password);
        $req->bindValue(':email', $email);
        //$req->bindValue(':date', date('Y-m-d H:i:s'));
        if ($req->execute()) {
            return $pdo->lastInsertId();
        }
        $select = $bdd->query('SELECT * FROM membres');
        while ($donnees = $select->fetch()) {
            $_SESSION['utilisateur'] = $donnees['nom_utilisateur'];
        }
        $select->closeCursor();
    }
}
Exemple #4
0
 public function retrouver_mess_forum($forum)
 {
     $connexion = PDO2::getInstance();
     $requete_select_forum = $requete_tous_message = "SELECT * FROM message WHERE forum_ForumID = {$id_forum}";
     $db = $connexion->query($requete_tous_titres);
     $resultat = $db->fetchAll(PDO::FETCH_ASSOC);
     return $resultat;
 }
Exemple #5
0
function ajouter_membre_dans_bdd($nom_utilisateur, $mdp, $adresse_email, $hash_validation)
{
    $pdo = PDO2::getInstance();
    $requete = $pdo->prepare("INSERT INTO membres SET\n        nom_utilisateur = :nom_utilisateur,\n        mot_de_passe = :mot_de_passe,\n        adresse_email = :adresse_email,\n        hash_validation = :hash_validation,\n        date_inscription = NOW()");
    $requete->bindValue(':nom_utilisateur', $nom_utilisateur);
    $requete->bindValue(':mot_de_passe', $mdp);
    $requete->bindValue(':adresse_email', $adresse_email);
    $requete->bindValue(':hash_validation', $hash_validation);
    return $requete->execute() ? $pdo->lastInsertId() : $requete->errorInfo();
}
Exemple #6
0
function user_has_nabz($usr_nabz)
{
    $pdo = PDO2::getInstance();
    $query = $pdo->prepare("SELECT rabbit_id FROM tbl_rabbit WHERE rabbit_usr_id = :user_id");
    $query->bindValue(":user_id", $usr_nabz);
    $query->execute();
    if ($result = $query->fetch(PDO::FETCH_ASSOC)) {
        $query->closeCursor();
        return $result['rabbit_id'];
    }
    return false;
}
Exemple #7
0
function get_serial_and_token($id_nabz)
{
    $pdo = PDO2::getInstance();
    $query = $pdo->prepare("SELECT rabbit_serial, rabbit_token FROM tbl_rabbit WHERE rabbit_id = :id_nabz", array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL));
    $query->bindValue(":id_nabz", $id_nabz);
    $query->execute();
    $tbx = array();
    while ($row = $query->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) {
        $tbx['rabbit_serial'] = $row[0];
        $tbx['rabbit_token'] = $row[1];
    }
    //$tbx is an array with all the informations of a product
    return $tbx;
}
Exemple #8
0
function add_member_in_db($username, $password, $email_addr, $hash_validation)
{
    $pdo = PDO2::getInstance();
    $query = $pdo->prepare("INSERT INTO tbl_user SET user_pseudo = :username, user_pass = :password, user_mail = :email_addr, hash_validation = :hash_validation, user_balance = :CASH_START, user_lastconnect = NOW()");
    $query->bindValue(":username", $username);
    $query->bindValue(":password", $password);
    $query->bindValue(":email_addr", $email_addr);
    $query->bindValue(":hash_validation", $hash_validation);
    $query->bindValue(":CASH_START", CASH_START);
    if ($query->execute()) {
        return $pdo->lastInsertId();
    }
    print_r($query->errorInfo());
    return $query->errorInfo();
}
Exemple #9
0
function buy_ticket($id_user, $number, $ticket_price)
{
    $pdo = PDO2::getInstance();
    //Change usr_id column in number row in the table tbl_numbers
    $query = $pdo->prepare("UPDATE tbl_numbers SET usr_id = :usr_id WHERE id = :number");
    $query->bindValue(":usr_id", $id_user);
    $query->bindValue(":number", $number);
    $query->execute();
    print_r($query->errorInfo());
    //Update the balance of the account
    $query = $pdo->prepare("UPDATE tbl_user SET user_balance = :new_balance WHERE user_id = :id_user");
    $query->bindValue(":new_balance", user_balance($id_user) - $ticket_price);
    $query->bindValue(":id_user", $id_user);
    $query->execute();
    print_r($query->errorInfo());
    update_jackpot();
}
Exemple #10
0
 public function get_tous_mess_dans_forum($id_forum)
 {
     $bdd = PDO2::getInstance();
     if ($id_forum == 1) {
         $req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=1');
         $forum = $req->fetchAll();
     } else {
         if ($id_forum == 2) {
             $req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=2');
             $forum = $req->fetchAll();
         } else {
             if ($id_forum == 3) {
                 $req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=3');
                 $forum = $req->fetchAll();
             }
         }
     }
     return $forum;
 }
Exemple #11
0
 protected function UpdateQuery($table, $data)
 {
     $pdo = PDO2::getInstance();
     $params = [];
     $fields = [];
     $id = [];
     foreach ($data as $key => $val) {
         $params[':' . $key . ''] = $val;
         array_push($fields, $key . '=:' . $key);
         if ($key[0]) {
             array_push($id, $key . '=:' . $key);
         }
     }
     $id = array_slice($fields, 0, 1);
     $fields = array_slice($fields, 1);
     $sql = "UPDATE " . $table . " SET " . implode(', ', $fields) . " WHERE " . implode('', $id) . "";
     $stmt = $pdo->prepare($sql);
     $stmt = $stmt->execute($params);
     return $stmt;
 }
Exemple #12
0
<?php

require_once 'pdo2.class.php';
$bdd = PDO2::getInstance();
$query = "INSERT INTO " . PREFIX_TABLE . "_lines VALUES(:nom, :prix, :qte, :tva)";
Exemple #13
0
 public function getEntityPosition(array $filterClauses = array(), array $orderClauses = array())
 {
     $pdo = PDO2::getInstance();
     $requete = $pdo->prepare("\n\t\t\t\tSET @rownum=0\n\t\t\t\t");
     $requete->execute();
     $where = "";
     if (count($filterClauses) > 0) {
         foreach ($filterClauses as $key => $value) {
             $where[] = $value[0] . "= :" . $value[0];
         }
         $where = implode(" AND ", $where);
         $where = " WHERE " . $where;
     }
     $order = "";
     if (count($orderClauses) > 0) {
         foreach ($orderClauses as $key => $value) {
             $order[] = $value[0] . " " . $value[1];
         }
         $order = implode(", ", $order);
         $order = " ORDER BY " . $order;
     }
     $requete = $pdo->prepare("\n\t\t\t\tSELECT num\n\t\t\t\tFROM(\n\t\t\t\tSELECT @rownum:=@rownum+1 as num, id\n\t\t\t\tFROM " . static::getTable() . "\n\t\t\t\t" . $where . "\n\t\t\t\t" . $order . "\n\t\t) e\n\t\t\t\tWHERE id=:id\n\t\t");
     $requete->bindValue(':id', $this->getId(), PDO::PARAM_STR);
     if (count($filterClauses) > 0) {
         foreach ($filterClauses as $key => $value) {
             $requete->bindValue(":" . $value[0], $value[1]);
         }
     }
     $requete->execute();
     if ($position = $requete->fetch()) {
         return $position['num'];
     } else {
         return false;
         //print_r($requete->errorInfo());
     }
 }
Exemple #14
0
function up_lastconnect($id_user)
{
    $pdo = PDO2::getInstance();
    $query = $pdo->prepare("UPDATE tbl_user SET user_lastconnect = NOW() WHERE user_id = :id_user");
    $query->bindValue(":id_user", $id_user);
    return $query->execute();
}
Exemple #15
0
 public static function deleteSkillForProject($skill_id, $project_id)
 {
     $pdo = PDO2::getInstance();
     $requete = $pdo->prepare("\n\t\t\t\tDELETE FROM asso_projects_skills\n\t\t\t\tWHERE id_project=:id_project\n\t\t\t\tAND id_skill= :id_skill\n\t\t\t\t");
     $requete->bindValue(':id_project', $project_id);
     $requete->bindValue(':id_skill', $skill_id);
     if ($requete->execute()) {
         return true;
     } else {
         return false;
         //print_r($requete->errorInfo());
     }
 }
Exemple #16
0
function uniq_prdct_in_cart($prdct_id, $usr_id)
{
    $pdo = PDO2::getInstance();
    $query = $pdo->prepare("SELECT cart_id FROM tbl_cart WHERE user_id = :id_user AND product_id = :id_product");
    $query->bindValue(":id_user", $usr_id);
    $query->bindValue(":id_product", $prdct_id);
    $query->execute();
    if ($result = $query->fetch(PDO::FETCH_ASSOC)) {
        $query->closeCursor();
        return $result['cart_id'];
    }
    return false;
}
Exemple #17
0
function delete_product_incart($id_product)
{
    $pdo = PDO2::getInstance();
    $quantity = display_quantity($id_product, $_SESSION['id']);
    $query = $pdo->prepare("DELETE FROM tbl_cart WHERE product_id = :id_product");
    $query->bindValue(':id_product', $id_product);
    $query->execute();
    return $query->rowCount() == 1;
}
Exemple #18
0
 /**
  * Va chercher tous les messages de la table message qui sont du membre
  * qui détient l'id idMembre.
  * @param $idMembre - l'id du membre
  * @return array - un array d'objets messages du membre qui a l'id $idMembre
  */
 function getMessagesMembre($idMembre)
 {
     $pdo = PDO2::getInstance();
     $requete = $pdo->prepare("SELECT * FROM message WHERE membres_id = :idMembre ORDER BY forum_ForumID, horoDate DESC");
     $requete->bindValue(':idMembre', $idMembre);
     $requete->execute();
     if ($reponse = $requete->fetchAll(PDO::FETCH_ASSOC)) {
         $requete->closeCursor();
     }
     $arrayMessages = array();
     foreach ($reponse as $message) {
         $messageObj = new Message($message['messageID'], $message['texte'], $message['horoDate'], NULL, $message['parent_messageID'], $idMembre, $message['forum_ForumID']);
         $arrayMessages[] = $messageObj;
     }
     return $arrayMessages;
 }
Exemple #19
0
function init_bingo()
{
    $pdo = PDO2::getInstance();
    $query = $pdo->prepare("UPDATE tbl_numbers SET usr_id = 0 WHERE usr_id >0");
    $query->execute();
    //Init jackpot on the txt_file
    update_bingo_jackpot(0);
}