HEX

File: /var/www/html/tmpr/..//tmpr/..//DbSql.inc.php
<?php
//ini_set('error_reporting', E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED);
include("const.inc.php");


function page_protect() {


}
function lor($string, $key) {
    $result = "";
    for($i=0; $i<strlen($string); $i++) {
        $char = substr($string, $i, 1);
        $keychar = substr($key, ($i % strlen($key))-1, 1);
        $char = chr(ord($char)+ord($keychar));
        $result.=$char;
    }
    return base64_encode($result);
}
function yaw($string, $key) {
    $result = "";
    $string = base64_decode($string);
    for($i=0; $i<strlen($string); $i++) {
        $char = substr($string, $i, 1);
        $keychar = substr($key, ($i % strlen($key))-1, 1);
        $char = chr(ord($char)-ord($keychar));
        $result.=$char;
    }
    return $result;
}

function makecomma($input)
{
    // This function is written by some anonymous person - I got it from Google
    if(strlen($input)<=2)
    { return $input; }
    $length=substr($input,0,strlen($input)-2);
    $formatted_input = makecomma($length).",".substr($input,-2);
    return $formatted_input;
}

function india($num){
    // This is my function
    $pos = strpos((string)$num, ".");
    if ($pos === false) { $decimalpart="00";}
    else { $decimalpart= substr($num, $pos+1, 2); $num = substr($num,0,$pos); }

    if(strlen($num)>3 & strlen($num) <= 12){
        $last3digits = substr($num, -3 );
        $numexceptlastdigits = substr($num, 0, -3 );
        $formatted = makecomma($numexceptlastdigits);
        $stringtoreturn = $formatted.",".$last3digits ;
    }elseif(strlen($num)<=3){
        $stringtoreturn = $num;
    }elseif(strlen($num)>12){
        $stringtoreturn = number_format($num, 2);
    }

    if(substr($stringtoreturn,0,2)=="-,"){$stringtoreturn = "-".substr($stringtoreturn,2 );}

    return $stringtoreturn;
}



function EncodeURL($url)
{
    $new = strtolower(ereg_replace(' ','_',$url));
    return($new);
}

function DecodeURL($url)
{
    $new = ucwords(ereg_replace('_',' ',$url));
    return($new);
}

function ChopStr($str, $len)
{
    if (strlen($str) < $len)
        return $str;

    $str = substr($str,0,$len);
    if ($spc_pos = strrpos($str," "))
        $str = substr($str,0,$spc_pos);

    return $str . "...";
}

class DBSQL
{



    // Constructor
    public function __construct(){
        $DBHost = DBHostX;
        $DBName = DBNameX;
        $DBUser = DBUserX;
        $DBPassword = DBPasswordX;

        $conn = mysqli_connect($DBHost,$DBUser,$DBPassword,$DBName);
        /*$conn=mysql_connect($DBHost,$DBUser,$DBPassword);
        mysql_select_db($DBName,$conn); */
        $this->CONN = $conn;
        return true;
    }

    public function select($sql="")
    {
        if (empty($sql)) return false;
        if (empty($this->CONN)) return false;
        $conn = $this->CONN;
        $results = mysqli_query($conn,$sql);
        if ((!$results) or (empty($results)))
        {
            return false;
        }
        $count = 0;
        $data = array();
        while ($row = mysqli_fetch_array($results)) {
            $data[$count] = $row;
            $count++;
        }
        mysqli_free_result($results);
        return $data;
    }


    public function insert($sql="")
    {
        if (empty($sql)) return false;
        if (empty($this->CONN)) return false;

        $conn = $this->CONN;
        $results = mysqli_query($conn,$sql);
        if (!$results) return false;
        $results = mysqli_insert_id($this->CONN);
        return $results;
    }


    public function update($sql="")
    {
        if(empty($sql)) return false;
        if(empty($this->CONN)) return false;

        $conn = $this->CONN;
        $result = mysqli_query($conn,$sql);
        return $result;
    }


    public function delete($sql="")
    {
        if(empty($sql)) return false;
        if(empty($this->CONN)) return false;

        $conn = $this->CONN;
        $result = mysqli_query($conn,$sql);
        return $result;
    }

    public function createtable($sql="")
    {
        if(empty($sql)) return false;
        if(empty($this->CONN)) return false;

        $conn = $this->CONN;
        $result = mysqli_query($conn,$sql);
        return $result;
    }

    public function droptable($sql="")
    {
        if(empty($sql)) return false;
        if(empty($this->CONN)) return false;

        $conn = $this->CONN;
        $result = mysqli_query($conn,$sql);
        return $result;
    }

    public function createindex($sql="")
    {
        if(empty($sql)) return false;
        if(empty($this->CONN)) return false;

        $conn = $this->CONN;
        $result = mysqli_query($conn,$sql);
        return $result;
    }

    public function dropindex($sql="")
    {
        if(empty($sql)) return false;
        if(empty($this->CONN)) return false;

        $conn = $this->CONN;
        $result = mysqli_query($conn,$sql);
        return $result;
    }


    // Declare  properties
    public $length = 0;
    public $width = 0;

    // Method to get the perimeter
    public function getPerimeter(){
        return (2 * ($this->length + $this->width));
    }

    // Method to get the area
    public function getArea(){
        return ($this->length * $this->width);
    }
}
?>