test/phptests/odbc_fetch_array1.php

   1 <html>
   2 <body>
   3 /*Testing  odbc_next_result, var_dump  for find next result*/
   4 <?php
   5 $conn=odbc_connect('mycsql','root','manager');
   6 if (!$conn)
   7   {echo "Connection Failed" ; exit(1);}
   8
   9
  10 odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 int);");
  11 odbc_exec($conn,"INSERT INTO t1 values(10,'ABCD',1);");
  12 odbc_exec($conn,"INSERT INTO t1 values(20,'PQRS',2);");
  13
  14 $sql = <<<END_SQL
  15 SELECT * from t1;
  16 END_SQL;
  17
  18 $result = odbc_exec($conn, $sql);
  19
  20 echo "Get First results set\n";
  21 $r1 = odbc_fetch_array($result);
  22 $r2 = odbc_fetch_array($result);
  23 echo "Dump first result set\n";
  24 var_dump($r1, $r2);
  25
  26 echo "Get second results set\n";
  27 var_dump(odbc_next_result($result));
  28
  29 $r1 = odbc_fetch_array($result);
  30 $r2 = odbc_fetch_array($result);
  31 echo "Dump 2nd result set\n";
  32 var_dump($r1, $r2);
  33
  34 $sth=odbc_prepare($conn,"DROP TABLE t1;");
  35 $res = odbc_execute($sth);
  36 if (!$res)
  37   {echo "\nError in Drop Table";exit(2);}
  38 echo "\nTable Dropped \nTest Passed";
  39 odbc_close($conn);
  40 ?>
  41
  42 </body>
  43 </html>