test/phptests/columninfo3.php

   1 <html>
   2 <body>
   3 /*Testing odbc_field_type for find out the type of a field    */
   4 <?php
   5 $conn=odbc_connect('mycsql','root','manager');
   6 if (!$conn)
   7 {
   8   echo "Connection Failed";
   9   exit(1);
  10 }
  11
  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)
  16 {
  17   echo "Error in Creation";
  18   exit(2);
  19 }
  20 echo "Table Created\n";
  21
  22 $sql = "SELECT * FROM t1";
  23 $result = odbc_exec($conn, $sql);
  24
  25 echo "\nTesting odbc_field_type() for find out column type\n";
  26 for ($col=1; $col<=odbc_num_fields($result); $col++)
  27 {
  28  $rs = odbc_field_type($result, $col);
  29  if (!$rs)
  30  {
  31    exit(3);
  32  }
  33  printf("Column %d har type  %s\n" ,$col, odbc_field_type($result, $col));
  34 }
  35
  36 $sth=odbc_prepare($conn,"DROP TABLE t1;");
  37 $res = odbc_execute($sth);
  38 if (!$res)
  39   {exit("\nError in Drop Table");}
  40 echo "\nTable Dropped \nTest Passed";
  41 odbc_close($conn);
  42 ?>
  43
  44 </body>
  45 </html>