test/phptests/paraselect.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   exit(2);
  16 }
  17 echo "Table Created\n";
  18
  19 $res = odbc_exec($conn,"INSERT INTO t1 values(10,'ABCD',1);");
  20 if (!$res)
  21 {
  22   exit(3);
  23 }
  24 echo "Table Created\n";
  25
  26 $res = odbc_exec($conn,"INSERT INTO t1 values(20,'PQRS',2);");
  27 if (!$res)
  28 {
  29   exit(4);
  30 }
  31 echo "Table Created\n";
  32
  33 $sth = 'SELECT * FROM t1;';
  34 $rs = odbc_exec($conn, $sth);
  35 if (!$rs)
  36 {
  37   exit(5);
  38 }
  39 odbc_result_all($rs, 'border = 5');
  40
  41 $q = "SELECT * FROM t1 WHERE f1=?;";
  42 $res = odbc_prepare ($conn, $q);
  43 $a = 10;
  44 $res1 = odbc_execute($res, array($a));
  45 if (!$res)
  46 {
  47   exit(6);
  48 }
  49
  50    echo "<table><tr>";
  51    echo "<th>ROLL</th>";
  52    echo "<th>NAME</th></tr>";
  53    while (odbc_fetch_row($res))
  54    {
  55      $roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($res, 1));
  56      $name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($res, 2));
  57      echo "<tr><td>$roll</td>";
  58      echo "<td>$name</td></tr>\n";
  59    }
  60    echo "</table>";
  61
  62
  63 $sth=odbc_prepare($conn,"DROP TABLE t1;");
  64 $res = odbc_execute($sth);
  65 if (!$res)
  66   {exit("\nError in Drop Table");}
  67 echo "\nTable Dropped \nTest Passed";
  68 odbc_close($conn);
  69 ?>
  70
  71 </body>
  72 </html>