HEX

File: /var/www/html/tmpr/..//tmpr/..//NewsSql.incX.php
<?php
ini_set('error_reporting', E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED);

include('Connections/videoondemand.php');
abstract Class DBSQL
{

    public function _construct()
    {

    }


    public function DBSQL($DBName)
    {
        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;
    }

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

}


Class NewsSQL extends DBSQL
{
   // the constructor
   function NewsSQL($DBName = "")
   {
      $this->DBSQL($DBName);
   }
   
   
          function getmycampaign($view1)
   {  
 
  
				  $sql = "select * from campaign where newsid='$view1'";
				  $result = $this->select($sql);
				   
   return $result;
   
   
      
   }
  

   }
   


?>