| Server IP : 84.32.84.242 / Your IP :
216.73.216.109 [
Web Server : LiteSpeed System : Linux nl-srv-web1124.main-hosting.eu 4.18.0-553.121.1.lve.el8.x86_64 #1 SMP Thu Apr 30 16:40:41 UTC 2026 x86_64 User : u964240598 ( 964240598) PHP Version : 8.4.19 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u964240598/domains/hofam.org/public_html/churchapp/application/models/ |
Upload File : |
<?php
if(!defined('BASEPATH')) exit('No direct script access allowed');
/**
* Created by PhpStorm.
* User: ray
* Date: 12/06/2018
* Time: 14:29
*/
class Verify_model extends CI_Model{
public $status = 'error';
public $message = 'Something went wrong';
//insert verification details to the db
public function insertData($data){
//$data[':createdDtm'] = date('Y-m-d H:i:s');
//$sql = "INSERT INTO tbl_verification (email, activation_id,agent,client_ip,createdDtm) VALUES (:email, :activation_id,:agent,:client_ip,:createdDtm)";
//$stmt= $this->db->conn_id->prepare($sql);
//$stmt->execute($data);
$this->db->trans_start();
$this->db->insert('tbl_verification', $data);
$this->db->trans_complete();
}
//check if verification details exists, when user clicks on the link sent to mail
public function checkActivationDetails($email,$activation_id){
//$stmt = $this->db->conn_id->prepare("SELECT * FROM tbl_verification WHERE email=? AND activation_id=?");
//$stmt->execute([$email,$activation_id]);
//$row = $stmt->fetch(PDO::FETCH_OBJ);
$this->db->select('tbl_verification.*');
$this->db->from('tbl_verification');
$this->db->where('email',$email);
$this->db->where('activation_id',$activation_id);
$query = $this->db->get();
$row = $query->row();
if($row){
return TRUE;
}
return FALSE;
}
//delete details when user have been verified
public function deleteActivationDetails($email,$activation_id){
//$stmt = $this->db->conn_id->prepare("DELETE FROM tbl_verification WHERE email=? AND activation_id=?");
//$stmt->execute([$email,$activation_id]);
$this->db->where('email',$email);
$this->db->where('activation_id',$activation_id);
$this->db->delete('tbl_verification');
$this->status = 'ok';
}
}
Anon7 - 2022
AnonSec Team
