PHP 開 dbf

<?php $cfg_dsn = "Driver={Microsoft Visual FoxPro Driver};SourceType=dbf;sourcedb=C:\;BackgroundFetch=yes"; $cfg_dsn_login = ""; $cfg_dsn_mdp = ""; $conn = odbc_connect($cfg_dsn,$cfg_dsn_login,$cfg_dsn_mdp); $sql = "SELECT * FROM trn_bat.dbf "; $exec = odbc_exec ($conn,$sql); //取得欄位的數目 $n=odbc_num_fields($exec); echo '<table border="1">'. " <tr>\n"; for($i=1;$i<=$n;$i++){ echo " <td>".odbc_field_name($exec,$i)."</td>\n"; } echo " </tr> \n"; while( odbc_fetch_row( $exec ) ){ $num_row++; echo " <tr>\n"; for($i=1;$i<$n;$i++){ echo " <td>".odbc_result( $exec, $i )."</td>\n"; } echo " </tr> \n"; } echo "</table> "; /* while($row = odbc_fetch_array($exec)) { echo $row['ioseq']; echo "<hr/>"; }*/ ?>