Php Programming Code Examples
Php > Database Related Code Examples
PHP & ADODB
PHP & ADODB
<?php
// COM Object declaration
$cn = new com("ADODB.Connection");
$rs = new com("ADODB.Recordset");
// Open connection from ODBC-Data Source
$cn->open("dsn=perkuliahan");
$sql = "select * from tbl_jurusan";
// Execute query
$rs = $cn->execute($sql);
echo "<table>\n";
while(!$rs->eof){
echo "<tr><td>";
echo $rs->fields[0]->value ." - ".$rs->fields[1]->value;
echo "</td></tr>\n";
$rs->movenext();
}
echo "</table>\n";
?>