1 <?php
2 // SourceDB=D:/foxprodb; 数据库目录
3 $dsn = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=D:/foxprodb;Exclusive=NO;collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;";
4 $conn = odbc_connect( $dsn, "", "") ;
5
6 // $sql = "select * from 销售表 WHERE `编号` = '10162972'";
7 // $sql = iconv( 'utf-8', 'gb2312', $sql );
8 // $result_id = odbc_exec( $conn, $sql );
9
10 // while ( $arr = odbc_fetch_array( $result_id ) ) {
11 // print_r( $arr );
12 // }
13
14 $sql = "insert into zba VALUES( '9', '9' )";
15 $sql = iconv( 'utf-8', 'gb2312', $sql );
16 $result_id = odbc_exec( $conn, $sql );
17
18 echo odbc_num_rows( $result_id );
19 ?>
