Insert data

21.29 0 Comments A+ a-

$conn = odbc_connect('sqlserver', 'osd', 'osd');
if (!$conn) {
die('Koneksi ke SQL Server via ODBC gagal: ' . mysql_errormsg());
}
echo 'Koneksi ke SQL Server via ODBC sukses !!'; echo "
";

$ftoday = gmdate("m/d/Y", time() + 60*60*7);
$fyesterday = gmdate("m/d/Y", time()+ (60*60*7)- 86400);
$ftanggal = gmdate("m/d/Y",time()+60*60*7);
$fwaktu = gmdate("m/d/Y H:i:s A",time()+60*60*7);

$fhari=date('w');
  switch($fhari){       
  case 0 : {
    $fhari='Minggu';
    } break;
  case 1 : {
    $fhari='Senin';
    }break;
  case 2 : {
    $fhari='Selasa';
    }break;
  case 3 : {
    $fhari='Rabu';
    }break;
  case 4 : {
    $fhari='Kamis';
    }break;
  case 5 : {
    $fhari="Jum'at";
    }break;
  case 6 : {
    $fhari='Sabtu';
    }break;
  default: {
    $fhari='UnKnown';
    }break;
  }

$fkejadian = "Laporan suhu DC";
$ftindakan = "ok";
$flokasi = "DC";
$fiduser = "syspc";
$finitial = "PC";
$ftim = "otoPC";

$fjam = gmdate("H",time()+60*60*7);
$fmnt = gmdate("i",time()+60*60*7);
$fdtk = gmdate("s",time()+60*60*7);

$fwaktu1s = "07:30:01";
$fwaktu1e = "16:00:00";
$fwaktu2s = "16:00:01";
$fwaktu2e = "22:00:00";
$fwaktu3s = "22:00:01";
$fwaktu3mid1 = "23:59:59";
$fwaktu3mid2 = "00:00:00";
$fwaktu3e = "07:30:00";
$fshift = "";
$ftglpros = $ftoday;

if ($fwaktu >= $fwaktu1s and $fwaktu <= $fwaktu1e) {
  $fshift = "1";
} elseif ($fwaktu >= $fwaktu2s and $fwaktu <= $fwaktu2e) {
  $fshift = "2";
} elseif ($fwaktu >= $fwaktu3s and $fwaktu <= $fwaktu3mid1) {
  $fshift = "3";
} elseif ($fwaktu >= $fwaktu3mid2 and $fwaktu <= $fwaktu3e) {
  $fshift = "3";
  $ftglpros = $fyesterday;
}

/* run insert */
/* example : $stmt = odbc_prepare($conn, "INSERT INTO tt (tanggal, jam, laporan) VALUES('$tanggal', '$jam', '$laporan');" ); */

$stmt = odbc_prepare($conn, "insert into LAPORAN (tanggal, waktu, hari, wktkejadian, kejadian, tindaklanjut, lokasi, iduser, initial, tim, shift, tglpros) VALUES('$ftanggal', '$fwaktu', '$fhari', '$fwaktu', '$fkejadian', '$ftindakan', '$flokasi', '$fiduser', '$finitial', '$ftim', '$fshift', '$ftglpros');" );

/* check for errors */
if (!odbc_execute($stmt)) {
    /* error  */
    echo "o... owww...";
}

odbc_close($conn);
?>

Prepare data

21.28 0 Comments A+ a-




  Display suhu Data Center
 





$ftoday = gmdate("m/d/Y", time() + 60*60*7);
$fyesterday = gmdate("m/d/Y", time()+ (60*60*7)- 86400);
$ftanggal = gmdate("m/d/Y",time()+60*60*7);
$fwaktu = gmdate("m/d/Y H:i:s A",time()+60*60*7);

$fhari=date('w');
  switch($fhari){       
  case 0 : {
    $fhari='Minggu';
    } break;
  case 1 : {
    $fhari='Senin';
    }break;
  case 2 : {
    $fhari='Selasa';
    }break;
  case 3 : {
    $fhari='Rabu';
    }break;
  case 4 : {
    $fhari='Kamis';
    }break;
  case 5 : {
    $fhari="Jum'at";
    }break;
  case 6 : {
    $fhari='Sabtu';
    }break;
  default: {
    $fhari='UnKnown';
    }break;
  }

$fkejadian = "Laporan suhu DC";
$ftindakan = "ok";
$flokasi = "DC";
$fiduser = "syspc";
$finitial = "PC";
$ftim = "otoPC";

$fjam = gmdate("H",time()+60*60*7);
$fmnt = gmdate("i",time()+60*60*7);
$fdtk = gmdate("s",time()+60*60*7);

$my_time = date('h:i:s',time());
$seconds2add = 5;

$new_time= strtotime($my_time);
$new_time+=$seconds2add;

echo $ftanggal;
echo "
";
echo "
";

echo "Jam : " . $fjam;
echo "
";
echo "Menit : " . $fmnt;
echo "
";
echo "Detik : " . $fdtk;
echo "
";
echo "
";

$fwaktu1s = "07:30:01";
$fwaktu1e = "16:00:00";
$fwaktu2s = "16:00:01";
$fwaktu2e = "22:00:00";
$fwaktu3s = "22:00:01";
$fwaktu3mid1 = "23:59:59";
$fwaktu3mid2 = "00:00:00";
$fwaktu3e = "07:30:00";
$fshift = "";
$ftglpros = $ftoday;

if ($fwaktu >= $fwaktu1s and $fwaktu <= $fwaktu1e) {
  $fshift = "1";
} elseif ($fwaktu >= $fwaktu2s and $fwaktu <= $fwaktu2e) {
  $fshift = "2";
} elseif ($fwaktu >= $fwaktu3s and $fwaktu <= $fwaktu3mid1) {
  $fshift = "3";
} elseif ($fwaktu >= $fwaktu3mid2 and $fwaktu <= $fwaktu3e) {
  $fshift = "3";
  $ftglpros = $fyesterday;
}

echo "Tgl Proses : " . $ftanggal;
echo "
";
echo "Waktu Lapor : " . $fwaktu;
echo "
";
echo "Hari : " . $fhari;
echo "
";
echo "Waktu Kejadian : " . $fwaktu;
echo "
";
echo "Kejadian : " . $fkejadian;
echo "
";
echo "Tindakan : " . $ftindakan;
echo "
";
echo "Lokasi : " . $flokasi;
echo "
";
echo "ID User : " . $fiduser;
echo "
";
echo "Initial : " . $finitial;
echo "
";
echo "Tim : " . $ftim;
echo "
";
echo "Shift : " . $fshift;
echo "
";
echo "Tgl Proses : " . $ftglpros;
echo "
";

?>