public function setEnabled(ConnectionDB $connection, $enabled) { $params = [$this->email, $enabled]; $query = "CALL sp_enableUser(?,?)"; $connection->statementQuery($query, $params); $this->enabled = $enabled; }
/** * Fixer la configuration de la connexion à la BD. * @param string $dsn DNS pour la connexion BD. * @param string $username Utilisateur pour la connexion BD. * @param string $password Mot de passe pour la connexion BD. * @param array $driver_options Options du pilote BD. * * @return void */ public static function setConfiguration($dsn, $username = '', $password = '', array $driver_options = array()) { self::$_DSN = $dsn; self::$_username = $username; self::$_password = $password; self::$_driverOptions = $driver_options + self::$_driverOptions; }
public static function getInstance() { if (self::$_instance === null) { self::$_instance = new self(); } return self::$_instance; }
public static function updateMessage($message) { $consulta = "UPDATE " . self::NAME_TABLE . " SET " . self::DESCRIPTION . "=?" . " WHERE " . self::ID . "=1"; $sentencia = ConnectionDB::getInstance()->getDB()->prepare($consulta); $sentencia->bindParam(1, $message); $sentencia->execute(); return $sentencia->rowCount(); }
public static function getAppId($appKey) { $command = "SELECT " . self::ID . " FROM " . self::NAME_TABLE . " WHERE " . self::ACCESS_KEY . "=?"; $sentence = ConnectionDB::getInstance()->getDB()->prepare($command); $sentence->bindParam(1, $appKey); if ($sentence->execute()) { $result = $sentence->fetch(); return $result['id']; } else { return null; } }
public function getResult() { $connectionDB = ConnectionDB::getInstance(); $mysqli = $connectionDB::connect(); $table = 'math_correct_answers'; $allAnswers = array(); $query = Mysqli_query($mysqli, "\n SELECT `sum_id`, `answer` FROM {$table}\n "); while ($row = mysqli_fetch_assoc($query)) { $allAnswers[$row['sum_id']] = $row['answer']; } $resultArray = array_intersect_assoc($allAnswers, $_SESSION['answers']); $data = array(); $data['correctAnswers'] = count($resultArray); $data['allAnswers'] = count($allAnswers); $data = json_encode($data); echo $data; }
public function deleteSum() { $connectionDB = ConnectionDB::getInstance(); $mysqli = $connectionDB::connect(); $id = $_POST['id']; $response = ''; $query = Mysqli_query($mysqli, "DELETE FROM math_sums WHERE id = " . $id); if ($query) { $response .= 'Deleted test ' . $id . 'from math_sums. '; } else { exit(mysqli_error($mysqli)); } $query = Mysqli_query($mysqli, "DELETE FROM math_correct_answers WHERE sum_id = " . $id); if ($query) { $response .= 'Deleted test ' . $id . 'from math_correct_answers. '; } else { exit(mysqli_error($mysqli)); } echo $response; }
public static function updateMoney($idUser, $idMoney, $price) { $pdo = ConnectionDB::getInstance()->getDB(); $command = "INSERT INTO dp_history_money (price,id_money,id_user) VALUES(?,?,?)"; $sentencia = $pdo->prepare($command); $sentencia->bindParam(1, $price); $sentencia->bindParam(2, $idMoney); $sentencia->bindParam(3, $idUser); $sentencia->execute(); return $sentencia->rowCount(); }
<?php require_once './lib/player.php'; require_once './lib/connectionDB.php'; session_start(); //Creamos un objeto de bd (Crea la conexión). $connec = new ConnectionDB(); /*Cada vez que incluyamos este código, se validará si hay una sesión iniciada. Si no hay sesión iniciada nos redirige al formulario inicial de registro de jugador.*/ if (!isset($_SESSION['player']) && isset($_POST['login'])) { if (isset($_POST['name']) && isset($_POST['lastname']) && isset($_POST['age'])) { if ($connec->checkConnection() === 'ok') { $player = new Player($_POST['name'], $_POST['lastname'], $_POST['age']); $_SESSION['player'] = $player; $connec->checkPlayer($player->getName(), $player->getLastName(), $player->getAge()); } else { //$_SESSION['errorDB'] = "error"; $_SESSION['errorDB'] = $connec; header('location: index.php'); } } else { //Si los datos del formulario no están completos volvemos al formulario inicial de login. header('location: index.php'); } } //Esto sucede cuando venimos del formulario de modificación de datos del usuario. if (isset($_POST['newdata'])) { if (isset($_POST['newname']) && isset($_POST['newlastname']) && isset($_POST['newage'])) { //Extraemos el jugador de la sesión y seteamos los nuevos datos. $player = $_SESSION['player']; //Actualizamos la bd con los nuevos datos del jugador.
<?php session_start(); require_once './lib/connectionDB.php'; require_once './lib/page.php'; //Si quisieramos volver al formulario inicial con una sesión iniciada, nos redirige al juego. if (isset($_SESSION['player'])) { header('location: play.php'); } $pageIndex = new Page(); echo $pageIndex->getHeaderIndex(); //Si la sesión tiene valor de error de conexión, mostraremos una ventana modal con info. if (isset($_SESSION['errorDB'])) { $connec = new ConnectionDB(); $connec->checkConnection(); $connec->showMessage('connect', null, null); //destruimos la sesión para limpiar todo. session_destroy(); } ?> <body onload="showModalWindow()"> <div class="container"> <form class="form-signin" action="play.php" method="post" style="visibility='hidden';"> <h2 class="form-signin-heading"><span class='glyphicon glyphicon-user'></span> Introduce tus datos</h2> <div class="form-group"> <div class="input-group"> <span class="input-group-addon">Nombre:</span> <input type="text" name="name" id="name" class="form-control" required autofocus> <input type="hidden" name="login"> </div> </div>
<?php /* * To change this template, choose Tools | Templates * and open the template in the editor. */ /** * Description of conectar * * @author tato */ include "ConnectionDB.php"; $connector = new ConnectionDB($_POST["host"], $_POST["db"], $_POST["user"], $_POST["pwd"]); $connector->connectMySQL(); //conecto con la bd $sqlInsert = "INSERT INTO table1(attribute) VALUES (\"value_0\"), (\"value_1\")"; $q1 = $connector->query($sqlInsert); //inserto 2 valores if ($q1) { echo "<br><p>Insersión exitosa.<br>Se insertaron los valores:\n value_0 y value_1.<br>Con la consulta: {$sqlInsert}"; } echo "<br><p>Creando Array..."; $values = array("array_value_0", "array_value_1"); echo "<br><p>Array creado."; $query = "INSERT INTO table1(attribute) VALUES "; $resultInsert = $connector->mysql_array_to_insert($query, $values); echo "<br><p>Insersión ralizada. Resultado: {$resultInsert}"; $sqlSelect = "SELECT * FROM table1"; $resultSelect = $connector->query($sqlSelect); //consulto table1 if ($resultSelect) {
function _destructor() { self::$pdo = null; }
public static function getUserByUsername($username) { $comando = "SELECT " . self::USERNAME . "," . self::PASSWORD . "," . self::API_KEY . " FROM " . self::NAME_TABLE . " WHERE " . self::USERNAME . "=?"; $sentencia = ConnectionDB::getInstance()->getDB()->prepare($comando); $sentencia->bindParam(1, $username); if ($sentencia->execute()) { return $sentencia->fetch(PDO::FETCH_ASSOC); } else { return null; } }
------------------------------------------------------------------------- LICENSE This file is part of the ProjectS3. This is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. this software is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this software. If not, see <http://www.gnu.org/licenses/>. -------------------------------------------------------------------------- */ ConnectionDB::beginTransaction(); try { // TRANSACTION CODE HERE // toutes les modifications de la table suite à un formulaire doivent // se trouver dans une transaction comme celle ci // cela permet une meilleure efficacité de la BD } catch (Exception $e) { ConnectionDB::rollback(); } ConnectionDB::commit();
public static function change_position($id1, $id2) { $pdo = ConnectionDB::getInstance()->getDB(); $command = "UPDATE " . self::NAME_TABLE . " t1, " . self::NAME_TABLE . " t2 SET t1." . self::POSITION . "=t2." . self::POSITION . ", t2." . self::POSITION . "=t1." . self::POSITION . " WHERE t1." . self::ID_PRODUCT . "=? and t2." . self::ID_PRODUCT . "=?"; $sentencia = $pdo->prepare($command); $sentencia->bindParam(1, $id1); $sentencia->bindParam(2, $id2); $sentencia->execute(); return $sentencia->rowCount(); }
/** * cree une instance d'User * @param $crypt String mot de passe crypté de l'utilisateur * @return User instance de user (depend du type d'user) * @throws Exception si le pseudo ou mot de passe est invalide */ public static function createFromAuth($crypt) { self::startSession(); $connection = ConnectionDB::GetInstance(); $stmt = $connection->prepare(<<<SQL SELECT * FROM User WHERE SHA1(concat(SHA1(pseudo), :challenge, password))=:crypt; SQL ); $stmt->execute(array("challenge" => $_SESSION['challenge'], "crypt" => $crypt)); $stmt->setFetchMode(PDO::FETCH_CLASS, __CLASS__); $user = $stmt->fetch(); $user = self::building($user); unset($_SESSION['challenge']); if ($user !== false) { self::startSession(); return $user; } else { throw new Exception("Pseudo ou mot de passe invalide"); } }