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);
?>