Created
June 6, 2019 08:40
-
-
Save Kathure/910e77a617d06372f8e05b9225272624 to your computer and use it in GitHub Desktop.
This Driver class is for saving User information from a USSD request
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
class Driver | |
{ | |
function __construct() | |
{ | |
try { | |
$DB_host = "localhost"; | |
$DB_user = "username"; | |
$DB_pass = "password"; | |
$DB_name = "DatabaseName"; | |
$this->DB_con = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass); | |
$this->DB_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | |
} catch (PDOException $e) { | |
echo $e->getMessage(); | |
} | |
} | |
function checkLevel($session){ | |
try{ | |
$stmt=$this->DB_con->prepare("select level from sessionlevels where sessionId =:sLevel"); | |
$stmt->bindParam(':sLevel',$session); | |
$stmt->execute(); | |
return $stmt->fetch(PDO::FETCH_ASSOC)['level']; | |
}catch(Exception $e){ | |
$e->getMessage(); | |
} | |
} | |
function getPhone($session){ | |
try{ | |
$stmt=$this->DB_con->prepare("select phonenumber from sessionlevels where sessionId =:session"); | |
$stmt->bindParam(':session',$session); | |
$stmt->execute(); | |
return $stmt->fetch(PDO::FETCH_ASSOC)['phonenumber']; | |
}catch(Exception $e){ | |
$e->getMessage(); | |
} | |
} | |
function insertLevel($sessionId,$phoneNumber,$level){ | |
try{ | |
$stmt=$this->DB_con->prepare("INSERT INTO sessionlevels(sessionId,phoneNumber,level) VALUES(:session,:phone,:level)"); | |
$stmt->bindParam(':session',$sessionId); | |
$stmt->bindParam(':phone',$phoneNumber); | |
$stmt->bindParam(':level',$level); | |
return $stmt->execute(); | |
}catch (Exception $e){ | |
$e->getMessage(); | |
} | |
} | |
function insertInfo($phoneNumber, $names, $loanTime, $date){ | |
try{ | |
$stmt = $this->DB_con->prepare("INSERT INTO userInfo(phonenumber,names,loanTime,regdate) VALUES(:phonenumber,:names,:loanTime,:date)"); | |
$stmt ->bindParam(':phonenumber',$phoneNumber); | |
$stmt ->bindParam(':names',$names); | |
$stmt ->bindParam(':loanTime',$loanTime); | |
$stmt ->bindParam(':date',$date); | |
return $stmt->execute(); | |
} | |
catch(Exception $e){ | |
$e->getMessage(); | |
} | |
} | |
function updateLevel($sessionId,$newLevel){ | |
try{ | |
$stmt=$this->DB_con->prepare("UPDATE sessionlevels SET level=:level where sessionId=:sessionId"); | |
$stmt->bindParam(':sessionId',$sessionId); | |
$stmt->bindParam(':level',$newLevel); | |
return $stmt->execute(); | |
}catch (Exception $e){ | |
$e->getMessage(); | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment