Member.php

<?php
class Member {
    
public $timee;
public $table;

public function __construct(){
    
    $this->table = "users";   
 date_default_timezone_set('Africa/Lagos');

}



      //check if email exists already before registration to avoid double email
  public function check_email($email,$conn){
         
          $this->table = "users";

    $stmt = $conn->prepare("SELECT * FROM ".$this->table." WHERE email='$email' LIMIT 1");
    $stmt->execute();
                        if($stmt->rowCount() > 0)
                        {
                          while($row = $stmt->fetch(PDO::FETCH_ASSOC))
                          {

                                     return true;
                          }
                        } 

                        else {
                             return false; 
                       }      
      }


      //password reset email rendering
   public function render_email($token) {
    
            ob_start();
            include "password_reset_email.phtml";
            return ob_get_contents();
       }

<<<<<<< HEAD
     public function register($firstname,$lastname,$email,$password, $wallet, $db){
=======
     public function register($firstname,$lastname,$email,$password,$db){
>>>>>>> 9c517d19f1298f2398adc90fab46cefce2080ba0
        
        $this->table = 'users';
        
        
        $password_hash = md5($password);
        
        $timee=date('Y-m-d H:i:s');

                try {
<<<<<<< HEAD
            $query = "INSERT INTO ".$this->table."(firstname,lastname,email,password, wallet, timee ) 
        VALUES ('$firstname','$lastname','$email','$password_hash', '$wallet' ,'$timee')";
=======
            $query = "INSERT INTO ".$this->table."(firstname,lastname,email,password,timee ) 
        VALUES ('$firstname','$lastname','$email','$password_hash','$timee')";
>>>>>>> 9c517d19f1298f2398adc90fab46cefce2080ba0

            $db->exec($query);
          return true;
          }
        catch(PDOException $e)
            {
           // echo $query . "<br>" . $e->getMessage();
            return false;
            }            
        
    }

//get details of user

    public function get_profile($db){
        if(!isset($_SESSION['id'])){
            //location to redirect to should be set here 
            $location='';
            redirect($location);
        }
        
        $id = $_SESSION['id'];
        if(empty($id)){
        die("Your session has expired or your not logged in. please Login");    
        }
        $dataa=array();
        $i=0;
        $query = "SELECT * FROM ".$this->table." WHERE id = '$id' LIMIT 1" ;
        
     $result = $db->query($query);
     $num = mysqli_num_rows($result);
     if($num > 0)
     {
     
      while($row = mysqli_fetch_array($result)){
         $dataa['fullname'] = $row['fullname'];
          $dataa['username'] = $row['username'];
         $dataa['email']= $row['email'];
         $dataa['timee'] = $row['timee'];
         $dataa['lastname'] = $row['lastname'];
    
         $dataa['id']= $row['id'];
        
        // $i++;
     }
     
     return $dataa;
    }
    
     else{
         return false;
        //echo $db->error;
        //return false; 
    
     }
                   
        
    
}
    
    //profile update function
    
    public function update_profile($fullname,$lastname,$email,$db){
        if(!isset($_SESSION['id'])){
            die("Your session has expired or your not logged in. please Login");
        }
        
        $id = $_SESSION['id'];
        
        $query="UPDATE ".$this->table." SET fullname=?,email=? WHERE id=? LIMIT 1";
        $statement = $db->prepare($query);
        $statement->bind_param("ssss",$fullname,$email,$id);
    
    
     
     if ( $statement->execute() ){
         return true;
     }
     
     else{
        return false;
        
     }
        
        
        
    }   
    
      

    //password token update
    public function update_token($email,$token,$db){
        

        try {

            $query="UPDATE ".$this->table." SET password_reset_token='$token' WHERE email='$email' LIMIT 1";

            $db->exec($query);
          return true;
          }
        catch(PDOException $e)
            {
           // echo $query . "<br>" . $e->getMessage();
            return false;
            }       
        
        
    }
    
    //update verification status
    public function verified($id,$db){
        $query="UPDATE ".$this->table." SET verify_status=1 WHERE id=? LIMIT 1";
        $statement = $db->prepare($query);
        $statement->bind_param("s",$id);
     
     if ( $statement->execute() ){
         return true;
     }
     
     else{
        return false;
        
     }
        
        
        
    }
    
//login check
  public function check($email,$password,$conn){

        $this->table = "users";
        $password_hash = md5($password);

    $stmt = $conn->prepare("SELECT * FROM ".$this->table." WHERE email='$email' AND password='$password_hash' LIMIT 1");
    $stmt->execute();
                        if($stmt->rowCount() > 0)
                        {
                          while($row = $stmt->fetch(PDO::FETCH_ASSOC))
                          {
                                // print_r($row);
                                     $_SESSION['id'] = $row['id'];
                                     ;
                                     $_SESSION['email'] = $row['email'];

                                     return true;
                          }
                        } else {
                             return false; 
                       }
          
      }

  
  public function get_data_from_id($id,$db){
         
          $query = "SELECT * FROM ".$this->table." WHERE id=? LIMIT 1";
          $statement = $db->prepare($query);
          $statement->bind_param("s",$id);
     if ( $statement->execute() ){   
         $result = $statement->get_result();
         $num = $result->num_rows;
         
         if($num > 0){
              $row = $result->fetch_assoc();
             
         return $row;
         }
         else{
    
            return false; 
         }
     }
     else{
        return false;
     }
          
      }
  
  
   public function verify_code($id,$code,$db){
         
          $query = "SELECT * FROM ".$this->table." WHERE id=? LIMIT 1";
          $statement = $db->prepare($query);
          $statement->bind_param("s",$id);
     if ( $statement->execute() ){   
         $result = $statement->get_result();
         $num = $result->num_rows;
         
         if($num > 0){
              $row = $result->fetch_assoc();
              
                    $v=strcmp($row['verify_code'],$code);
                    
                    similar_text($row['verify_code'], $code, $percent); 
                    
                    
                   if (intval($percent) === 100){
                       return true;
                   
                   }
               else {
                 return "no";  
               }
         }
         else{
    
            return false; 
         }
     }
     else{
        return false;
     }
          
      }
  
  
  //for admin to get users on the database if need be
   public function get_users($db){
         $dataa=array();
         $i=0;
          $query = "SELECT * FROM ".$this->table." ";
          
            $result = $db->query($query);
            $num = mysqli_num_rows($result);
           if($num > 0){
                 while($row = mysqli_fetch_array($result)){
                 $dataa['firstname'][$i] = $row['name'];
                 $dataa['email'][$i]= $row['email'];
                 $dataa['timee'][$i] = $row['timee'];
                 $dataa['lastname'][$i] = $row['lastname'];
                
                 $i++;
             }
             return $dataa;  
               
           }
         else {
            return false; 
         }
    
          
      }

  
   


    //to check password token for password resets       
    public function check_token($token,$conn){
          //$password_hash = md5($password);
          $query = "SELECT * FROM ".$this->table." WHERE password_reset_token='$token' LIMIT 1";

          $stmt = $conn->prepare($query);
         
          $stmt->execute();

         if($stmt->rowCount() > 0)
                        {
                          while($row = $stmt->fetch(PDO::FETCH_ASSOC))
                          {
                                // print_r($row);
                                     $_SESSION['id'] = $row['id'];
                                     ;
                                     $_SESSION['email'] = $row['email'];

                                     return true;
                          }
                        } else {
                             return false; 
                       }
          
      }


   //change password function
    public function update_password($id,$password,$conn){
         $password_hash = md5($password);

          try {

           $query="UPDATE ".$this->table." SET password='$password_hash' WHERE id='$id' LIMIT 1";

            $conn->exec($query);
          return true;
          }
        catch(PDOException $e)
            {
           // echo $query . "<br>" . $e->getMessage();
            return false;
            }    

    
       
       
   }


//password reset function starts here 

  
  
  
  
 
//member class ends here    
}