<?php
class Database{

//variable untuk property
  private static $INSTANCE;
  private $mysqli,
          $hostname = "localhost",
          $username = "root",
          $password = "gunawan02",
          $dbname   = "loginOOP";

            ///fungsi yang dijalankan di awal pada saat object dibuat
          public function __construct(){
            $this->mysqli = new mysqli($this->hostname , $this->username , $this->password , $this->dbname);
              if (mysqli_connect_error()) {
                die("cant connect database");
              }
          }


        //singleton pattern , membuat koneksi db tidak berulang" dipanggil
        public static function getInstance(){
          if (!isset ( self::$INSTANCE )) {
            self::$INSTANCE = new Database();
          }
          return self::$INSTANCE;
        }

        //function insert untuk register
        public function insert_table($table , $arr= array()){
          $kolom = implode(",",array_keys($arr));
          $arrayvalue = [];
          $i = 0;
          foreach ($arr as $key => $value) {
            if (is_int($value)) {
              $arrayvalue[$i] = $this->escape($value);
            }else {
              $arrayvalue[$i] = "'".$this->escape($value)."'";
            }
            $i++;
          }
          $value = implode(",",$arrayvalue);
          $query = "INSERT INTO $table($kolom) VALUES ($value)";
          return $this->run_query($query , "error cant connect query");
        }

        //function untuk cek login , atau proses pengecekan login
        public function get_info($table,$kolom,$value){
          if (!is_int($value)) {
            $value = "'".$value."'";
          }
          $query = "SELECT * FROM $table WHERE $kolom = $value";
          $result = $this->mysqli->query($query);

          while ($row = $result->fetch_assoc()) {
            return $row;
          }
        }


/////////////////////////////////////////////////////////////////bagian error//////////////////////////////////////////////
        public function update($table, $fields,  $id)
          {
            //mengambil nilai
            $valueArrays = array();
            $i = 0;

      foreach($fields as $key=>$values){
        if( is_int($values) ){
          $valueArrays[$i] = $key . "=" . $this->escape($values);
        }else{
          $valueArrays[$i] =  $key . "='" . $this->escape($values) . "'";
        }

        $i++;
      }
      $values = implode(",", $valueArrays);

      $query = "UPDATE $table SET $values WHERE id = $id";
      die($query);
      return $this->run_query($query, 'masalah saat mengupdate data');
      }


        //untuk escape string
        public function escape($string){
        return $this->mysqli->real_escape_string(htmlentities($string));
        }

        //membuat error dan run query
        public function run_query($query,$catch){
          if ($this->mysqli->query($query)) return true;
          else die($catch);
        }













}
?>