php: insert rec ke mssql over odbc
$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);
?>