<?php
class database
{
    var $koneksi ;
    var $selectDb;
    var $query ;
    var $result ;
    var $row;
    var $jumlah ;

    function database()
    {
      	$nameSer 	= "127.0.0.1"; //Nama Host
		$username 	= "roothk"; //username Host
		$pass 	= "s3rv3rITh3s2009"; //Passwrod Host
		$dbname 	= "db_androsalesv2"; //Database Name
		$koneksi = mysql_connect($nameSer,$username,$pass)or die('error DB : '.mysql_errno());

      $this->selectDb = mysql_select_db($dbname,$koneksi);
      if ( !$this->selectDb )
      {
        echo "gagal";
      }
    }

    function query($query)//fungsi query
    {
      $this->result = mysql_query($query);
    }
    function tutup()//fungsi query
    {
      mysql_close();
    }
    function tampilkan()//fungsi menampilkan data
    {
      $this->row = mysql_fetch_array($this->result);
      return $this->row;
    }

	function view()//fungsi menampilkan data
    {
      $this->row = mysql_fetch_object($this->result);
      return $this->row;
    }

    function getJumlah()//fungsi menampilkan jumlah data
    {
      $this->jumlah = mysql_num_rows($this->result);
      return $this->jumlah;
    }

	 function get($table)//fungsi select
    {
      $this->result = mysql_query("SELECT * FROM ".$table);
    }

    function getJumlahFromTable($table)
    {
      $this->get($table);
      return $this->getJumlah();
    }

     function insert( $database , $data)//fungsi insert
    {
		$row = array();
		$nilai = array();
		foreach ( $data as $kolom =>$value )
               {
			$row[] = $kolom;
			$nilai[] = "'".$value."'";
		}

		$this->result = $this->query("INSERT INTO ". $database ."(". implode(',' ,$row) .")
						VALUES (". implode(',' , $nilai) .")");

        $tes = "INSERT INTO ". $database ."(". implode(',' ,$row) .")
            VALUES (". implode(',' , $nilai) .")";

            return $tes;
     }

      function update($table , $data , $where)//fungsi update
      {
		foreach ( $data as $kolom => $row )
		{
			$set[]= $kolom."='".$row."'" ;
		}
		$set = implode(',',$set);
		$query = "UPDATE ".$table." SET ".$set." WHERE ".$where ;
		$this->query($query);
	}

	function delete($table , $where)//fungsi delete
	{
		$this->query("DELETE FROM ".$table." WHERE ".$where);
	}

}
	
?>