<?php
class DB {
    //declaring variables
    var $db_host;
    var $db_user;
    var $db_pass;
    var $db_name;

    // set the name of the project folder under root if required
    protected $projectsubfolder = "";

    public $role_admin = 1001;
    public $role_registered = 1002;
    //var $sheffield_imags_folder;
    //the constructor method
    //Online values
    function DB(){
        if ($_SERVER['SERVER_NAME'] == 'localhost')
        {
            $db_host="localhost";
            $db_user="root";
            $db_pass="";
            $db_name="holidayguide";
        }
        else
        {
            $db_host="localhost";
            $db_user="";
            $db_pass="";
            $db_name="holidayguide";
        }

        mysql_connect($db_host, $db_user, $db_pass);
        mysql_select_db($db_name) or die(mysql_error());
    }
    //apply the query and return it
    function query($query) {
        //mysql_query('SET NAMES utf8'); //So important for Arabic Text
        //mysql_query("SET character_set_client=cp1256");
        //mysql_query("SET character_set_connection=cp1256");
        //mysql_query("SET character_set_database=cp1256");
        //mysql_query("SET character_set_results=cp1256");
        //mysql_query("SET character_set_server=cp1256");
        $result = mysql_query($query) or die(mysql_error());
        return $result;
    }
    //retrieve query result in an array and return it
    function fetch_array($result) {
        $array = mysql_fetch_array($result);
        return $array;
    }
    //retrieve query row and return it
    function fetch_row($result) {
        $row = mysql_fetch_row($result);
        return $row;
    }
    //retrieve no of rows for the sent query
    function num_rows($result) {
        $count = mysql_num_rows($result);
        return $count;
    }
    //seek for a specific row
    function seek_row($result,$row_no) {
        $return = mysql_data_seek($result,$row_no);
        return $return;
    }
    //close the connection of the database
    function close() {
        mysql_close();
    }

    // -------------------
    // Session part
    // -------------------

    // Check whether a session is found
    function session_found() {
        if(isset($_SESSION['user']))
            return true;
        return false;
    }

    // unset session
    function session_unset()
    {
        unset($_SESSION['user']);
    }

    // set session for logged-in users
    function session_set($uid,$uname,$role,$fname,$sname,$email,$phone) {
        $arr['userid'] = $uid;
        $arr['username'] = $uname;
        $arr['role'] = $role;
        $arr['firstnames'] = $fname;
        $arr['surname'] = $sname;
        $arr['email'] = $email;
        $arr['phone'] = $phone;

        $_SESSION['user'] = $arr;
    }

    // Get user ID
    function session_get_userid() {
        if ($this->session_found())
        {
            $user = $_SESSION['user'];
            return $user['userid'];
        }
        return null;
    }

    // Get user username
    function session_get_username() {
        if ($this->session_found())
        {
            $user = $_SESSION['user'];
            return $user['username'];
        }
        return null;
    }

    // Get user role
    function session_get_role() {
        if ($this->session_found())
        {
            $user = $_SESSION['user'];
            return $user['role'];
        }
        return null;
    }