Senin, 30 Maret 2015

Sample PHP connect to accdb using ODBC

<?php
$Filename="c:\Users\Setiono\Documents\ptsi.accdb";
$user = "root";
$password = "";
$conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=$Filename", $user, $password) or die("gak bisa konek!!!");
$query = "SELECT * FROM Query1";
$rs = odbc_exec($conn,$query);
$cols = odbc_num_fields($rs);
$rows=odbc_num_rows($rs);

echo "<link href=\"nice-table.css\" rel=\"stylesheet\" type=\"text/css\" />";
echo "<table border=1; class=nice-table>";

// tampilkan field name
    for ($i = 1; $i <= $cols; $i++)
    {
        $n[$i] = odbc_field_name($rs, $i);
        echo "<th>", $n[$i], "</th>";
    }

    while (odbc_fetch_array($rs)){
        echo "<tr>";
        for ($x=1; $x <= $cols; $x++) {
            $fld[$x] = odbc_result($rs,$x);
            echo "<td>", $fld[$x], "</td>";
        }
        echo "</tr>";       
    }
echo "</table>";

odbc_close($conn)

Tidak ada komentar:

Posting Komentar