<?php session_start(); include 'includes/globals.php'; include 'includes/functions.php'; include 'includes/redirects.php'; include 'includes/kick.php'; include 'lib/database.class.php'; $database = new Database(); //catch error; echo $database->errorInfo(); //insert $sql = "INSERT INTO mytable (FName, LName, Age, Gender) VALUES (:fname, :lname, :age, :gender)"; $database->query($sql); $database->bind(':fname', 'John'); $database->bind(':lname', 'Smith'); $database->bind(':age', '24'); $database->bind(':gender', 'male'); //$database->execute(); //echo $database->lastInsertId(); //insert array $sql = "INSERT INTO mytable (FName, LName, Age, Gender) VALUES (:fname, :lname, :age, :gender)"; $database->query($sql); $database->bindArray(array(':fname' => 'Maria2', ':lname' => 'Azpeitia', ':age' => 26, ':gender' => 'female')); //$database->execute(); //multiple $database->beginTransaction(); $sql = "INSERT INTO mytable (FName, LName, Age, Gender) VALUES (:fname, :lname, :age, :gender)"; $database->query($sql); $database->bind(':fname', 'Jenny'); $database->bind(':lname', 'Smith');
$confirm_info = $database->single(); //confirm the email and update the users database $seed = '0123456789abcdefghijklmnopqrstuvwxyz'; $hash = sha1(uniqid($seed . mt_rand(), true)); $hash = substr($hash, 0, 10); $pass = password_hash($hash, PASSWORD_DEFAULT); $sql = "UPDATE `users` SET `user_passwd`=:user_passwd WHERE `user_id`=:user_id LIMIT 1"; $database->query($sql); $database->bindArray(array(':user_id' => $confirm_info['userid'], ':user_passwd' => $pass)); if ($database->execute()) { $action['result'] = 'success'; $action['text'] = 'Restablecimiento correcto!'; $run = 1; } else { $action['result'] = 'error'; $action['text'] = 'No se puede restablecer la contraseña debido a: ' . $database->errorInfo(); $run = 0; } //delete the confirm row $sql = "DELETE FROM `forgot` WHERE `id`=:f_id LIMIT 1"; $database->query($sql); $database->bindArray(array(':f_id' => $confirm_info['id'])); $database->execute(); $sql = "OPTIMIZE TABLE `forgot`"; $database->query($sql); $database->execute(); if ($update_users) { $action['result'] = 'success'; $action['text'] = 'Restablecimiento correcto!'; } else { $action['result'] = 'error';