mysql dengan oop php

<?php
class mysql{
  private $host;
  private $user;
  private $pass;
  private $db;
  private $query;
  private $result;
  private $row;
  private $dataset;
  private $num_row;

  function __construct($host,$user,$pass,$db){
      $this->host=$host;
      $this->user=$user;
      $this->pass=$pass;
      $this->database=$db;
  }

  function koneksi(){
      $this->kon=mysql_connect($this->host,$this->user,$this->pass);
      mysql_select_db($this->database,$this->kon) or die (mysql_error());
  }

  function execute($query){
      $this->query=$query;
      $this->result=mysql_query($query,$this->kon);
  }

  function get_row(){
      if($this->row=mysql_fetch_array($this->result))
          return $this->row;
      else
          return false;
  }
}
$mysql= new mysql("localhost","root","","pju");
$mysql->koneksi();
$mysql->execute("select * from tiangpju");
while($r=$mysql->get_row()){
  echo $r["kdtiangpju"]."<br>";
}
?>