test/phptests/primarytest.php

   1 <html>
   2 <body>
   3 /* Creating table with Primary key constraint constraint on the int field
   4    check basic INSERT, SELECT */
   5 <?php
   6 $conn=odbc_connect('mycsql','root','manager');
   7 if (!$conn)
   8 {
   9   echo "Connection Failed";
  10   exit(1);
  11 }
  12
  13 $sth = odbc_prepare($conn,"create table t1 (f1 int , f2 int, primary key(f1));");
  14 $res = odbc_execute($sth);
  15 if (!$res)
  16 {
  17   echo "Error in Creation";
  18   exit(2);
  19 }
  20 echo "Table Created";
  21
  22 $sth = odbc_prepare($conn, "insert into t1 values (10, 20);");
  23 $res = odbc_execute($sth);
  24 if (!$res)
  25 {
  26   echo "Error in Insertion";
  27   exit(3);
  28 }
  29 echo "\nRecord Inserted\n";
  30
  31 $res = odbc_exec($conn, "insert into t1 values (10, 30);");
  32
  33 $sth = 'select * from t1;';
  34 $rs = odbc_exec($conn, $sth);
  35 if (!$rs)
  36 {
  37   echo "Error in SQL-2";
  38   exit(4);
  39 }
  40 echo "\nselect executed\n";
  41 odbc_result_all($rs);
  42
  43 $sth=odbc_prepare($conn,"DROP TABLE t1;");
  44 $res = odbc_execute($sth);
  45 if (!$res)
  46 {
  47   echo "\nError in Drop Table";
  48   exit(5);
  49 }
  50 echo "\nTable Dropped\nTest Passed\n";
  51 odbc_close($conn);
  52 ?>
  53 </body>
  54 </html>
  55