01.<?php
02.$db = 'c:\\repmain\\data\\';
03.$dsn = "Driver={Microsoft Visual Foxpro Driver};SourceType=DBF;SourceDB=$db";
04.
05.$cn = odbc_connect($dsn,'','') or die("ติดต่อฐานข้อมูลไม่ได้");
06.$sql = 'SELECT * FROM pt ';
07.$rs = odbc_exec($cn,$sql) or die("รัน SQL ไม่ผ่าน");
08.if ($rs) {
09.echo "Rs Complete";
10.} else {
11.echo "Rs Not Complete";
12.}
13.echo "<br>";
14.
15.echo "<table border=1>";
16.$fields = odbc_num_fields($rs);
17.while( odbc_fetch_row($rs) ) {
18.echo "<tr>";
19.for ($j=1; $j < $fields+1; $j++) {
20. echo "<td>". odbc_result($rs, $j) . "</td>";
21.}
22.echo "</tr>";
23.}
24.echo "</table>";
25.odbc_close($cn);
26.?>
Quote:
