From 30ed040585f6497dcbdfe8b204643a819aad2d8f Mon Sep 17 00:00:00 2001
From: prabatuty <prabatuty>
Date: Sat, 6 Nov 2010 06:00:14 +0000
Subject: [PATCH] adding test scripts

---
 test/phptests/autocommit_rollback_commit.php | 113 +++++++++++++
 test/phptests/autoincrement.php              |  85 ++++++++++
 test/phptests/columninfo.php                 |  43 +++++
 test/phptests/columninfo1.php                |  42 +++++
 test/phptests/columninfo2.php                |  46 +++++
 test/phptests/columninfo3.php                |  45 +++++
 test/phptests/columninfo4.php                |  45 +++++
 test/phptests/contest.php                    |  14 ++
 test/phptests/csql.conf                      | 104 ++++++++++++
 test/phptests/datatype.php                   | 240 +++++++++++++++++++++++++++
 test/phptests/datatypeinfo.php               |  29 ++++
 test/phptests/default.php                    |  64 +++++++
 test/phptests/dml.php                        | 104 ++++++++++++
 test/phptests/dropindextest.php              |  67 ++++++++
 test/phptests/index1.php                     |  66 ++++++++
 test/phptests/index2.php                     |  87 ++++++++++
 test/phptests/mysqlwqtest26.php              | 159 ++++++++++++++++++
 test/phptests/nulltest.php                   |  67 ++++++++
 test/phptests/odbc_error.php                 |  47 ++++++
 test/phptests/odbc_fetch_array.php           |  32 ++++
 test/phptests/odbc_fetch_array1.php          |  43 +++++
 test/phptests/odbc_result_all.php            |  64 +++++++
 test/phptests/odbc_statistics.php            |  32 ++++
 test/phptests/odbcfree.php                   |  44 +++++
 test/phptests/paradelete.php                 |  69 ++++++++
 test/phptests/parainsert.php                 |  47 ++++++
 test/phptests/paraselect.php                 |  72 ++++++++
 test/phptests/paraupdate.php                 |  51 ++++++
 test/phptests/primarytest.php                |  55 ++++++
 test/phptests/rowinfo.php                    |  76 +++++++++
 test/phptests/test001.ksh                    |  17 ++
 test/phptests/test002.ksh                    |  17 ++
 test/phptests/test003.ksh                    |  17 ++
 test/phptests/test004.ksh                    |  17 ++
 test/phptests/test005.ksh                    |  17 ++
 test/phptests/test006.ksh                    |  17 ++
 test/phptests/test007.ksh                    |  17 ++
 test/phptests/test008.ksh                    |  17 ++
 test/phptests/test009.ksh                    |  17 ++
 test/phptests/test010.ksh                    |  17 ++
 test/phptests/test011.ksh                    |  18 ++
 test/phptests/test012.ksh                    |  18 ++
 test/phptests/test013.ksh                    |  17 ++
 test/phptests/test014.ksh                    |  17 ++
 test/phptests/test015.ksh                    |  17 ++
 test/phptests/test016.ksh                    |  17 ++
 test/phptests/test017.ksh                    |  17 ++
 test/phptests/test018.ksh                    |  18 ++
 test/phptests/test019.ksh                    |  17 ++
 test/phptests/test020.ksh                    |  17 ++
 test/phptests/test021.ksh                    |  18 ++
 test/phptests/test022.ksh                    |  18 ++
 test/phptests/test023.ksh                    |  18 ++
 test/phptests/test024.ksh                    |  18 ++
 test/phptests/test025.ksh                    |  17 ++
 test/phptests/test026.ksh                    |  17 ++
 test/phptests/test027.ksh                    |  17 ++
 test/phptests/test028.ksh                    |  17 ++
 test/phptests/test029.ksh                    |  17 ++
 test/phptests/test030.ksh                    |  17 ++
 test/phptests/uniqueindex.php                |  65 ++++++++
 test/phptests/uniqueindex2.php               |  87 ++++++++++
 62 files changed, 2721 insertions(+)
 create mode 100644 test/phptests/autocommit_rollback_commit.php
 create mode 100644 test/phptests/autoincrement.php
 create mode 100644 test/phptests/columninfo.php
 create mode 100644 test/phptests/columninfo1.php
 create mode 100644 test/phptests/columninfo2.php
 create mode 100644 test/phptests/columninfo3.php
 create mode 100644 test/phptests/columninfo4.php
 create mode 100644 test/phptests/contest.php
 create mode 100644 test/phptests/csql.conf
 create mode 100644 test/phptests/datatype.php
 create mode 100644 test/phptests/datatypeinfo.php
 create mode 100644 test/phptests/default.php
 create mode 100644 test/phptests/dml.php
 create mode 100644 test/phptests/dropindextest.php
 create mode 100644 test/phptests/index1.php
 create mode 100644 test/phptests/index2.php
 create mode 100644 test/phptests/mysqlwqtest26.php
 create mode 100644 test/phptests/nulltest.php
 create mode 100644 test/phptests/odbc_error.php
 create mode 100644 test/phptests/odbc_fetch_array.php
 create mode 100644 test/phptests/odbc_fetch_array1.php
 create mode 100644 test/phptests/odbc_result_all.php
 create mode 100644 test/phptests/odbc_statistics.php
 create mode 100644 test/phptests/odbcfree.php
 create mode 100644 test/phptests/paradelete.php
 create mode 100644 test/phptests/parainsert.php
 create mode 100644 test/phptests/paraselect.php
 create mode 100644 test/phptests/paraupdate.php
 create mode 100644 test/phptests/primarytest.php
 create mode 100644 test/phptests/rowinfo.php
 create mode 100755 test/phptests/test001.ksh
 create mode 100755 test/phptests/test002.ksh
 create mode 100755 test/phptests/test003.ksh
 create mode 100755 test/phptests/test004.ksh
 create mode 100755 test/phptests/test005.ksh
 create mode 100755 test/phptests/test006.ksh
 create mode 100755 test/phptests/test007.ksh
 create mode 100755 test/phptests/test008.ksh
 create mode 100755 test/phptests/test009.ksh
 create mode 100755 test/phptests/test010.ksh
 create mode 100755 test/phptests/test011.ksh
 create mode 100755 test/phptests/test012.ksh
 create mode 100755 test/phptests/test013.ksh
 create mode 100755 test/phptests/test014.ksh
 create mode 100755 test/phptests/test015.ksh
 create mode 100755 test/phptests/test016.ksh
 create mode 100755 test/phptests/test017.ksh
 create mode 100755 test/phptests/test018.ksh
 create mode 100755 test/phptests/test019.ksh
 create mode 100755 test/phptests/test020.ksh
 create mode 100755 test/phptests/test021.ksh
 create mode 100755 test/phptests/test022.ksh
 create mode 100755 test/phptests/test023.ksh
 create mode 100755 test/phptests/test024.ksh
 create mode 100755 test/phptests/test025.ksh
 create mode 100755 test/phptests/test026.ksh
 create mode 100755 test/phptests/test027.ksh
 create mode 100755 test/phptests/test028.ksh
 create mode 100755 test/phptests/test029.ksh
 create mode 100755 test/phptests/test030.ksh
 create mode 100644 test/phptests/uniqueindex.php
 create mode 100644 test/phptests/uniqueindex2.php

diff --git a/test/phptests/autocommit_rollback_commit.php b/test/phptests/autocommit_rollback_commit.php
new file mode 100644
index 00000000..fec313b2
--- /dev/null
+++ b/test/phptests/autocommit_rollback_commit.php
@@ -0,0 +1,113 @@
+<html>
+<body>
+/*Testing Autocommit, Commit and rollback */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$ss = odbc_autocommit($conn,FALSE);
+if (!$ss)
+{
+  $sth=odbc_prepare($conn,"DROP TABLE t1;");
+  $res = odbc_execute($sth);
+  exit(3);
+}
+
+$query1 = "INSERT INTO t1(f1,f3,f4) values(10,'ABCD',100001);";
+$query2 = "INSERT INTO t1(f1,f2,f3) values(20,'BCAD',1);";
+
+$ErrorCount = 0;
+//if odbc_exec fails it will increment the $ErrorCount
+$result1 = odbc_exec($conn,$query1) or $ErrorCount++;
+if (!$result1)
+{
+  $sth=odbc_prepare($conn,"DROP TABLE t1;");
+  $res = odbc_execute($sth);
+  exit(4);
+}
+
+$result2 = odbc_exec($conn,$query2) or $ErrorCount++;
+if (!$result2)
+{
+  $sth=odbc_prepare($conn,"DROP TABLE t1;");
+  $res = odbc_execute($sth);
+  exit(5);
+}
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  $sth=odbc_prepare($conn,"DROP TABLE t1;");
+  $res = odbc_execute($sth);
+  exit(6);
+}
+odbc_result_all($rs, 'border = 2');
+
+//checking for errors, commit if none, rollback else
+if($ErrorCount == 0)
+{
+    $res = odbc_commit($conn);
+    if (!$res)
+    {
+      $sth=odbc_prepare($conn,"DROP TABLE t1;");
+      $res = odbc_execute($sth);
+      exit(7);
+    }
+    echo "Transaction successful\n";
+}
+else
+{
+    $res = odbc_rollback($conn);
+    if (!$res)
+    {
+      $sth=odbc_prepare($conn,"DROP TABLE t1;");
+      $res = odbc_execute($sth);
+      exit(8);
+    }
+    echo "there were errors processing the transaction.\nNo changes were made to the database\n";
+}
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  $sth=odbc_prepare($conn,"DROP TABLE t1;");
+  $res = odbc_execute($sth);
+  exit(9);
+}
+
+$rs = odbc_result_all($rs, 'border = 2');
+if (!$rs)
+{
+  $sth=odbc_prepare($conn,"DROP TABLE t1;");
+  $res = odbc_execute($sth);
+  exit(10);
+}
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "\nError in Drop Table";
+  exit(11);
+}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/autoincrement.php b/test/phptests/autoincrement.php
new file mode 100644
index 00000000..116ba3e0
--- /dev/null
+++ b/test/phptests/autoincrement.php
@@ -0,0 +1,85 @@
+<html>
+<body>
+/*Autoincrement testing */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT auto_increment, f2 CHAR(20));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "INSERT INTO t1(f2) VALUES('One');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(3);
+}
+echo "\nINSERT INTO t1(f2) VALUES('One');";
+echo "\nRecord Inserted";
+
+$sth = odbc_prepare($conn, "INSERT INTO t1(f1,f2) VALUES(5,'Five');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(4);
+}
+echo "\nINSERT INTO t1(f1,f2) VALUES(5,'Five');";
+echo "\nRecord Inserted";
+
+$sth = odbc_prepare($conn, "INSERT INTO t1(f2) VALUES('Six');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(5);
+}
+echo "\nINSERT INTO t1(f2) VALUES('Six');";
+echo "\nRecord Inserted";
+
+$sth = odbc_prepare($conn, "INSERT INTO t1(f1,f2) VALUES(3,'Three');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(6);
+}
+echo "\nINSERT INTO t1(f1,f2) VALUES(3,'Three');";
+echo "\nRecord Inserted";
+
+$sth = odbc_prepare($conn, "INSERT INTO t1(f2) VALUES('Seven');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   exit(7);
+}
+echo "\nINSERT INTO t1(f2) VALUES('Eight');";
+echo "\nRecord Inserted\n";
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  exit(8);
+}
+echo "\nselect executed\n";
+odbc_result_all($rs);
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(9);
+}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
diff --git a/test/phptests/columninfo.php b/test/phptests/columninfo.php
new file mode 100644
index 00000000..05dd9f21
--- /dev/null
+++ b/test/phptests/columninfo.php
@@ -0,0 +1,43 @@
+<html>
+<body>
+/*Testing odbc_num_fields for find out the number of fields */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+//$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),primary key(f1));");
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$sql = "SELECT * FROM t1"; 
+$result = odbc_exec($conn, $sql); 
+$rs = odbc_num_fields($result);
+if (!$rs)
+{
+  exit(3);
+}
+
+echo "\nNumber of Fields = ";
+echo $rs ;
+echo "\n";
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/columninfo1.php b/test/phptests/columninfo1.php
new file mode 100644
index 00000000..35c6bd9c
--- /dev/null
+++ b/test/phptests/columninfo1.php
@@ -0,0 +1,42 @@
+<html>
+<body>
+/*Testing odbc_field_num for find the field position of a field */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+//$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),primary key(f1));");
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$sql = "SELECT * FROM t1"; 
+$result = odbc_exec($conn, $sql); 
+$rs = odbc_field_num($result, "f6");
+if (!$rs)
+{
+  exit(3);
+}
+echo "\nPosition of column f6 is ";
+echo $rs ;
+echo "\n";
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/columninfo2.php b/test/phptests/columninfo2.php
new file mode 100644
index 00000000..42c53bfe
--- /dev/null
+++ b/test/phptests/columninfo2.php
@@ -0,0 +1,46 @@
+<html>
+<body>
+/*  */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+//$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),primary key(f1));");
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$sql = "SELECT * FROM t1"; 
+$result = odbc_exec($conn, $sql); 
+
+echo "\nTesting odbc_field_name() for find out column_name\n";
+for ($col=0; $col<odbc_num_fields($result); $col++) 
+{
+ $rs = odbc_field_name($result, $col);
+ if (!$res)
+ {
+   echo "Error in Creation";
+   exit(2);
+ }
+ printf(" Column %d is %s\n" ,$col,odbc_field_name($result, $col));
+}
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/columninfo3.php b/test/phptests/columninfo3.php
new file mode 100644
index 00000000..fa11a563
--- /dev/null
+++ b/test/phptests/columninfo3.php
@@ -0,0 +1,45 @@
+<html>
+<body>
+/*Testing odbc_field_type for find out the type of a field    */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+//$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),primary key(f1));");
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$sql = "SELECT * FROM t1"; 
+$result = odbc_exec($conn, $sql); 
+
+echo "\nTesting odbc_field_type() for find out column type\n";
+for ($col=1; $col<=odbc_num_fields($result); $col++) 
+{
+ $rs = odbc_field_type($result, $col);
+ if (!$rs)
+ {
+   exit(3);
+ }
+ printf("Column %d har type  %s\n" ,$col, odbc_field_type($result, $col));
+}
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/columninfo4.php b/test/phptests/columninfo4.php
new file mode 100644
index 00000000..55c25129
--- /dev/null
+++ b/test/phptests/columninfo4.php
@@ -0,0 +1,45 @@
+<html>
+<body>
+/*Testing odbc_field_len for find out column length */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+//$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),primary key(f1));");
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$sql = "SELECT * FROM t1"; 
+$result = odbc_exec($conn, $sql); 
+
+echo "\nTesting odbc_field_len() for find out column length \n";
+for ($col=1; $col<=odbc_num_fields($result); $col++) 
+{
+ $rs = odbc_field_len($result, $col);
+ if (!$rs)
+ {
+   exit(2);
+ }
+ printf("Column %d has length(Field Pression) is %d\n" ,$col, odbc_field_len($result, $col));
+}
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/contest.php b/test/phptests/contest.php
new file mode 100644
index 00000000..de3d24b6
--- /dev/null
+++ b/test/phptests/contest.php
@@ -0,0 +1,14 @@
+<html>
+<body>
+//Connection Testing
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+   echo "Connection Failed";
+   exit(1);
+}
+echo "Connection Passed";
+?>
+</body>
+</html>
diff --git a/test/phptests/csql.conf b/test/phptests/csql.conf
new file mode 100644
index 00000000..3fcad3e1
--- /dev/null
+++ b/test/phptests/csql.conf
@@ -0,0 +1,104 @@
+# CSQL System Configuration File
+
+#####################################Server Section########################
+#Important: For Server section parameters, make sure that the value is same for the 
+#           server process and all the csql client process which connects to it. otherwise, 
+#           behavior is undefined
+
+# Page size. Each database is logically divided into pages and allocation happens 
+# in this unit of pages. Increasing this value will reduce frequent allocation of pages. 
+PAGE_SIZE= 8192
+
+#Total number of client process which can connect and work with the 
+# database concurrently
+MAX_PROCS = 100
+
+# Maximum size of the system database.
+MAX_SYS_DB_SIZE=10485760
+
+#Maximum size of the user database file.
+MAX_DB_SIZE=335544320
+
+#Shared memory key to be used by the system to create and locate system database.
+SYS_DB_KEY=1199
+
+#Shared memory key to be used by the system to create and locate user database.
+USER_DB_KEY=2277
+
+#Give full path for the log file where important system actions are stored.
+LOG_FILE=/tmp/log/csql/log.out
+
+#The virtual memory start address at which the shared memory segment 
+# will be created and attached. 
+MAP_ADDRESS=400000000
+
+#Whether to enable durability
+DURABILITY=false
+
+#Give full path for the database file where table and record information will
+#be stored for durability
+DATABASE_FILE=/tmp/csql/db
+
+#Important: For Server section parameters, make sure that the value is same for the 
+#           server process and all the csql client process which connects to it. otherwise, 
+#           behavior is undefined
+#####################################Client Section########################
+
+#Mutex timeout interval seconds
+MUTEX_TIMEOUT_SECS=0
+MUTEX_TIMEOUT_USECS=5000
+MUTEX_TIMEOUT_RETRIES=10
+
+#Lock timeout interval seconds
+LOCK_TIMEOUT_SECS=0
+LOCK_TIMEOUT_USECS=5000
+LOCK_TIMEOUT_RETRIES=10
+
+#####################################Cache Section########################
+
+#Whether to enable caching of tables from target database
+CACHE_TABLE=false
+
+#Set cache id for multiple bidirectional cache node for single data source
+SITE_ID=1
+
+#DSN Name to connect to the target database.
+#This should be present in ~/odbc.ini file
+DSN=myodbc3
+
+DBUSER=
+
+PASSWORD=
+
+ENABLE_BIDIRECTIONAL_CACHE=false
+
+CACHE_RECEIVER_WAIT_SECS=10
+
+#Give full path for the file where all the cached table information is stored
+TABLE_CONFIG_FILE=/tmp/csql/csqltable.conf
+
+#Mode of operation SYNC or ASYNC
+CACHE_MODE=SYNC
+
+##########################SqlNetworkServer Section########################
+
+# Whether to enable SqlNetwork server
+CSQL_SQL_SERVER=false
+
+#Set port for Network access
+PORT=5678
+
+#Whether to enable Replication across the sites
+REPLICATION=false
+
+#No of sites to replicate
+REPLICATION_SITES=16
+
+#Give full path for the file where all the peer site information is stored
+NETWORK_CONFIG_FILE=/tmp/csql/csqlnw.conf
+
+# MSGKEY for creating msg queue for MsgQueue Server
+MSG_KEY=2525
+
+ID_SHM_KEY=1947
+######################################End Section########################
diff --git a/test/phptests/datatype.php b/test/phptests/datatype.php
new file mode 100644
index 00000000..a1bd8707
--- /dev/null
+++ b/test/phptests/datatype.php
@@ -0,0 +1,240 @@
+<html>
+<body>
+/*Create table and with all types of datatypes,Insert one valid record It Should be Passed */
+
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed: " . $conn;
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT,f2 INT);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES(12,120);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(3);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  ecit(4);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_exec($conn,"DROP TABLE t1");
+
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(5);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES(12);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(6);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(7);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_exec($conn,"DROP TABLE t1");
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 char(20));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(8);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES('TWELVE');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(9);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(10);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_exec($conn,"DROP TABLE t1");
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 SMALLINT);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(11);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES(1);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(12);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(13);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_exec($conn,"DROP TABLE t1");
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 BIGINT);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(14);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES(10000001);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(15);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(16);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_exec($conn,"DROP TABLE t1");
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 FLOAT);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(17);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES(10.01);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(18);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(19);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_exec($conn,"DROP TABLE t1");
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 DOUBLE);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(20);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES(100001.100001);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(21);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(22);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_exec($conn,"DROP TABLE t1");
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 DATE);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(23);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES('2001-1-1');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion" ;
+  exit(24);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(25);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_exec($conn,"DROP TABLE t1");
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 TIMESTAMP);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(26);
+}
+$sth = odbc_prepare($conn, "INSERT INTO t1 VALUES('2001-11-30 01:01:01');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(27);
+}
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(28);
+}
+odbc_result_all($rs, 'border = 5');
+$res=odbc_exec($conn,"DROP TABLE t1");
+if (!$res)
+{
+  echo "Error in Drop Table";
+  exit(29);
+}
+echo "\nTable Dropped\nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
diff --git a/test/phptests/datatypeinfo.php b/test/phptests/datatypeinfo.php
new file mode 100644
index 00000000..dbf0d887
--- /dev/null
+++ b/test/phptests/datatypeinfo.php
@@ -0,0 +1,29 @@
+<html>
+<body>
+/*Testing for get all Datatype info of a database with odbc_gettypeinfo()*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+echo "\nDisplaying data type information. ";
+$result = odbc_gettypeinfo($conn);
+if (!$result)
+{
+  exit(2);
+}
+$rs = odbc_result_all($result);
+if (!$rs)
+{
+  exit(3);
+}
+
+echo "Test Passed\n";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/default.php b/test/phptests/default.php
new file mode 100644
index 00000000..d903ed14
--- /dev/null
+++ b/test/phptests/default.php
@@ -0,0 +1,64 @@
+<html>
+<body>
+/*Default value testing */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT default 10, f2 CHAR(20),primary key(f1));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "INSERT INTO t1(f1,f2) VALUES(1,'One');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(2);
+}
+echo "\nINSERT INTO t1(f1,f2) VALUES(1,'One');";
+echo "\nRecord Inserted";
+
+$sth = odbc_prepare($conn, "INSERT INTO t1(f2) VALUES('Ten');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(3);
+}
+echo "\nINSERT INTO t1(f2) VALUES('Ten');";
+echo "\nRecord Inserted\n";
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(4);
+}
+echo "\nselect executed\n";
+odbc_result_all($rs);
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "\nError in Drop Table";
+   exit(5);
+}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
diff --git a/test/phptests/dml.php b/test/phptests/dml.php
new file mode 100644
index 00000000..52189637
--- /dev/null
+++ b/test/phptests/dml.php
@@ -0,0 +1,104 @@
+<html>
+<body>
+/*Create table and test all DML Operation on the table */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+   echo "Connection Failed";
+   exit(1);
+}
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "Error in Creation";
+   exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "INSERT INTO t1(f1, f2) VALUES(12,'Twelve');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "Error in Insertion";
+   exit(3);
+}
+echo "\nRecord Inserted";
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+   echo "Error in selection";
+   exit(4);
+}
+echo "\nselect executed\n";
+
+echo "<table><tr>";
+echo "<th>ROLL</th>";
+echo "<th>NAME</th></tr>";
+echo "\nfetch started\n";
+while (odbc_fetch_row($rs))
+{
+  $roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 1));
+  $name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 2));
+  echo "<tr><td>$roll</td>";
+  echo "<td>$name</td></tr>\n";
+}
+echo "</table>";
+
+$sth = odbc_prepare($conn, "UPDATE t1 SET f2='TWELVE';");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "\nError in Updation\n";
+   exit(5);
+}
+echo "\nRecord Updated\n";
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+while (odbc_fetch_row($rs))
+{
+  $roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 1));
+  $name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 2));
+  echo "<tr><td>$roll</td>";
+  echo "<td>$name</td></tr>\n";
+}
+echo "</table>";
+
+$sth = odbc_prepare($conn, "DELETE FROM t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "\nError in Deletion\n";
+   exit(6);
+}
+echo "\nRecord Deleted\n";
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+while (odbc_fetch_row($rs))
+{
+  $roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 1));
+  $name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 2));
+  echo "<tr><td>$roll</td>";
+  echo "<td>$name</td></tr>\n";
+}
+echo "</table>";
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "\nError in Drop Table";
+   exit(7);
+}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+</body>
+</html>
+
diff --git a/test/phptests/dropindextest.php b/test/phptests/dropindextest.php
new file mode 100644
index 00000000..8d9ab970
--- /dev/null
+++ b/test/phptests/dropindextest.php
@@ -0,0 +1,67 @@
+<html>
+<body>
+/* Creating table with 2 fields(say f1 int, f2 char(10)).
+   Create index idx1 on f1 field. Drop that index.Again create index with same name. It should be Passed. 
+   check basic INSERT, SELECT */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"create table t1 (f1 int ,f2 char(10));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Table Creation";
+  exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "create index idx1 on t1(f1);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo " error in index creation";
+  exit(3);
+}
+echo "\ncreate index idx1 on t1(f1);";
+echo "\nIndex created\n";
+
+$sth = odbc_prepare($conn, "drop index idx1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+ odbc_exec($conn, "DROP TABLE t1;");
+ echo "\nError in Drop Index\nTest Failed\n";
+ exit(4);
+}
+echo "\ndrop index idx1;";
+echo "\nIndex idx1 dropped\n";
+
+$sth = odbc_prepare($conn, "create index idx1 on t1(f1);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in index Creation";  
+  exit(5);
+}
+echo "\ncreate index idx1 on t1(f1);";
+echo "\nIndex created\n";
+
+//$sth=odbc_prepare($conn,"DROP TABLE t1");
+$res = odbc_exec($conn, "DROP TABLE t1;");
+if (!$res)
+{
+  echo "\nError in Drop Table";
+  exit(6);
+}
+echo "\nTable Dropped\nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
diff --git a/test/phptests/index1.php b/test/phptests/index1.php
new file mode 100644
index 00000000..16542424
--- /dev/null
+++ b/test/phptests/index1.php
@@ -0,0 +1,66 @@
+<html>
+<body>
+/* Creating table with 3 INT fields, Create index on single field.
+   Create all possible composite indexes. 
+   check basic INSERT, SELECT */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"create table t1 (f1 int ,f2 int,f3 int );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Table Creation";
+  exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "create index idx1 on t1(f1);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Index creation";
+  exit(3);
+}
+echo "\ncreate index idx1 on t1(f1);";
+echo "\nIndex created\n";
+
+$sth = odbc_prepare($conn, "create index idx2 on t1(f1,f2);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Index creation";
+  exit(4);
+}
+echo "\ncreate index idx2 on t1(f1,f2);";
+echo "\nComposite key Index created\n";
+
+$sth = odbc_prepare($conn, "create index idx5 on t1(f1,f2,f3);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "Error in Index creation";
+   exit(5);
+}
+echo "\ncreate index idx5 on t1(f1,f2,f3);";
+echo "\nComposite key Index created\n";
+
+$res = odbc_exec($conn, "DROP TABLE t1;");
+if (!$res)
+{
+
+  echo "\nError in Drop Table";
+  exit(6);
+}
+echo "\nTable Dropped\nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
diff --git a/test/phptests/index2.php b/test/phptests/index2.php
new file mode 100644
index 00000000..e5138e78
--- /dev/null
+++ b/test/phptests/index2.php
@@ -0,0 +1,87 @@
+<html>
+<body>
+/* Creating table  with 2 fields(int,char)
+   Insert some duplicate value in f1 field
+   Create unique index on f1 field. It should be failed saying Unique key Violation. 
+   check basic INSERT, SELECT */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"create table t1 (f1 int, f2 char(20));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "insert into t1 values (10, 'TEN');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(3);
+}
+echo "\nRecord Inserted";
+
+$sth = odbc_prepare($conn, "insert into t1 values (10, 'ten');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(4);
+}
+echo "\nRecord Inserted\n";
+
+$sth = odbc_prepare($conn, "create index idx1 on t1(f1) unique;");
+$res = odbc_execute($sth);
+if ($res)
+{
+  odbc_exec($conn,"DROP TABLE t1;"); 
+  exit (5);
+}
+
+echo "\nUnique key can not be applied if duplicate record is available before\n";
+
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2"; 
+  exit(6);
+}
+echo "\nselect executed\n";
+echo "<table><tr>";
+echo "<th>F1</th>";
+echo "<th>F2</th></tr>";
+echo "\nfetch started\n";
+while (odbc_fetch_row($rs))
+{
+  $roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 1));
+  $name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 2));
+  echo "<tr><td>$roll</td>";
+  echo "<td>$name</td></tr>\n";
+}
+echo "</table>";
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "\nError in Drop Table";
+  exit(7);
+}
+echo "\nTable Dropped\nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
diff --git a/test/phptests/mysqlwqtest26.php b/test/phptests/mysqlwqtest26.php
new file mode 100644
index 00000000..080d7f2e
--- /dev/null
+++ b/test/phptests/mysqlwqtest26.php
@@ -0,0 +1,159 @@
+<html>
+<body>
+<?php
+/*Performance Test for all parameterised DML*/
+
+$conn=odbc_connect('mycsql','root','');
+if (!$conn)
+  {exit("Connection Failed: " . $conn);}
+echo "Connection Passed\n";
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1 (f1 BIGINT, f2 char(196), primary key (f1));");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("Error in Creation");}
+echo "Table Created\n";
+
+ $timecount = 0;
+ $min = 1;
+ $max = 0;
+ $time_start = 0;
+ $time_end = 0;
+ $time = 0;
+ $count =0;
+ $q = "INSERT INTO t1(f1,f2) values(?,?);";
+ $b = "ABCDEFGHIJKLMNOPQRSTUVWXYZ9876543210";
+ $res = odbc_prepare ($conn, $q);
+ for ($i = 0; $i <100; $i++)
+ {
+   $time_start = microtime();
+   $a = $i; 
+   odbc_execute($res, array($a, $b));
+   $time_end = microtime();
+   $time = $time_end - $time_start;
+   $timecount = $timecount + $time ;
+   if ($min > $time)
+      {$min = $time;} 
+   if ($max < $time)
+      {$max = $time;} 
+   $count++;
+ }
+ printf("\nInsert :%6d  MIN :%4f  MAX :%4f AVG :%4f microsec\n",$count,$min,$max,$timecount/$count);
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+  {exit("Error in SQL-2");}
+odbc_result_all($rs, 'border = 2');
+
+ $timecount = 0;
+ $min = 1;
+ $max = 0;
+ $time_start = 0;
+ $time_end = 0;
+ $time = 0;
+ $count =0;
+ $q = "SELECT * FROM t1 WHERE f1=?;";
+ $res = odbc_prepare ($conn, $q);
+ for ($i = 0; $i <100; $i++)
+ {
+   $time_start = microtime();
+   $a = $i; 
+   $rs=odbc_execute($res, array($a));
+
+   echo "<table><tr>";
+   echo "<th>ROLL</th>";
+   echo "<th>NAME</th></tr>";
+   while (odbc_fetch_row($rs))
+   {
+     $roll=odbc_result($rs, 1);
+     $name=odbc_result($rs, 2);
+     echo "<tr><td>$roll</td>";
+     echo "<td>$name</td></tr>\n";
+   }
+   echo "</table>";
+
+   $time_end = microtime();
+   $time = $time_end - $time_start;
+   $timecount = $timecount + $time ;
+   if ($min > $time)
+      {$min = $time;} 
+   if ($max < $time)
+      {$max = $time;} 
+   $count++;
+ }
+ printf("\nSelect :%6d  MIN :%4f  MAX :%4f AVG :%4f microsec\n",$count,$min,$max,$timecount/$count);
+
+ $timecount = 0;
+ $min = 1;
+ $max = 0;
+ $time_start = 0;
+ $time_end = 0;
+ $time = 0;
+ $count =0;
+ $q = "update t1 set f2=? where f1=?;";
+ $res = odbc_prepare ($conn, $q);
+ for ($i = 0; $i <100; $i++)
+ {
+   $time_start = microtime();
+   $a = "LAKSHYA_CSQL"; 
+   $b = $i;
+   odbc_execute($res, array($a, $b));
+   $time_end = microtime();
+   $time = $time_end - $time_start;
+   $timecount = $timecount + $time ;
+   if ($min > $time)
+      {$min = $time;} 
+   if ($max < $time)
+      {$max = $time;} 
+   $count++;
+ }
+ printf("\nUpdate :%6d  MIN :%4f  MAX :%4f AVG :%4f microsec\n",$count,$min,$max,$timecount/$count);
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+  {exit("Error in SQL-2");}
+odbc_result_all($rs, 'border = 2');
+
+ $timecount = 0;
+ $min = 1;
+ $max = 0;
+ $time_start = 0;
+ $time_end = 0;
+ $time = 0;
+ $count =0;
+ $q = "DELETE FROM t1 WHERE f1=?;";
+ $res = odbc_prepare ($conn, $q);
+ for ($i = 0; $i <100; $i++)
+ {
+   $time_start = microtime();
+   $a = $i; 
+   $rs = odbc_execute($res, array($a));
+   $time_end = microtime();
+   $time = $time_end - $time_start;
+   $timecount = $timecount + $time ;
+   if ($min > $time)
+      {$min = $time;} 
+   if ($max < $time)
+      {$max = $time;} 
+   $count++;
+ }
+ printf("\nDelete :%6d  MIN :%4f  MAX :%4f AVG :%4f microsec\n",$count,$min,$max,$timecount/$count);
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+  {exit("Error in SQL-2");}
+odbc_result_all($rs, 'border = 2');
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+
+?>
+</body>
+</html>
diff --git a/test/phptests/nulltest.php b/test/phptests/nulltest.php
new file mode 100644
index 00000000..7a94b798
--- /dev/null
+++ b/test/phptests/nulltest.php
@@ -0,0 +1,67 @@
+<html>
+<body>
+/* Creating table with not null constraint constraint on the int field
+   check basic INSERT, SELECT */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo"Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"create table t1 (f1 int not null, f2 int);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$res = odbc_exec($conn, "insert into t1 values (10, 20);");
+echo $res ;
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(3);
+}
+echo "\nRecord Inserted\n";
+
+$res = odbc_exec($conn,"insert into t1 values (null, 20);");
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2" ;
+  exit(4);
+}
+echo "\nselect executed\n";
+echo "<table><tr>";
+echo "<th>F1</th>";
+echo "<th>F2</th></tr>";
+echo "\nfetch started\n";
+while (odbc_fetch_row($rs))
+{
+  $roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 1));
+  $name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 2));
+  echo "<tr><td>$roll</td>";
+  echo "<td>$name</td></tr>\n";
+}
+echo "</table>";
+
+$sth=odbc_prepare($conn,"DROP TABLE t1");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "\nError in Drop Table";
+  exit(5);
+}
+echo "\nTable Dropped\nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
diff --git a/test/phptests/odbc_error.php b/test/phptests/odbc_error.php
new file mode 100644
index 00000000..8acd37da
--- /dev/null
+++ b/test/phptests/odbc_error.php
@@ -0,0 +1,47 @@
+<html>
+<body>
+/*Testing odbc_error() and odbc_errormsg() for error handeling */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+  {echo "Connection Failed"; exit(1);}
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+$res = odbc_execute($sth);
+if (!$res)
+  {echo "Error in Creation"; exit(2);}
+echo "Table Created\n";
+
+$query1 = "INSERT INTO t1(f1,f3,f4) values(10,1,100001);";
+odbc_exec($conn,$query1);
+if (odbc_error())
+{
+    echo odbc_errormsg($conn);
+}
+echo "Record Inserted\n";
+
+$query2 = "INSERT INTO t1(f1,f2,f9) values(20,'BCAD',1);";
+odbc_exec($conn,$query2);
+if (odbc_error())
+{
+    echo "\nINSERT INTO t1(f1,f2,f9) values(20,'BCAD',1);\n";
+    echo odbc_errormsg($conn);
+}
+echo "\n";
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+  {echo "Error in SQL-2";exit(3);}
+odbc_result_all($rs, 'border = 5');
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/odbc_fetch_array.php b/test/phptests/odbc_fetch_array.php
new file mode 100644
index 00000000..673c6568
--- /dev/null
+++ b/test/phptests/odbc_fetch_array.php
@@ -0,0 +1,32 @@
+<html>
+<body>
+/*Testing  odbc_fetch_array()*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+  {echo "Connection Failed";exit(1);}
+
+odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+odbc_exec($conn,"INSERT INTO t1(f1,f3,f4) values(10,'ABCD',100001);");
+odbc_exec($conn,"INSERT INTO t1(f1,f2,f3) values(20,'BCAD',1);");
+
+$sql = 'SELECT * from t1;';
+$result = odbc_exec($conn, $sql);
+
+while ($row = odbc_fetch_array($result)) 
+{   
+    echo $row["f1"], "\n";
+}
+//fetch array is not working:remove below 2 lines after it is fixed
+odbc_exec($conn,"DROP TABLE t1;");
+exit(1);
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {echo "\nError in Drop Table"; exit(2);}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/odbc_fetch_array1.php b/test/phptests/odbc_fetch_array1.php
new file mode 100644
index 00000000..121ea3b8
--- /dev/null
+++ b/test/phptests/odbc_fetch_array1.php
@@ -0,0 +1,43 @@
+<html>
+<body>
+/*Testing  odbc_next_result, var_dump  for find next result*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+  {echo "Connection Failed" ; exit(1);}
+
+
+odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 int);");
+odbc_exec($conn,"INSERT INTO t1 values(10,'ABCD',1);");
+odbc_exec($conn,"INSERT INTO t1 values(20,'PQRS',2);");
+
+$sql = <<<END_SQL
+SELECT * from t1;
+END_SQL;
+
+$result = odbc_exec($conn, $sql);
+
+echo "Get First results set\n";
+$r1 = odbc_fetch_array($result);
+$r2 = odbc_fetch_array($result);
+echo "Dump first result set\n";
+var_dump($r1, $r2);
+
+echo "Get second results set\n";
+var_dump(odbc_next_result($result));
+
+$r1 = odbc_fetch_array($result);
+$r2 = odbc_fetch_array($result);
+echo "Dump 2nd result set\n";
+var_dump($r1, $r2);
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {echo "\nError in Drop Table";exit(2);}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/odbc_result_all.php b/test/phptests/odbc_result_all.php
new file mode 100644
index 00000000..feeb3617
--- /dev/null
+++ b/test/phptests/odbc_result_all.php
@@ -0,0 +1,64 @@
+<html>
+<body>
+/* odbc_result_all() test for display the conditional select result in formated manner. It is more advance than odbc_result() */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,primary key(f1,f3));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(2);
+}
+echo "Table Created\n";
+
+$sth = odbc_prepare($conn,"INSERT INTO t1 VALUES(200,'NP',2);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(3);
+}
+echo "Record Inserted\n";
+
+$sth = odbc_prepare($conn,"INSERT INTO t1 VALUES(100,'PP',1);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(4);
+}
+echo "Record Inserted\n";
+
+$sth = odbc_prepare($conn,"INSERT INTO t1 VALUES(300,'RP',3);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  exit(5);
+}
+echo "Record Inserted\n";
+
+$sth = 'SELECT * FROM t1 where f1<=200;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  exit(6);
+}
+odbc_result_all($rs, 'border = 5');
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "\nError in Drop Table";
+  exit(7);
+}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/odbc_statistics.php b/test/phptests/odbc_statistics.php
new file mode 100644
index 00000000..95963e7d
--- /dev/null
+++ b/test/phptests/odbc_statistics.php
@@ -0,0 +1,32 @@
+<html>
+<body>
+/*Testing  odbc_statistics()*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed ";
+  exit(1);
+}
+
+odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT);");
+odbc_exec($conn,"INSERT INTO t1(f1,f3,f4) values(10,'ABCD',100001);");
+odbc_exec($conn,"INSERT INTO t1(f1,f2,f3) values(20,'BCAD',1);");
+
+$result = odbc_statistics($conn,"test","","t1",0,0);
+odbc_result_all($result);
+if (!$conn)
+{
+  exit(2);
+}
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/odbcfree.php b/test/phptests/odbcfree.php
new file mode 100644
index 00000000..9b4f722e
--- /dev/null
+++ b/test/phptests/odbcfree.php
@@ -0,0 +1,44 @@
+<html>
+<body>
+/*Testing Querry Memory Free with odbc_free_result() */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$sql = 'SELECT f3,f5,f7 FROM t1';
+$result = odbc_exec($conn, $sql);
+echo "\nFreeing query Memory\n";
+
+$freeing = odbc_free_result($result);
+if (!$res)
+{
+  exit(3);
+}
+echo "Query memory freed\n";
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "\nError in Drop Table";
+  exit(4);
+}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/paradelete.php b/test/phptests/paradelete.php
new file mode 100644
index 00000000..73c12d67
--- /dev/null
+++ b/test/phptests/paradelete.php
@@ -0,0 +1,69 @@
+<html>
+<body>
+/*Parateterised delete*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$res = odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 int);");
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$res = odbc_exec($conn,"INSERT INTO t1 values(10,'ABCD',1);");
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(3);
+}
+echo "Table Created\n";
+
+$res = odbc_exec($conn,"INSERT INTO t1 values(20,'PQRS',2);");
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(4);
+}
+echo "Table Created\n";
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(5);
+}
+odbc_result_all($rs, 'border = 5');
+
+$q = "DELETE FROM t1 WHERE f1=?;";
+$res = odbc_prepare ($conn, $q);
+$a = 10;
+$exc = odbc_execute($res, array($a));
+if (!$rs)
+{
+  exit(6);
+}
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+  {exit("Error in SQL-2");}
+odbc_result_all($rs, 'border = 5');
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/parainsert.php b/test/phptests/parainsert.php
new file mode 100644
index 00000000..bbe94ad1
--- /dev/null
+++ b/test/phptests/parainsert.php
@@ -0,0 +1,47 @@
+<html>
+<body>
+/*Parateterised Insert*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 int);");
+odbc_exec($conn,"INSERT INTO t1 values(10,'ABCD',1);");
+odbc_exec($conn,"INSERT INTO t1 values(20,'PQRS',2);");
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(2);
+}
+odbc_result_all($rs, 'border = 5');
+
+$q = "INSERT INTO t1(f1,f2) values(?,?);";
+$res = odbc_prepare ($conn, $q);
+$a = 30; $b = "PPPP";
+$exc = odbc_execute($res, array($a, $b));
+if (!$rs)
+{
+  exit(3);
+}
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+odbc_result_all($rs, 'border = 5');
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/paraselect.php b/test/phptests/paraselect.php
new file mode 100644
index 00000000..19223463
--- /dev/null
+++ b/test/phptests/paraselect.php
@@ -0,0 +1,72 @@
+<html>
+<body>
+/*Parateterised delete*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$res = odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 int);");
+if (!$res)
+{
+  exit(2);
+}
+echo "Table Created\n";
+
+$res = odbc_exec($conn,"INSERT INTO t1 values(10,'ABCD',1);");
+if (!$res)
+{
+  exit(3);
+}
+echo "Table Created\n";
+
+$res = odbc_exec($conn,"INSERT INTO t1 values(20,'PQRS',2);");
+if (!$res)
+{
+  exit(4);
+}
+echo "Table Created\n";
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  exit(5);
+}
+odbc_result_all($rs, 'border = 5');
+
+$q = "SELECT * FROM t1 WHERE f1=?;";
+$res = odbc_prepare ($conn, $q);
+$a = 10;
+$res1 = odbc_execute($res, array($a));
+if (!$res)
+{
+  exit(6);
+}
+
+   echo "<table><tr>";
+   echo "<th>ROLL</th>";
+   echo "<th>NAME</th></tr>";
+   while (odbc_fetch_row($res))
+   {
+     $roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($res, 1));
+     $name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($res, 2));
+     echo "<tr><td>$roll</td>";
+     echo "<td>$name</td></tr>\n";
+   }
+   echo "</table>";
+
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/paraupdate.php b/test/phptests/paraupdate.php
new file mode 100644
index 00000000..838e35fd
--- /dev/null
+++ b/test/phptests/paraupdate.php
@@ -0,0 +1,51 @@
+<html>
+<body>
+/*Parameterisez update*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed ";
+  exit(1);
+}
+
+$result = odbc_exec($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 int);");
+$result = odbc_exec($conn,"INSERT INTO t1 values(10,'ABCD',1);");
+$result = odbc_exec($conn,"INSERT INTO t1 values(20,'PQRS',2);");
+
+odbc_free_result($result);
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(2);
+}
+odbc_result_all($rs, 'border = 5');
+odbc_free_result($rs);
+
+$q = "update t1 set f2=? where f1=?";
+$res = odbc_prepare ($conn, $q);
+$a = "PPPP"; $b=10;
+$exc = odbc_execute($res, array($a, $b));
+if (!$rs)
+{
+  exit(3);
+}
+
+$sth = 'SELECT * FROM t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+  {exit("Error in SQL-2");}
+odbc_result_all($rs, 'border = 5');
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+  {exit("\nError in Drop Table");}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/primarytest.php b/test/phptests/primarytest.php
new file mode 100644
index 00000000..845d0855
--- /dev/null
+++ b/test/phptests/primarytest.php
@@ -0,0 +1,55 @@
+<html>
+<body>
+/* Creating table with Primary key constraint constraint on the int field
+   check basic INSERT, SELECT */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"create table t1 (f1 int , f2 int, primary key(f1));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "insert into t1 values (10, 20);");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(3);
+}
+echo "\nRecord Inserted\n";
+
+$res = odbc_exec($conn, "insert into t1 values (10, 30);");
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(4);
+}
+echo "\nselect executed\n";
+odbc_result_all($rs);
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "\nError in Drop Table";
+  exit(5);
+}
+echo "\nTable Dropped\nTest Passed\n";
+odbc_close($conn);
+?>
+</body>
+</html>
+
diff --git a/test/phptests/rowinfo.php b/test/phptests/rowinfo.php
new file mode 100644
index 00000000..4b5ac16f
--- /dev/null
+++ b/test/phptests/rowinfo.php
@@ -0,0 +1,76 @@
+<html>
+<body>
+/* Testing odbc_num_rows() for display number of rows */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+//$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),primary key(f1));");
+$sth = odbc_prepare($conn,"CREATE TABLE t1(f1 INT, f2 CHAR(20),f3 SMALLINT,f4 BIGINT,f5 FLOAT, f6 DOUBLE,f7 DATE, f8 TIMESTAMP );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created\n";
+
+$sth = odbc_prepare($conn,"INSERT INTO t1 VALUES(20,'Twenty',2,10000001,10.01,10000001.000001,'2001-1-1','2001-11-30 01:01:01');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(3);
+}
+echo "Record Inserted\n";
+
+$sth = odbc_prepare($conn,"INSERT INTO t1 VALUES(30,'Thirty',3,20000002,20.02,20000002.000002,'2002-2-2','2002-22-30 02:02:02');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+    echo "Error in Creation";
+    exit(4);
+}
+echo "Record Inserted\n";
+
+$sql = 'SELECT * FROM t1;';
+$result = odbc_exec($conn, $sql);
+echo "Number of rows = ";
+$a=odbc_num_rows($result);
+if (!$a)
+{
+    odbc_exec($conn,"DROP TABLE t1;");
+    exit(5);
+}
+echo $a;
+
+$sql = "SELECT f3,f5,f7 FROM t1";
+$result = odbc_exec($conn, $sql);
+echo "\n<table> \n";
+while (odbc_fetch_row($result)) 
+{
+   $a=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($result,1));
+   $b=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($result,2));
+   $c=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($result,3));
+   echo "<tr>";
+   echo "<td>$a</td><td>$b</td><td>$c</td></tr>";
+   echo "\n";
+}
+echo "</table>";
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "\nError in Drop Table";
+   exit(6);
+}
+echo "\nTable Dropped \nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
diff --git a/test/phptests/test001.ksh b/test/phptests/test001.ksh
new file mode 100755
index 00000000..b5128e95
--- /dev/null
+++ b/test/phptests/test001.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+echo $REL_PATH
+php $REL_PATH/contest.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test002.ksh b/test/phptests/test002.ksh
new file mode 100755
index 00000000..a67a57c5
--- /dev/null
+++ b/test/phptests/test002.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/dml.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test003.ksh b/test/phptests/test003.ksh
new file mode 100755
index 00000000..4dc9728e
--- /dev/null
+++ b/test/phptests/test003.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/datatype.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test004.ksh b/test/phptests/test004.ksh
new file mode 100755
index 00000000..93b985ec
--- /dev/null
+++ b/test/phptests/test004.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/nulltest.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test005.ksh b/test/phptests/test005.ksh
new file mode 100755
index 00000000..0a13c5a7
--- /dev/null
+++ b/test/phptests/test005.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/primarytest.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test006.ksh b/test/phptests/test006.ksh
new file mode 100755
index 00000000..ca953501
--- /dev/null
+++ b/test/phptests/test006.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/index1.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test007.ksh b/test/phptests/test007.ksh
new file mode 100755
index 00000000..422dbe2a
--- /dev/null
+++ b/test/phptests/test007.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/uniqueindex.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test008.ksh b/test/phptests/test008.ksh
new file mode 100755
index 00000000..26ab47ad
--- /dev/null
+++ b/test/phptests/test008.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/index2.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test009.ksh b/test/phptests/test009.ksh
new file mode 100755
index 00000000..0e9fa946
--- /dev/null
+++ b/test/phptests/test009.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/uniqueindex2.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test010.ksh b/test/phptests/test010.ksh
new file mode 100755
index 00000000..5c9dc1a9
--- /dev/null
+++ b/test/phptests/test010.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/dropindextest.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test011.ksh b/test/phptests/test011.ksh
new file mode 100755
index 00000000..a2774c44
--- /dev/null
+++ b/test/phptests/test011.ksh
@@ -0,0 +1,18 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/autoincrement.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test012.ksh b/test/phptests/test012.ksh
new file mode 100755
index 00000000..f822feca
--- /dev/null
+++ b/test/phptests/test012.ksh
@@ -0,0 +1,18 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/default.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test013.ksh b/test/phptests/test013.ksh
new file mode 100755
index 00000000..c4f6cc1f
--- /dev/null
+++ b/test/phptests/test013.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/columninfo.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test014.ksh b/test/phptests/test014.ksh
new file mode 100755
index 00000000..85537c21
--- /dev/null
+++ b/test/phptests/test014.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/rowinfo.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test015.ksh b/test/phptests/test015.ksh
new file mode 100755
index 00000000..4f8a3d13
--- /dev/null
+++ b/test/phptests/test015.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+php $REL_PATH/datatypeinfo.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test016.ksh b/test/phptests/test016.ksh
new file mode 100755
index 00000000..52827013
--- /dev/null
+++ b/test/phptests/test016.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/odbc_result_all.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test017.ksh b/test/phptests/test017.ksh
new file mode 100755
index 00000000..6772431c
--- /dev/null
+++ b/test/phptests/test017.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/autocommit_rollback_commit.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test018.ksh b/test/phptests/test018.ksh
new file mode 100755
index 00000000..a8fc592a
--- /dev/null
+++ b/test/phptests/test018.ksh
@@ -0,0 +1,18 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/odbc_error.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test019.ksh b/test/phptests/test019.ksh
new file mode 100755
index 00000000..03bae506
--- /dev/null
+++ b/test/phptests/test019.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/odbc_fetch_array.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test020.ksh b/test/phptests/test020.ksh
new file mode 100755
index 00000000..36634a38
--- /dev/null
+++ b/test/phptests/test020.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/odbc_fetch_array1.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test021.ksh b/test/phptests/test021.ksh
new file mode 100755
index 00000000..8284b53b
--- /dev/null
+++ b/test/phptests/test021.ksh
@@ -0,0 +1,18 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/odbc_statistics.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test022.ksh b/test/phptests/test022.ksh
new file mode 100755
index 00000000..ec9e7110
--- /dev/null
+++ b/test/phptests/test022.ksh
@@ -0,0 +1,18 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/parainsert.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test023.ksh b/test/phptests/test023.ksh
new file mode 100755
index 00000000..fb3ffd2c
--- /dev/null
+++ b/test/phptests/test023.ksh
@@ -0,0 +1,18 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/paraupdate.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test024.ksh b/test/phptests/test024.ksh
new file mode 100755
index 00000000..555928bf
--- /dev/null
+++ b/test/phptests/test024.ksh
@@ -0,0 +1,18 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/paradelete.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test025.ksh b/test/phptests/test025.ksh
new file mode 100755
index 00000000..a7403bd3
--- /dev/null
+++ b/test/phptests/test025.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/paraselect.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test026.ksh b/test/phptests/test026.ksh
new file mode 100755
index 00000000..c92c5792
--- /dev/null
+++ b/test/phptests/test026.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+php $REL_PATH/odbcfree.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test027.ksh b/test/phptests/test027.ksh
new file mode 100755
index 00000000..44a956fc
--- /dev/null
+++ b/test/phptests/test027.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/columninfo1.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test028.ksh b/test/phptests/test028.ksh
new file mode 100755
index 00000000..8a4107df
--- /dev/null
+++ b/test/phptests/test028.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/columninfo2.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test029.ksh b/test/phptests/test029.ksh
new file mode 100755
index 00000000..97092de1
--- /dev/null
+++ b/test/phptests/test029.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/columninfo3.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/test030.ksh b/test/phptests/test030.ksh
new file mode 100755
index 00000000..1bba91b7
--- /dev/null
+++ b/test/phptests/test030.ksh
@@ -0,0 +1,17 @@
+#!/bin/ksh
+
+CSQL_CONF=${PWD}/phptests/csql.conf
+REL_PATH=.
+if [ -s "$CSQL_CONF" ]
+then
+    REL_PATH=${PWD}/phptests
+fi
+
+php $REL_PATH/columninfo4.php
+if [ $? -ne 0 ]
+then
+    exit 50;
+fi
+exit 0;
+
+
diff --git a/test/phptests/uniqueindex.php b/test/phptests/uniqueindex.php
new file mode 100644
index 00000000..19bdd76c
--- /dev/null
+++ b/test/phptests/uniqueindex.php
@@ -0,0 +1,65 @@
+<html>
+<body>
+/*Creating table with 3 INT fields, Create unique index on single field.
+   Create possible composite unique indexes in different Combinations
+*/
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"create table t1 (f1 int ,f2 int,f3 int );");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Table Creation";
+  exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "create index idx1 on t1(f1) unique;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in index";
+  exit(3);
+}
+echo "\ncreate index idx1 on t1(f1) unique;";
+echo "\nIndex created\n";
+
+$sth = odbc_prepare($conn, "create index idx2 on t1(f1,f2)  unique;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "\ncreate index idx1 on t1(f1) unique;";
+   exit(4);
+}
+echo "\ncreate index idx2 on t1(f1,f2) unique;";
+echo "\nComposite key Index created\n";
+
+$sth = odbc_prepare($conn, "create index idx5 on t1(f1,f2,f3) unique;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+   echo "\nError in index creation;";
+   exit(5);
+}
+echo "\ncreate index idx5 on t1(f1,f2,f3) unique;";
+echo "\nComposite key Index created\n";
+
+$res = odbc_exec($conn, "DROP TABLE t1;");
+if (!$res)
+{
+   echo "\ncError in drop table;";
+   exit(6);
+}
+echo "\nTable Dropped\nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
diff --git a/test/phptests/uniqueindex2.php b/test/phptests/uniqueindex2.php
new file mode 100644
index 00000000..548ab95a
--- /dev/null
+++ b/test/phptests/uniqueindex2.php
@@ -0,0 +1,87 @@
+<html>
+<body>
+/* Creating table  with 2 fields(int,char)
+   Insert some duplicate value in f1 field
+   Create unique index on f1 field. It should be failed saying Unique key Violation. 
+   check basic INSERT, SELECT */
+<?php
+$conn=odbc_connect('mycsql','root','manager');
+if (!$conn)
+{
+  echo "Connection Failed";
+  exit(1);
+}
+
+$sth = odbc_prepare($conn,"create table t1 (f1 int, f2 char(20));");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Creation";
+  exit(2);
+}
+echo "Table Created";
+
+$sth = odbc_prepare($conn, "insert into t1 values (10, 'TEN');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(3);
+}
+echo "\nRecord Inserted";
+
+$sth = odbc_prepare($conn, "insert into t1 values (10, 'ten');");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "Error in Insertion";
+  exit(4);
+}
+echo "\nRecord Inserted\n";
+
+$sth = odbc_prepare($conn, "create index idx1 on t1(f1) unique;");
+$res = odbc_execute($sth);
+if ($res)
+{
+  odbc_exec($conn,"DROP TABLE t1;"); 
+  echo("Error in Unique Index\nTest Failed");
+}
+
+echo "\nUnique key can not be applied if duplicate record is available before\n";
+
+
+$sth = 'select * from t1;';
+$rs = odbc_exec($conn, $sth);
+if (!$rs)
+{
+  echo "Error in SQL-2";
+  exit(5);
+}
+echo "\nselect executed\n";
+echo "<table><tr>";
+echo "<th>F1</th>";
+echo "<th>F2</th></tr>";
+echo "\nfetch started\n";
+while (odbc_fetch_row($rs))
+{
+  $roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 1));
+  $name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($rs, 2));
+  echo "<tr><td>$roll</td>";
+  echo "<td>$name</td></tr>\n";
+}
+echo "</table>";
+
+$sth=odbc_prepare($conn,"DROP TABLE t1;");
+$res = odbc_execute($sth);
+if (!$res)
+{
+  echo "\nError in Drop Table";
+  exit(6);
+}
+echo "\nTable Dropped\nTest Passed";
+odbc_close($conn);
+?>
+
+</body>
+</html>
+
-- 
2.11.4.GIT