Php > Database Related

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