test/phptests/uniqueindex.php

   1 <html>
   2 <body>
   3 /*Creating table with 3 INT fields, Create unique index on single field.
   4    Create possible composite unique indexes in different Combinations
   5 */
   6 <?php
   7 $conn=odbc_connect('mycsql','root','manager');
   8 if (!$conn)
   9 {
  10   echo "Connection Failed";
  11   exit(1);
  12 }
  13
  14 $sth = odbc_prepare($conn,"create table t1 (f1 int ,f2 int,f3 int );");
  15 $res = odbc_execute($sth);
  16 if (!$res)
  17 {
  18   echo "Error in Table Creation";
  19   exit(2);
  20 }
  21 echo "Table Created";
  22
  23 $sth = odbc_prepare($conn, "create index idx1 on t1(f1) unique;");
  24 $res = odbc_execute($sth);
  25 if (!$res)
  26 {
  27   echo "Error in index";
  28   exit(3);
  29 }
  30 echo "\ncreate index idx1 on t1(f1) unique;";
  31 echo "\nIndex created\n";
  32
  33 $sth = odbc_prepare($conn, "create index idx2 on t1(f1,f2)  unique;");
  34 $res = odbc_execute($sth);
  35 if (!$res)
  36 {
  37    echo "\ncreate index idx1 on t1(f1) unique;";
  38    exit(4);
  39 }
  40 echo "\ncreate index idx2 on t1(f1,f2) unique;";
  41 echo "\nComposite key Index created\n";
  42
  43 $sth = odbc_prepare($conn, "create index idx5 on t1(f1,f2,f3) unique;");
  44 $res = odbc_execute($sth);
  45 if (!$res)
  46 {
  47    echo "\nError in index creation;";
  48    exit(5);
  49 }
  50 echo "\ncreate index idx5 on t1(f1,f2,f3) unique;";
  51 echo "\nComposite key Index created\n";
  52
  53 $res = odbc_exec($conn, "DROP TABLE t1;");
  54 if (!$res)
  55 {
  56    echo "\ncError in drop table;";
  57    exit(6);
  58 }
  59 echo "\nTable Dropped\nTest Passed";
  60 odbc_close($conn);
  61 ?>
  62
  63 </body>
  64 </html>
  65