<?php
class SC_Query {
	var $conn;
    var $option;
    var $where;
    var $groupby;
    var $order;

	//----
	function SC_Query() {
		$objConn = new SQL_DB();
		$this->conn = $objConn;
		$this->where = "";
	}

	//----
    function getCount($table,  $where = "", $order = "", $option = "" ) {
        if(strlen($where) <= 0) {
            $sql = "SELECT COUNT(*) as Total FROM ".DB_PREFIX."$table";
        } else {
            $sql = "SELECT COUNT(*) as Total FROM ".DB_PREFIX."$table WHERE $where";
        }
		$res = $this->conn->sql_query($sql) or $this->conn->sqlError(__FILE__, __LINE__); 
        $arr=$this->conn->sql_fetchassoc($res);
		//print_r($arr);
        return $arr;
    }

	//----
    function getAll( $table, $col,  $where = "", $order = "", $option = "" ) {
		$sql = " SELECT " . ($col) . " FROM ".DB_PREFIX."$table ".( $where ? "WHERE $where" :  "" )." ".($order)." ".($option)."";
		//echo "<pre>".$sql;
 		$res = $this->conn->sql_query($sql) or $this->conn->sqlError(__FILE__, __LINE__); 
		if(  $this->conn->sql_numrows($res) ){
			while ($arr=$this->conn->sql_fetchassoc($res)){
				$arrRet[]= $arr;
			}
			return $arrRet; 
		}
	}

	//----
    function getJoin( $col, $join, $where, $order = "", $option = "" ) {
		$sql = " SELECT " . ($col) . " FROM $join  ".( $where ? "WHERE $where" :  "" )." ".($order)." ".($option).""; 
		//echo $sql; //exit;
		$res = $this->conn->sql_query($sql) or $this->conn->sqlError(__FILE__, __LINE__); 
		if(  $this->conn->sql_numrows($res) ){ 
			while ($arr=$this->conn->sql_fetchassoc($res)){
				$arrRet[]= $arr;
			}
			return $arrRet;
		}
	}			

	//----
    function getOne( $table, $col, $where ) {
		$sql = " SELECT " . ($col) . " FROM ".DB_PREFIX."$table ".($where ? "WHERE $where" :  "")." "; 
		//echo $sql; 
		$res = $this->conn->sql_query($sql) or $this->conn->sqlError(__FILE__, __LINE__); 
		if(  $this->conn->sql_numrows($res) ){
			while ($arr=$this->conn->sql_fetchassoc($res)){
				$arrRet= $arr;
			}
			return $arrRet;
		}
		//echo"<pre>".$sql;
	}

	//----
    function insertData( $table, $arrData =array() ) {		
		$sql = "INSERT INTO ".DB_PREFIX."".$table." (" . implode(', ', array_keys($arrData)) . ") VALUES ('" . implode("', '", $arrData) . "') "; 
		//echo $sql; 
		
		$res = $this->conn->sql_query($sql) or $this->conn->sqlError(__FILE__, __LINE__); 
		if($res){
			return $this->conn->sql_nextid();
		}else{
			return false;
		}
	}			

	//----
    function updateData( $table, $arrData =array(), $where) {
		$i = 0;
		$sql="UPDATE ".DB_PREFIX."".$table." SET ";
		
		foreach ($arrData as $key => $val) 
		{		
			//if($val){
				$sql.=" $key = '$val' ".(count($arrData)-1 != $i ? ", " : " ");
			//}
			$i++;
		}	
		$sql.="WHERE $where";
		//echo $sql."<br>";
	
		$res = $this->conn->sql_query($sql) or $this->conn->sqlError(__FILE__, __LINE__); 
		if($res){
			return $res;
		}
	
	}			
	
	//----
    function deleteData( $table, $where ) {		
		$sql = "DELETE FROM ".DB_PREFIX."".$table." WHERE " . $where . " "; 
 		$res = $this->conn->sql_query($sql) or $this->conn->sqlError(__FILE__, __LINE__); 
		//echo "<pre>".print_r($res);
		if($res){
			$this->conn->sql_query("OPTIMIZE TABLE ".DB_PREFIX."$table") or $this->conn->sqlError(__FILE__, __LINE__); 
			return $res;
		}else{
			return false;
		}
	}		


}
?>