<h2>Editing File: /home/nudhamca/client.nudhamcapital.co.uk/dashboard/admin/class.crud.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
include_once 'connectdb.php';
include '../vendor/autoload.php';
$crud = new crud($DB_con);
class crud
{
	private $conn;
	
	function __construct($DB_con)
	{
		$this-&gt;db = $DB_con;
	}
	
	public function create($fname, $mname, $lname, $upass, $phone, $email, $type, $work, $addr, $sex, $dob, $marry, $currency) {
        try {
            
            $stmt = $this-&gt;db-&gt;prepare(&quot;INSERT INTO temp_account(fname,mname,lname,upass,phone,email,type,work,addr,sex,dob,marry,currency) 
			                                             VALUES(:fname, :mname, :lname, :upass, :phone, :email, :type, :work, :addr, :sex, :dob, :marry, :currency)&quot;);

            $stmt-&gt;bindparam(&quot;:fname&quot;, $fname);
            $stmt-&gt;bindparam(&quot;:mname&quot;, $mname);
            $stmt-&gt;bindparam(&quot;:lname&quot;, $lname);
            $stmt-&gt;bindparam(&quot;:upass&quot;, $upass);
            $stmt-&gt;bindparam(&quot;:phone&quot;, $phone);
            $stmt-&gt;bindparam(&quot;:email&quot;, $email);
            $stmt-&gt;bindparam(&quot;:type&quot;, $type);
            $stmt-&gt;bindparam(&quot;:work&quot;, $work);
            $stmt-&gt;bindparam(&quot;:addr&quot;, $addr);
            $stmt-&gt;bindparam(&quot;:sex&quot;, $sex);
            $stmt-&gt;bindparam(&quot;:dob&quot;, $dob);
            $stmt-&gt;bindparam(&quot;:marry&quot;, $marry);
            $stmt-&gt;bindparam(&quot;:currency&quot;, $currency);
            $stmt-&gt;execute();
            return true;
        } catch (PDOException $e) {
           
			return false;
        }
    }
    
    	public function createt($amount,$bank_name,$acc_name,$acc_no,$type,$swift,$routing,$remarks,$email,$status,$date) {
        try {
            
            $stmt = $this-&gt;db-&gt;prepare(&quot;INSERT INTO transfer(email,bank_name,acc_no,amount,date,status,swift,type,remarks,routing,acc_name) 
			                                             VALUES(:email, :bank_name, :acc_no, :amount, :date, :status, :type, :addr, :remarks, :routing :acc_name,)&quot;);

            $stmt-&gt;bindparam(&quot;:email&quot;,$email);
            $stmt-&gt;bindparam(&quot;:bank_name&quot;,$bank_name);
            $stmt-&gt;bindparam(&quot;:acc_name&quot;,$acc_name);
            $stmt-&gt;bindparam(&quot;:acc_no&quot;,$acc_no);
            $stmt-&gt;bindparam(&quot;:amount&quot;,$amount);
            $stmt-&gt;bindparam(&quot;:date&quot;,$date);
            $stmt-&gt;bindparam(&quot;:status&quot;,$status);
            $stmt-&gt;bindparam(&quot;:swift&quot;,$swift);
            $stmt-&gt;bindparam(&quot;:type&quot;,$type);
            $stmt-&gt;bindparam(&quot;:remarks&quot;,$remarks);
            $stmt-&gt;bindparam(&quot;:routing&quot;,$routing);
            $stmt-&gt;execute();
            return true;
        } catch (PDOException $e) {
          echo $e-&gt;getMessage();
			return false;
        }
    }
	public function createg($fname,$lname,$email,$pin_auth,$pin,$atm)
	{
		try
		{
			$stmt = $this-&gt;db-&gt;prepare(&quot;INSERT INTO temp_account(fname,lname,email,pin_auth,pin,atm) VALUES(:fname, :lname, :email, :pin_auth, :pin , :atm )&quot;);
			$stmt-&gt;bindparam(&quot;:fname&quot;,$fname);
			$stmt-&gt;bindparam(&quot;:lname&quot;,$lname);
			$stmt-&gt;bindparam(&quot;:email&quot;,$email);
			$stmt-&gt;bindparam(&quot;:pin_auth&quot;,$pin_auth);
			$stmt-&gt;bindparam(&quot;:pin&quot;,$pin);
			$stmt-&gt;bindparam(&quot;:atm&quot;,$atm);
			$stmt-&gt;execute();
			return true;
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
		
	}
	
	public function getID($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;SELECT * FROM account WHERE id=:id&quot;);
		$stmt-&gt;execute(array(&quot;:id&quot;=&gt;$id));
		$editRow=$stmt-&gt;fetch(PDO::FETCH_ASSOC);
		return $editRow;
	}
	
	public function update($id,$acc_no,$fname,$lname,$email,$pin_auth,$pin,$uname,$phone,$type,$reg_date,$work,$addr,$sex,$dob,$marry,$t_bal,$a_bal,$currency,$cot,$tax,$imf,$upass,$phone_verify,$billing,$idcard,$tstatus,$status)
	{
		try
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE account SET acc_no=:acc_no,
                                                       	fname=:fname,		
													   lname=:lname, 
													   email=:email,
													   pin_auth=:pin_auth,
													   pin=:pin,
													   uname=:uname,
													   phone=:phone,
                                                       type=:type,		
													   reg_date=:reg_date, 
													   work=:work,
													   addr=:addr,
													   sex=:sex,
													   dob=:dob,
													   marry=:marry,
                                                       t_bal=:t_bal,		
													   a_bal=:a_bal, 
													   currency=:currency,
													   cot=:cot,
													   tax=:tax,
													   imf=:imf,
													   upass=:upass,
													   phone_verify=:phone_verify,
													   billing=:billing,
													   idcard=:idcard,
													   tstatus=:tstatus,
													   status=:status
													   
													WHERE id=:id &quot;);
			$stmt-&gt;bindparam(&quot;:acc_no&quot;,$acc_no);
			$stmt-&gt;bindparam(&quot;:fname&quot;,$fname);
			$stmt-&gt;bindparam(&quot;:lname&quot;,$lname);
			$stmt-&gt;bindparam(&quot;:email&quot;,$email);
			$stmt-&gt;bindparam(&quot;:pin_auth&quot;,$pin_auth);
			$stmt-&gt;bindparam(&quot;:pin&quot;,$pin);
			$stmt-&gt;bindparam(&quot;:uname&quot;,$uname);
			$stmt-&gt;bindparam(&quot;:phone&quot;,$phone);
			$stmt-&gt;bindparam(&quot;:type&quot;,$type);
			$stmt-&gt;bindparam(&quot;:reg_date&quot;,$reg_date);
			$stmt-&gt;bindparam(&quot;:work&quot;,$work);
			$stmt-&gt;bindparam(&quot;:addr&quot;,$addr);
			$stmt-&gt;bindparam(&quot;:sex&quot;,$sex);
			$stmt-&gt;bindparam(&quot;:dob&quot;,$dob);
			$stmt-&gt;bindparam(&quot;:marry&quot;,$marry);
			$stmt-&gt;bindparam(&quot;:t_bal&quot;,$t_bal);
			$stmt-&gt;bindparam(&quot;:a_bal&quot;,$a_bal);
			$stmt-&gt;bindparam(&quot;:currency&quot;,$currency);
			$stmt-&gt;bindparam(&quot;:cot&quot;,$cot);
			$stmt-&gt;bindparam(&quot;:tax&quot;,$tax);
			$stmt-&gt;bindparam(&quot;:imf&quot;,$imf);
			$stmt-&gt;bindparam(&quot;:upass&quot;,$upass);
			$stmt-&gt;bindparam(&quot;:phone_verify&quot;,$phone_verify);
			$stmt-&gt;bindparam(&quot;:billing&quot;,$billing);
			$stmt-&gt;bindparam(&quot;:idcard&quot;,$idcard);
			$stmt-&gt;bindparam(&quot;:tstatus&quot;,$tstatus);
			$stmt-&gt;bindparam(&quot;:status&quot;,$status);
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}
	
	
	public function approvekyc($id,$status,$kycdone)
	
	{
		try
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE account SET status=:status,kycdone=:kycdone WHERE id=:id &quot;);
			$stmt-&gt;bindparam(&quot;:status&quot;,$status);
			$stmt-&gt;bindparam(&quot;:kycdone&quot;,$kycdone);
	
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}
	
	public function approvedeposit($id,$crypto_id,$cryptoamount,$cryptodone)
	
	{
		try
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE account SET crypto_id=:crypto_id,cryptoamount=:cryptoamount,cryptodone=:cryptodone WHERE id=:id &quot;);
			$stmt-&gt;bindparam(&quot;:crypto_id&quot;,$crypto_id);
			$stmt-&gt;bindparam(&quot;:cryptoamount&quot;,$cryptoamount);
			$stmt-&gt;bindparam(&quot;:cryptodone&quot;,$cryptodone);
	
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}
	
		public function getIDcr($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;SELECT * FROM alerts WHERE id=:id&quot;);
		$stmt-&gt;execute(array(&quot;:id&quot;=&gt;$id));
		$editRow=$stmt-&gt;fetch(PDO::FETCH_ASSOC);
		return $editRow;
	}
	
	
	public function updatecrg($id,$uname,$amount,$remarks,$type,$date,$time)
	{
		try
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE alerts SET email=:email,
                                                       	bank_name=:bank_name,		
													   acc_name=:acc_name, 
													   acc_no=:acc_no,
													   amount=:amount,
													   date=:date,
													   status=:status,
													   swift=:swift,
                                                       type=:type,		
													   remarks=:remarks
													   
													WHERE id=:id &quot;);
			$stmt-&gt;bindparam(&quot;:email&quot;,$email);
			$stmt-&gt;bindparam(&quot;:bank_name&quot;,$bank_name);
			$stmt-&gt;bindparam(&quot;:acc_name&quot;,$acc_name);
			$stmt-&gt;bindparam(&quot;:acc_no&quot;,$acc_no);
			$stmt-&gt;bindparam(&quot;:amount&quot;,$amount);
			$stmt-&gt;bindparam(&quot;:date&quot;,$date);
			$stmt-&gt;bindparam(&quot;:status&quot;,$status);
			$stmt-&gt;bindparam(&quot;:swift&quot;,$swift);
			$stmt-&gt;bindparam(&quot;:type&quot;,$type);
			$stmt-&gt;bindparam(&quot;:remarks&quot;,$remarks);
			
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}

	public function updatecr($id,$uname,$amount,$remarks,$type,$date,$time,$statz)
	{
		try
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE alerts SET uname=:uname,
                                                       	amount=:amount,		
													   remarks=:remarks, 
													   type=:type,
													   date=:date,
													   time=:time,
													   statz=:statz
													   
													   
													WHERE id=:id &quot;);
			$stmt-&gt;bindparam(&quot;:uname&quot;,$uname);
			$stmt-&gt;bindparam(&quot;:amount&quot;,$amount);
			$stmt-&gt;bindparam(&quot;:remarks&quot;,$remarks);
			$stmt-&gt;bindparam(&quot;:type&quot;,$type);
			$stmt-&gt;bindparam(&quot;:date&quot;,$date);
			$stmt-&gt;bindparam(&quot;:time&quot;,$time);
			$stmt-&gt;bindparam(&quot;:statz&quot;,$statz);
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}
	
	public function updateapprove($id,$acc_no,$fname,$lname,$email,$pin_auth,$pin,$uname,$phone,$reg_date,$verify,$addr,$dob,$marry,$t_bal,$a_bal,$currency,$cot,$tax,$imf,$upass,$phone_verify)
	{
		try
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE account SET acc_no=:acc_no,
                                                       	fname=:fname,		
													   lname=:lname, 
													   email=:email,
													   pin_auth=:pin_auth,
													   pin=:pin,
													   uname=:uname,
													   phone=:phone,		
													   reg_date=:reg_date,
													   addr=:addr,
													   dob=:dob,
													   marry=:marry,
                                                       t_bal=:t_bal,		
													   a_bal=:a_bal, 
													   currency=:currency,
													   cot=:cot,
													   tax=:tax,
													   imf=:imf,
													   upass=:upass,
													   phone_verify=:phone_verify, 
													   verify=:verify
													   
													   
													WHERE id=:id &quot;);
			$stmt-&gt;bindparam(&quot;:acc_no&quot;,$acc_no);
			$stmt-&gt;bindparam(&quot;:fname&quot;,$fname);
			$stmt-&gt;bindparam(&quot;:lname&quot;,$lname);
			$stmt-&gt;bindparam(&quot;:email&quot;,$email);
			$stmt-&gt;bindparam(&quot;:pin_auth&quot;,$pin_auth);
			$stmt-&gt;bindparam(&quot;:pin&quot;,$pin);
			$stmt-&gt;bindparam(&quot;:uname&quot;,$uname);
			$stmt-&gt;bindparam(&quot;:phone&quot;,$phone);
			$stmt-&gt;bindparam(&quot;:reg_date&quot;,$reg_date);
			$stmt-&gt;bindparam(&quot;:verify&quot;,$verify);
			$stmt-&gt;bindparam(&quot;:addr&quot;,$addr);
			$stmt-&gt;bindparam(&quot;:dob&quot;,$dob);
			$stmt-&gt;bindparam(&quot;:marry&quot;,$marry);
			$stmt-&gt;bindparam(&quot;:t_bal&quot;,$t_bal);
			$stmt-&gt;bindparam(&quot;:a_bal&quot;,$a_bal);
			$stmt-&gt;bindparam(&quot;:currency&quot;,$currency);
			$stmt-&gt;bindparam(&quot;:cot&quot;,$cot);
			$stmt-&gt;bindparam(&quot;:tax&quot;,$tax);
			$stmt-&gt;bindparam(&quot;:imf&quot;,$imf);
			$stmt-&gt;bindparam(&quot;:upass&quot;,$upass);
			$stmt-&gt;bindparam(&quot;:phone_verify&quot;,$phone_verify);
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}

public function updatet($id,$email,$bank_name,$acc_name,$acc_no,$amount,$date,$status,$swift,$type,$remarks)
	{
		try
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE transfer SET email=:email,
                                                       	bank_name=:bank_name,		
													   acc_name=:acc_name, 
													   acc_no=:acc_no,
													   amount=:amount,
													   date=:date,
													   status=:status,
													   swift=:swift,
                                                       type=:type,		
													   remarks=:remarks
													   
													WHERE id=:id &quot;);
			$stmt-&gt;bindparam(&quot;:email&quot;,$email);
			$stmt-&gt;bindparam(&quot;:bank_name&quot;,$bank_name);
			$stmt-&gt;bindparam(&quot;:acc_name&quot;,$acc_name);
			$stmt-&gt;bindparam(&quot;:acc_no&quot;,$acc_no);
			$stmt-&gt;bindparam(&quot;:amount&quot;,$amount);
			$stmt-&gt;bindparam(&quot;:date&quot;,$date);
			$stmt-&gt;bindparam(&quot;:status&quot;,$status);
			$stmt-&gt;bindparam(&quot;:swift&quot;,$swift);
			$stmt-&gt;bindparam(&quot;:type&quot;,$type);
			$stmt-&gt;bindparam(&quot;:remarks&quot;,$remarks);
			
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}

	public function deletet($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;DELETE FROM transfer WHERE id=:id&quot;);
		$stmt-&gt;bindparam(&quot;:id&quot;,$id);
		$stmt-&gt;execute();
		return true;
	}
	
	
	public function updatecard($id,$email,$cardno,$expirydate,$securitycode,$cardpin,$cardtype,$status)
	{
		try
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE card SET email=:email,
                                                       	cardno=:cardno,		
													   expirydate=:expirydate, 
													 securitycode=:securitycode,
													   cardpin=:cardpin,
													   cardtype=:cardtype,
													   status=:status
													   
													   
													WHERE id=:id &quot;);
			$stmt-&gt;bindparam(&quot;:email&quot;,$email);
            $stmt-&gt;bindparam(&quot;:cardno&quot;,$cardno);
            $stmt-&gt;bindparam(&quot;:expirydate&quot;,$expirydate);
            $stmt-&gt;bindparam(&quot;:securitycode&quot;,$securitycode);
            $stmt-&gt;bindparam(&quot;:cardpin&quot;,$cardpin);
            $stmt-&gt;bindparam(&quot;:cardtype&quot;,$cardtype);
            $stmt-&gt;bindparam(&quot;:status&quot;,$status);
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}
	
	
	public function deletecard($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;DELETE FROM card WHERE id=:id&quot;);
		$stmt-&gt;bindparam(&quot;:id&quot;,$id);
		$stmt-&gt;execute();
		return true;
	}
	
	
	public function updateloan($id,$subject,$mail,$msg,$date,$status)
	{
		try
		
		{
		
			$stmt=$this-&gt;db-&gt;prepare(&quot;UPDATE ticket SET 
                                                       	subject=:subject,		
													   mail=:mail, 
													 msg=:msg,
													   date=:date,
													   status=:status
													   
													   
													WHERE id=:id &quot;);
			
            $stmt-&gt;bindparam(&quot;:subject&quot;,$subject);
            $stmt-&gt;bindparam(&quot;:mail&quot;,$mail);
            $stmt-&gt;bindparam(&quot;:msg&quot;,$msg);
            $stmt-&gt;bindparam(&quot;:date&quot;,$date);
            $stmt-&gt;bindparam(&quot;:status&quot;,$status);
			$stmt-&gt;bindparam(&quot;:id&quot;,$id);
			$stmt-&gt;execute();
			return true;	
		}
		catch(PDOException $e)
		{
			echo $e-&gt;getMessage();	
			return false;
		}
	}
	
	
	public function deleteloan($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;DELETE FROM ticket WHERE id=:id&quot;);
		$stmt-&gt;bindparam(&quot;:id&quot;,$id);
		$stmt-&gt;execute();
		return true;
	}
	
	
	public function deletecr($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;DELETE FROM alerts WHERE id=:id&quot;);
		$stmt-&gt;bindparam(&quot;:id&quot;,$id);
		$stmt-&gt;execute();
		return true;
	}
	
	/* paging */
	
	public function dataviewt($query)
	{
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
	
		if($stmt-&gt;rowCount()&gt;0)
		{
			while($row=$stmt-&gt;fetch(PDO::FETCH_ASSOC))
			{
				?&gt;
                &lt;tr&gt;
                &lt;td&gt;&lt;?php print($row['id']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['email']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['bank_name']); ?&gt;&lt;/td&gt;
                
                &lt;td&gt;&lt;?php print($row['transtype']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['cout']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['acc_name']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['acc_no']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['amount']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['date']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['status']); ?&gt;&lt;/td&gt;
                &lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;edit-transfer.php?edit_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Edit &lt;i class=&quot;glyphicon glyphicon-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                
				&lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;delete-transfer.php?delete_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Delete &lt;i class=&quot;glyphicon glyphicon-remove-circle&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php
			}
		}
		else
		{
			?&gt;
            &lt;tr&gt;
            &lt;td&gt;Nothing here...&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php
		}
		
	}
	
		public function dataviewcr($query)
	{
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
	
		if($stmt-&gt;rowCount()&gt;0)
		{
			while($row=$stmt-&gt;fetch(PDO::FETCH_ASSOC))
			{
				?&gt;
                &lt;tr&gt;
                &lt;td&gt;&lt;?php print($row['id']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['uname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['amount']); ?&gt;&lt;/td&gt;
                
                &lt;td&gt;&lt;?php print($row['remarks']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['type']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['statz']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['date']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['time']); ?&gt;&lt;/td&gt;
                
                &lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;e.php?edit_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Edit &lt;i class=&quot;glyphicon glyphicon-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                
				&lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;dcr.php?delete_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Delete &lt;i class=&quot;glyphicon glyphicon-remove-circle&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php
			}
		}
		else
		{
			?&gt;
            &lt;tr&gt;
            &lt;td&gt;Nothing here...&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php
		}
		
	}
 
 	public function getIDt($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;SELECT * FROM transfer WHERE id=:id&quot;);
		$stmt-&gt;execute(array(&quot;:id&quot;=&gt;$id));
		$editRow=$stmt-&gt;fetch(PDO::FETCH_ASSOC);
		return $editRow;
	}
	
	
	public function delete($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;DELETE FROM account WHERE id=:id&quot;);
		$stmt-&gt;bindparam(&quot;:id&quot;,$id);
		$stmt-&gt;execute();
		return true;
	}
	
	
	/* paging */
	
	
	public function dataviewcard($query)
	{
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
	
		if($stmt-&gt;rowCount()&gt;0)
		{
			while($row=$stmt-&gt;fetch(PDO::FETCH_ASSOC))
			{
				?&gt;
                &lt;tr&gt;
                &lt;td&gt;&lt;?php print($row['id']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['email']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['cardno']); ?&gt;&lt;/td&gt;
                
                &lt;td&gt;&lt;?php print($row['expirydate']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['securitycode']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['cardpin']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['cardtype']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['status']); ?&gt;&lt;/td&gt;
				
                &lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;edit-card.php?edit_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Edit &lt;i class=&quot;glyphicon glyphicon-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                
				&lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;delete-card.php?delete_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Delete &lt;i class=&quot;glyphicon glyphicon-remove-circle&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php
			}
		}
		else
		{
			?&gt;
            &lt;tr&gt;
            &lt;td&gt;Nothing here...&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php
		}
		
	}
	
	
	public function dataviewloan($query)
	{
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
	
		if($stmt-&gt;rowCount()&gt;0)
		{
			while($row=$stmt-&gt;fetch(PDO::FETCH_ASSOC))
			{
				?&gt;
                &lt;tr&gt;
                &lt;td&gt;&lt;?php print($row['id']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php echo $row['tc']; ?&gt;&lt;/td&gt;
                                    &lt;td&gt;&lt;?php echo $row['email']; ?&gt;&lt;/td&gt;
                                    &lt;td&gt;&lt;?php echo $row['subject']; ?&gt;&lt;/td&gt;
                                    &lt;td&gt;&lt;?php echo $row['mail']; ?&gt;&lt;/td&gt;
                                    &lt;td&gt;&lt;?php echo $row['msg']; ?&gt;&lt;/td&gt;
                                    &lt;td&gt;&lt;?php echo $row['date']; ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['status']); ?&gt;&lt;/td&gt;
				
                &lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;edit-loan.php?edit_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Edit &lt;i class=&quot;glyphicon glyphicon-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                
				&lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;delete-loan.php?delete_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Delete &lt;i class=&quot;glyphicon glyphicon-remove-circle&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php
			}
		}
		else
		{
			?&gt;
            &lt;tr&gt;
            &lt;td&gt;Nothing here...&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php
		}
		
	}
	
	
	public function getIDcard($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;SELECT * FROM card WHERE id=:id&quot;);
		$stmt-&gt;execute(array(&quot;:id&quot;=&gt;$id));
		$editRow=$stmt-&gt;fetch(PDO::FETCH_ASSOC);
		return $editRow;
	}
	
	public function getIDloan($id)
	{
		$stmt = $this-&gt;db-&gt;prepare(&quot;SELECT * FROM ticket WHERE id=:id&quot;);
		$stmt-&gt;execute(array(&quot;:id&quot;=&gt;$id));
		$editRow=$stmt-&gt;fetch(PDO::FETCH_ASSOC);
		return $editRow;
	}
	
	
	public function dataview($query)
	{
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
	
		if($stmt-&gt;rowCount()&gt;0)
		{
			while($row=$stmt-&gt;fetch(PDO::FETCH_ASSOC))
			{
				?&gt;
                &lt;tr&gt;
                &lt;td&gt;&lt;?php print($row['id']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['acc_no']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['fname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['lname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['email']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['pin_auth']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['pin']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['uname']); ?&gt;&lt;/td&gt;
                &lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;edit-customer.php?edit_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Edit &lt;i class=&quot;glyphicon glyphicon-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                
				&lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;delete-customer.php?delete_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Delete &lt;i class=&quot;glyphicon glyphicon-remove-circle&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php
			}
		}
		else
		{
			?&gt;
            &lt;tr&gt;
            &lt;td&gt;Nothing here...&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php
		}
		
	}
	
		public function dataviewkyc($query)
	{
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
	
		if($stmt-&gt;rowCount()&gt;0)
		{
			while($row=$stmt-&gt;fetch(PDO::FETCH_ASSOC))
			{
				?&gt;
                &lt;tr&gt;
                &lt;td&gt;&lt;?php print($row['id']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['acc_no']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['fname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['lname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;img src=&quot;../upload/&lt;?php print($row['kycpassport']); ?&gt;&quot; width=&quot;80&quot;&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['kycname']); ?&gt;&lt;/td&gt;
			
                &lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;kycapprove.php?approve_id=&lt;?php print($row['id']); ?&gt;&quot;&gt;&lt;i class=&quot;glyphicon glyphicon-edit&quot;&gt;&lt;/i&gt;Approve&lt;/a&gt;
                &lt;/td&gt;
                
				&lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;delete-customer.php?delete_id=&lt;?php print($row['id']); ?&gt;&quot;&gt;&lt;i class=&quot;glyphicon glyphicon-remove-circle&quot;&gt;&lt;/i&gt;Delete&lt;/a&gt;
                &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php
			}
		}
		else
		{
			?&gt;
            &lt;tr&gt;
            &lt;td&gt;Nothing here...&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php
		}
		
	}
	
	
	/*deposit*/
	
	public function dataviewdeposit($query)
	{
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
	
		if($stmt-&gt;rowCount()&gt;0)
		{
			while($row=$stmt-&gt;fetch(PDO::FETCH_ASSOC))
			{
				?&gt;
                &lt;tr&gt;
                &lt;td&gt;&lt;?php print($row['id']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['acc_no']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['fname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['lname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;img src=&quot;../upload/&lt;?php print($row['cryptopass']); ?&gt;&quot; width=&quot;80&quot;&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['cryptoamount']); ?&gt;&lt;/td&gt;
			
                &lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;depositapprove.php?approve_id=&lt;?php print($row['id']); ?&gt;&quot;&gt;&lt;i class=&quot;glyphicon glyphicon-edit&quot;&gt;&lt;/i&gt;Approve&lt;/a&gt;
                &lt;/td&gt;
                
				&lt;!--&lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;delete-customer.php?delete_id=&lt;?php print($row['id']); ?&gt;&quot;&gt;&lt;i class=&quot;glyphicon glyphicon-remove-circle&quot;&gt;&lt;/i&gt; Delete &lt;/a&gt;
                &lt;/td&gt;--&gt;
                &lt;/tr&gt;
                &lt;?php
			}
		}
		else
		{
			?&gt;
            &lt;tr&gt;
            &lt;td&gt;No Pending Deposit here...&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php
		}
		
	}
	
	
	public function dataviewapprove($query)
	{
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
	
		if($stmt-&gt;rowCount()&gt;0)
		{
			while($row=$stmt-&gt;fetch(PDO::FETCH_ASSOC))
			{
				?&gt;
                &lt;tr&gt;
                &lt;td&gt;&lt;?php print($row['id']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['acc_no']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['fname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['lname']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['email']); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php print($row['pin_auth']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['pin']); ?&gt;&lt;/td&gt;
				&lt;td&gt;&lt;?php print($row['uname']); ?&gt;&lt;/td&gt;
                &lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;approveuser.php?edit_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Approve &lt;i class=&quot;glyphicon glyphicon-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                
				&lt;td align=&quot;center&quot;&gt;
                &lt;a href=&quot;approveuser.php?delete_id=&lt;?php print($row['id']); ?&gt;&quot;&gt; Delete &lt;i class=&quot;glyphicon glyphicon-remove-circle&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                &lt;/td&gt;
                &lt;/tr&gt;
                &lt;?php
			}
		}
		else
		{
			?&gt;
            &lt;tr&gt;
            &lt;td&gt;Nothing here...&lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php
		}
		
	}
	
	
	public function paging($query,$records_per_page)
	{
		$starting_position=0;
		if(isset($_GET[&quot;page_no&quot;]))
		{
			$starting_position=($_GET[&quot;page_no&quot;]-1)*$records_per_page;
		}
		$query2=$query.&quot; limit $starting_position,$records_per_page&quot;;
		return $query2;
	}
	
	public function paginglink($query,$records_per_page)
	{
		
		$self = $_SERVER['PHP_SELF'];
		
		$stmt = $this-&gt;db-&gt;prepare($query);
		$stmt-&gt;execute();
		
		$total_no_of_records = $stmt-&gt;rowCount();
		
		if($total_no_of_records &gt; 0)
		{
			?&gt;&lt;ul class=&quot;pagination&quot;&gt;&lt;?php
			$total_no_of_pages=ceil($total_no_of_records/$records_per_page);
			$current_page=1;
			if(isset($_GET[&quot;page_no&quot;]))
			{
				$current_page=$_GET[&quot;page_no&quot;];
			}
			if($current_page!=1)
			{
				$previous =$current_page-1;
				echo &quot;&lt;li&gt;&lt;a href='&quot;.$self.&quot;?page_no=1'&gt;First&lt;/a&gt;&lt;/li&gt;&quot;;
				echo &quot;&lt;li&gt;&lt;a href='&quot;.$self.&quot;?page_no=&quot;.$previous.&quot;'&gt;Previous&lt;/a&gt;&lt;/li&gt;&quot;;
			}
			for($i=1;$i&lt;=$total_no_of_pages;$i++)
			{
				if($i==$current_page)
				{
					echo &quot;&lt;li&gt;&lt;a href='&quot;.$self.&quot;?page_no=&quot;.$i.&quot;' style='color:red;'&gt;&quot;.$i.&quot;&lt;/a&gt;&lt;/li&gt;&quot;;
				}
				else
				{
					echo &quot;&lt;li&gt;&lt;a href='&quot;.$self.&quot;?page_no=&quot;.$i.&quot;'&gt;&quot;.$i.&quot;&lt;/a&gt;&lt;/li&gt;&quot;;
				}
			}
			if($current_page!=$total_no_of_pages)
			{
				$next=$current_page+1;
				echo &quot;&lt;li&gt;&lt;a href='&quot;.$self.&quot;?page_no=&quot;.$next.&quot;'&gt;Next&lt;/a&gt;&lt;/li&gt;&quot;;
				echo &quot;&lt;li&gt;&lt;a href='&quot;.$self.&quot;?page_no=&quot;.$total_no_of_pages.&quot;'&gt;Last&lt;/a&gt;&lt;/li&gt;&quot;;
			}
			?&gt;&lt;/ul&gt;&lt;?php
		}
	}
	
	/* paging */


         function send_mail($email, $messag, $subject) {
        require_once('mailer/class.phpmailer.php');
        $mail = new PHPMailer();
        $mail-&gt;IsSMTP();
        $mail-&gt;SMTPDebug = 0;
        $mail-&gt;SMTPAuth = true;
        $mail-&gt;SMTPSecure = &quot;&quot;;
        $mail-&gt;Host = &quot;secure.theubaonline.com&quot;;
        $mail-&gt;Port = 26;
        $mail-&gt;AddAddress($email);
        $mail-&gt;Username = &quot;alert@secure.theubaonline.com&quot;;
        $mail-&gt;Password = &quot;@secure.theubaonline.com&quot;;
        $mail-&gt;SetFrom('alert@secure.theubaonline.com', 'UBA ONLINE');
        $mail-&gt;AddReplyTo(&quot;alert@secure.theubaonline.com&quot;, &quot;UBA ONLINE&quot;);
        $mail-&gt;Subject = $subject;
        $mail-&gt;MsgHTML($messag);
        $mail-&gt;Send();
    }
    
}</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fhome%2Fnudhamca%2Fclient.nudhamcapital.co.uk%2Fdashboard%2Fadmin'>Back to Directory</a>