Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id name email pasword
- 1 andrew email@example.com hashed password
- 2 mike email2@example.com hashed password
- class Database {
- private $host = DB_HOST;
- private $user = DB_USER;
- private $pass = DB_PASS;
- private $dbname = DB_NAME;
- private $dbh;
- private $error;
- private $stmt;
- public function __construct() {
- // Set DSN
- $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname;
- // Set options
- $options = array (
- PDO::ATTR_PERSISTENT => true,
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
- );
- // Create a new PDO instanace
- try {
- $this->dbh = new PDO ($dsn, $this->user, $this->pass, $options);
- } // Catch any errors
- catch ( PDOException $e ) {
- $this->error = $e->getMessage();
- }
- }
- public function query($query) {
- $this->stmt = $this->dbh->prepare($query);
- }
- public function bind($param, $value, $type = null) {
- if (is_null ( $type )) {
- switch (true) {
- case is_int ( $value ) :
- $type = PDO::PARAM_INT;
- break;
- case is_bool ( $value ) :
- $type = PDO::PARAM_BOOL;
- break;
- case is_null ( $value ) :
- $type = PDO::PARAM_NULL;
- break;
- default :
- $type = PDO::PARAM_STR;
- }
- }
- $this->stmt->bindValue ( $param, $value, $type );
- }
- public function execute(){
- return $this->stmt->execute();
- }
- public function resultset(){
- $this->execute();
- return $this->stmt->fetchAll(PDO::FETCH_OBJ);
- }
- public function single(){
- $this->execute();
- return $this->stmt->fetch(PDO::FETCH_OBJ);
- }
- public function rowCount(){
- return $this->stmt->rowCount();
- }
- public function login($email){
- $this->db->query("SELECT email FROM users
- WHERE email = :email
- ");
- //Bind Values
- $this->db->bind(':email', $email);
- $row = $this->db->single();
- //Check Rows
- if($this->db->rowCount() > 0){
- $this->setUserData($row);
- return true;
- } else {
- return false;
- }
- }
- public function bringpassword($email1){
- $this->db->query("SELECT pasword FROM users
- WHERE email = :email
- ");
- $this->db->bind(':email',$email);
- $result = $this->db->single();
- $results =$result->pasword;
- return $results;
- }
- }
- if(isset($_POST['loginM'])){
- $email=$_POST['user_email3'];
- $user= new User;
- $password1=$_POST['user_password2'];
- $hash=$user->bringpassword($email);
- if($user->login($email)){
- if(strlen($_POST['user_password2'])>5 && password_verify($password1,$hash)){
- redirect('index.php');
- }else{
- echo $hash;
- //redirect('register.php','The email and password combination is incorrect!', 'error1');
- }
- }else{
- redirect('register.php',"We don't seem to recognize that email address!", 'error1');
- }
- }else {
- redirect('register.php');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement