function error_handler($errno, $errstr, $errfile, $errline, $context = null) { if (!(error_reporting() & $errno)) { //unreported error; return; } $db = new \db\db_handler(); $continue = true; switch ($errno) { case E_ERROR: $continue = false; break; case E_WARNING: break; case E_PARSE: break; case E_NOTICE: break; case E_CORE_ERROR: $continue = false; break; case E_CORE_WARNING: $continue = false; break; case E_COMPILE_ERROR: $continue = false; break; case E_COMPILE_WARNING: $continue = false; break; case E_USER_ERROR: $continue = false; break; case E_USER_WARNING: break; case E_USER_NOTICE: break; case E_STRICT: break; case E_RECOVERABLE_ERROR: break; case E_DEPRECATED: break; case E_USER_DEPRECATED: break; default: $continue = false; break; } $sentence = "INSERT INTO `ERRORS` (`ERRNO`,`WHAT`,`FILE`,`LINE`) VALUES (?,?,?,?)"; $db->prepare($sentence); $db->execute($errno, $errstr, $errfile, $errline); }
public function validate_inscription($param) { $other_key = $param; $passdb = new \db\db_handler(); $passdb->prepare("SELECT COUNT(*) AS NUMBER FROM USERS WHERE TOKEN = ?"); $passdb->execute(array($other_key)); $query = $passdb->fetch(PDO::FETCH_ASSOC); if ($query['NUMBER'] === '1') { $passdb->prepare("UPDATE USERS SET ENABLE = 1, TOKEN = null, VALID_TIME = null WHERE TOKEN = ?"); $passdb->execute(array($other_key)); echo "Votre compte a bien été crée !"; } else { echo "Votre compte ne peut être crée ! "; } $passdb->execute(array($other_key)); }
<?php $sessionStart = session_start(); include_once "src/util/auto_class_load.php"; //$_SESSION['logged'] = true; //$_SESSION['ID'] = 126; if (!isset($_SESSION['logged'])) { $_SESSION['logged'] = false; } //initialization of database include_once "src/util/db_wrap.php"; $connexion = new \db\db_handler(); $connexion->init(); //Routing initialization include_once "src/Router.php"; $router = new Router(); //URL rewriting $task = explode('/', $_SERVER["REQUEST_URI"]); //get the right route from the first parameter $route = $router->getRoute($task[1]); //get correct MVC bloc $model = new $route->model(); $controller = new $route->controller($model); $view = new $route->view($model); require_once "src/util/regex.php"; //var_dump($task); if (count($task) > 2) { $options = array_slice($task, 2); foreach ($options as $value) { if (empty($value) === false) { $controller->addOption(strip_all("/[^\\w]/", $value));
<?php /** * Created by PhpStorm. * User: kevin * Date: 23/01/16 * Time: 21:34 */ include_once 'db_wrap.php'; include "/home/aaron-aaron/www/src/class/Twitter.php"; $bd = new \db\db_handler(); $bd->init(); $sql = "DELETE FROM TWEET"; $bd->query($sql); $sql = "SELECT * FROM TWITTER"; $stmt = $bd->query($sql); while ($result = $stmt->fetch()) { $newFlux = new Twitter($result['ID'], $result['NAME']); $newFlux->refresh(); } $bd->close();
public function create_new_user(User $user, $password, $key) { $token = $this->getRandomToken(); $this->pdo->prepare("INSERT INTO `USERS` (`EMAIL`,`NAME`,`ENABLE`,`TOKEN`) VALUES (?,?,0,?)"); $this->pdo->execute(array($user->getEmail(), $user->getName(), $key)); $id = $this->pdo->lastInsertId(); $new_password = encrypt($password, $token); $passdb = new \db\db_handler(); $passdb->prepare("INSERT INTO `PASSWORD` (`ID`,`PASSWORD`,`TOKEN`) VALUES (?,?,?)"); $passdb->execute(array($id, $new_password, $token)); }