Driver.php

<?php

class Driver
{
    function __construct()
    {
        try {
            $DB_host = "localhost";
            $DB_user = "username";
            $DB_pass = "password";
            $DB_name = "ussdapp";
            $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 session_levels where session_id =:sLevel");
            $stmt->bindParam(':sLevel',$session);
            $stmt->execute();
            return $stmt->fetch(PDO::FETCH_ASSOC)['level'];
        }catch(Exception $e){
           $e->getMessage();
        }
    }

 
    function insertLevel($sessionId,$phoneNumber,$level){
        try{
            $stmt=$this->DB_con->prepare("INSERT INTO session_levels(session_id,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 updateLevel($sessionId,$newLevel){
        try{
            $stmt=$this->DB_con->prepare("UPDATE session_levels SET level=:level where session_id=:sessionId");
            $stmt->bindParam(':sessionId',$sessionId);
            $stmt->bindParam(':level',$newLevel);
            return $stmt->execute();

        }catch (Exception $e){
            $e->getMessage();
        }
    }

}