Example #1
0
<?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');
Example #2
0
 $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&ntilde;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';