Insert data
$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);
?>