moving server source files to server folder
[csql.git] / test / phptests / columninfo.php
blob05dd9f21fcb69d542453b86f4734e62bcaf453a5
1 <html>
2 <body>
3 /*Testing odbc_num_fields for find out the number of fields */
4 <?php
5 $conn=odbc_connect('mycsql','root','manager');
6 if (!$conn)
8 echo "Connection Failed";
9 exit(1);
12 //$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),primary key(f1));");
13 $sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
14 $res = odbc_execute($sth);
15 if (!$res)
17 echo "Error in Creation";
18 exit(2);
20 echo "Table Created\n";
22 $sql = "SELECT * FROM t1";
23 $result = odbc_exec($conn, $sql);
24 $rs = odbc_num_fields($result);
25 if (!$rs)
27 exit(3);
30 echo "\nNumber of Fields = ";
31 echo $rs ;
32 echo "\n";
34 $sth=odbc_prepare($conn,"DROP TABLE t1;");
35 $res = odbc_execute($sth);
36 if (!$res)
37 {exit("\nError in Drop Table");}
38 echo "\nTable Dropped \nTest Passed";
39 odbc_close($conn);
42 </body>
43 </html>