HEX

File: /var/www/html/bbb.php
<?php

include('Connections/videoondemand.php');




class DBSQL {



    public function __construct() {

        global $DBHost,$DBUser,$DBPassword;


        global $DBHost,$DBUser,$DBPassword;

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

    }


    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;
    }


    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;
    }


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

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


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

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

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

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

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

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

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

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

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

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



}

// Strawberry is inherited from Fruit
class NewsSQL extends DBSQL {
    // the constructor

    public   function getmycampaign()
    {


        $sql = "select * from campaign";
        $result = $this->select($sql);

        return $result;



    }
    public function message() {
        echo "Am I a fruit or a berry? ";
    }
}



$db = new NewsSQL();
$campign = $db->getmycampaign();
print_r($campign)


?>