3 /*Testing odbc_next_result, var_dump for find next result*/
5 $conn=odbc_connect('mycsql','root','manager');
7 {echo "Connection Failed" ; exit(1);}
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);");
18 $result = odbc_exec($conn, $sql);
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";
26 echo "Get second results set\n";
27 var_dump(odbc_next_result($result));
29 $r1 = odbc_fetch_array($result);
30 $r2 = odbc_fetch_array($result);
31 echo "Dump 2nd result set\n";
34 $sth=odbc_prepare($conn,"DROP TABLE t1;");
35 $res = odbc_execute($sth);
37 {echo "\nError in Drop Table";exit(2);}
38 echo "\nTable Dropped \nTest Passed";