php: insert rec ke mssql over odbc

20.56 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 "
";

$sql="SELECT * from apprv";

$tanggal = "9/20/2012";
$jam = "10:41:03 AM";
$laporan = "first time test insertion";

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

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

odbc_close($conn);
?>