<?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)
$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