test/phptests/odbc_statistics.php

   1 <html>
   2 <body>
   3 /*Testing  odbc_statistics()*/
   4 <?php
   5 $conn=odbc_connect('mycsql','root','manager');
   6 if (!$conn)
   7 {
   8   echo "Connection Failed ";
   9   exit(1);
  10 }
  11
  12 odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT);");
  13 odbc_exec($conn,"INSERT INTO t1(f1,f3,f4) values(10,'ABCD',100001);");
  14 odbc_exec($conn,"INSERT INTO t1(f1,f2,f3) values(20,'BCAD',1);");
  15
  16 $result = odbc_statistics($conn,"test","","t1",0,0);
  17 odbc_result_all($result);
  18 if (!$conn)
  19 {
  20   exit(2);
  21 }
  22
  23 $sth=odbc_prepare($conn,"DROP TABLE t1;");
  24 $res = odbc_execute($sth);
  25 if (!$res)
  26   {exit("\nError in Drop Table");}
  27 echo "\nTable Dropped \nTest Passed";
  28 odbc_close($conn);
  29 ?>
  30
  31 </body>
  32 </html>