<?php
$user = "skeffoco_landing";
$pass = "@incorrect";

// print_r($_SERVER);
$server = $_SERVER['HTTP_HOST'];


if ($server == "localhost") {
    $PDO = new PDO('mysql:host=localhost;dbname=map', 'root', '');
  /*
    echo "ok : koneksi ke server aman<br>";
    echo "ok : terhubung ke server pusat<br>";
    echo "server : <b>localhost</b>";
  */
  // echo "tambahkan '?process' di URL untuk memproses";
} else if ($server == "www.skeffo.com" || $server == "skeffo.com") {
    $PDO = new PDO('mysql:host=localhost;dbname=map', $user, $pass);
    /*
    echo "ok : koneksi ke server siap<br>";
    echo "ok : terhubung ke server lokal<br>";
    echo "server : <b>skeffo.com</b>";
    */
} else {
    echo "NOK - galat, terjadi gangguan";
}

if (isset($_GET["process"])) {
  echo "diprosess ... <br>";

  $file = fopen("tabel_kanca_ok.csv","r");

  $array = array();
  while(! feof($file))
    {
    // print_r(fgetcsv($file));
    $data = fgetcsv($file);
    // echo "<br>";
    $hasil = explode(";",$data[0]);

        array_push($array, $hasil);

        /*
    // informasi yang akan di proses
    $nama_tabel = $hasil[3];
    $nama_unit = $hasil[0];
    $alamat_ip = $hasil[1];


    $simpan_data = $PDO->prepare("INSERT INTO " . $hasil[4] . " (`nama_unit_kerja`, `ipadddress`) VALUES (:nama_unit_kerja, :ip_address)");
    if (!$simpan_data) {
      echo "\nPDO::errorInfo():\n";
      print_r($dbh->errorInfo());
    }
    $simpan_data->execute(array(
      "nama_unit_kerja" => $nama_unit,
      "ip_address"      => $alamat_ip
      ));
    // print $simpan_data->errorCode();
    // echo $hasil[4] . " .. tersimpan <br>";
        */
    // next.. proses data $hasil[0] unit, $hasil[1] ip, dan $hasil[4] tabel


    // echo $hasil[4];
    //echo $hasil[0] . " kanca:<br>";
    //echo $hasil[1];

    // print_r($hasil);
    // print_r($data);
    /*
    echo $data[0] . "<br>";
    echo $data[0][2] . "<br>";
    */
    }

  fclose($file);

  /*
  $file = fopen("tabel_kanca_ok.csv","r");
  print_r(fgetcsv($file));
  fclose($file);
  */
}
// oke lancar sejauh ini
// print_r($array);
echo "Total data di proses " . sizeof($array) . "<br>";

for ($i = 0; $i < sizeof($array); $i++) {
    // print_r($array[$i]);
    // echo "<br>";
    echo "INSERT INTO " . $array[$i][4] . " (nama_unit_kerja, ipaddress) VALUES (:nama_unit_kerja, :ipaddress)<br>";
    $simpan_data = $PDO->prepare("INSERT INTO " . $array[$i][4] . " (nama_unit_kerja, ipaddress) VALUES (:nama_unit_kerja, :ipaddress)");
    //$simpan_data = $PDO->prepare("delete from " . $array[$i][4] . "");

    $simpan_data->execute(array(
        "nama_unit_kerja" => $array[$i][0],
        "ipaddress"      => $array[$i][1]
    ));
    echo "data " . $array[$i][0] . " tersimpan! <br><br>";
  print $simpan_data->errorCode();
    echo "<br>";
}

// informasi yang akan di proses
$nama_tabel = $array[4];
$nama_unit = $array[0];
$alamat_ip = $array[1];


echo $nama_tabel[0];
echo $nama_unit[0];
echo $alamat_ip[0];

/*
$simpan_data = $PDO->prepare("INSERT INTO " . $hasil[4] . " (`nama_unit_kerja`, `ipadddress`) VALUES (:nama_unit_kerja, :ip_address)");
if (!$simpan_data) {
    echo "\nPDO::errorInfo():\n";
    print_r($dbh->errorInfo());
}
$simpan_data->execute(array(
    "nama_unit_kerja" => $nama_unit,
    "ip_address"      => $alamat_ip
    ));
// print $simpan_data->errorCode();
// echo $hasil[4] . " .. tersimpan <br>";
*/


?>