php: Koneksi ke SQL Server via ODBC

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

$rs=odbc_exec($conn,$sql);

if (!$rs){
    exit("Error in SQL");
}
while (odbc_fetch_row($rs)){
    $col1=odbc_result($rs, "serah");
    $col2=odbc_result($rs, "terima");
    echo "$col1"." - "."$col2"; echo "
";
}

odbc_close($conn);
?>