test/phptests/paradelete.php

   1 <html>
   2 <body>
   3 /*Parateterised delete*/
   4 <?php
   5 $conn=odbc_connect('mycsql','root','manager');
   6 if (!$conn)
   7 {
   8   echo "Connection Failed";
   9   exit(1);
  10 }
  11
  12 $res = odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 int);");
  13 if (!$res)
  14 {
  15   echo "Error in Creation";
  16   exit(2);
  17 }
  18 echo "Table Created\n";
  19
  20 $res = odbc_exec($conn,"INSERT INTO t1 values(10,'ABCD',1);");
  21 if (!$res)
  22 {
  23   echo "Error in Creation";
  24   exit(3);
  25 }
  26 echo "Table Created\n";
  27
  28 $res = odbc_exec($conn,"INSERT INTO t1 values(20,'PQRS',2);");
  29 if (!$res)
  30 {
  31   echo "Error in Creation";
  32   exit(4);
  33 }
  34 echo "Table Created\n";
  35
  36 $sth = 'SELECT * FROM t1;';
  37 $rs = odbc_exec($conn, $sth);
  38 if (!$rs)
  39 {
  40   echo "Error in SQL-2";
  41   exit(5);
  42 }
  43 odbc_result_all($rs, 'border = 5');
  44
  45 $q = "DELETE FROM t1 WHERE f1=?;";
  46 $res = odbc_prepare ($conn, $q);
  47 $a = 10;
  48 $exc = odbc_execute($res, array($a));
  49 if (!$rs)
  50 {
  51   exit(6);
  52 }
  53
  54 $sth = 'SELECT * FROM t1;';
  55 $rs = odbc_exec($conn, $sth);
  56 if (!$rs)
  57   {exit("Error in SQL-2");}
  58 odbc_result_all($rs, 'border = 5');
  59
  60 $sth=odbc_prepare($conn,"DROP TABLE t1;");
  61 $res = odbc_execute($sth);
  62 if (!$res)
  63   {exit("\nError in Drop Table");}
  64 echo "\nTable Dropped \nTest Passed";
  65 odbc_close($conn);
  66 ?>
  67
  68 </body>
  69 </html>