test/phptests/odbcfree.php

   1 <html>
   2 <body>
   3 /*Testing Querry Memory Free with odbc_free_result() */
   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),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
  13 $res = odbc_execute($sth);
  14 if (!$res)
  15 {
  16   echo "Error in Creation";
  17   exit(2);
  18 }
  19 echo "Table Created\n";
  20
  21 $sql = 'SELECT f3,f5,f7 FROM t1';
  22 $result = odbc_exec($conn, $sql);
  23 echo "\nFreeing query Memory\n";
  24
  25 $freeing = odbc_free_result($result);
  26 if (!$res)
  27 {
  28   exit(3);
  29 }
  30 echo "Query memory freed\n";
  31
  32 $sth=odbc_prepare($conn,"DROP TABLE t1;");
  33 $res = odbc_execute($sth);
  34 if (!$res)
  35 {
  36   echo "\nError in Drop Table";
  37   exit(4);
  38 }
  39 echo "\nTable Dropped \nTest Passed";
  40 odbc_close($conn);
  41 ?>
  42
  43 </body>
  44 </html>