diff options
Diffstat (limited to 'tests/odbc-t3.php')
| -rw-r--r-- | tests/odbc-t3.php | 95 |
1 files changed, 0 insertions, 95 deletions
diff --git a/tests/odbc-t3.php b/tests/odbc-t3.php deleted file mode 100644 index edfdc658f8..0000000000 --- a/tests/odbc-t3.php +++ /dev/null @@ -1,95 +0,0 @@ -<HTML> -<HEAD> -<TITLE>Database test #3</TITLE> -</HEAD> -<BODY> -<H1>ODBC Test 3 - Insert records</H1> -<?php - if(isset($dbuser)){ - echo "Connecting to $dsn as $dbuser\n"; - $conn = odbc_connect($dsn,$dbuser,$dbpwd); - if(!$conn){ -?> -<H2>Error connecting to database! Check DSN, username and password</H2> -<?php - }else{ -?> - - OK<p> -Clearing table "php_test" -<?php - error_reporting(0); - $res=odbc_exec($conn,"delete from php_test"); - odbc_free_result($res); - error_reporting(1); -?> - - OK<p> -Inserting into table "php_test" -<?php - $sqlfloat = '00.0'; - $sqlint = 1000; - $stmt = odbc_prepare($conn, "insert into php_test values(?,?,?,?)"); - for($i=1; $i<=5; $i++){ - $values[0] = "test-$i"; - $values[1] = $sqlint + $i; - $values[2] = $i . $sqlfloat . $i; - $values[3] = "php - values $i"; - $ret = odbc_execute($stmt, &$values); - } - odbc_free_result($stmt); - $res = odbc_exec($conn, "select count(*) from php_test"); - if($res && (odbc_result($res, 1) == 5)){ - odbc_free_result($res); -?> - - OK<p> -<H3>The table "php_test" should now contain the following values:</H3> -<table> - <tr> - <th>A</th><th>B</th><th>C</th><th>D</th> - </tr> - <tr> - <td>test-1</td><td>1001</td><td>100.01</td><td>php - values 1</td> - </tr> - <tr> - <td>test-2</td><td>1002</td><td>200.02</td><td>php - values 2</td> - </tr> - <tr> - <td>test-3</td><td>1003</td><td>300.03</td><td>php - values 3</td> - </tr> - <tr> - <td>test-4</td><td>1004</td><td>400.04</td><td>php - values 4</td> - </tr> - <tr> - <td>test-5</td><td>1005</td><td>500.05</td><td>php - values 5</td> - </tr> -</table> - -<H3>Actual contents of table "php_test":</H3> -<?php - $res = odbc_exec($conn, "select * from php_test"); - odbc_result_all($res); - } -?> -<p> - <HR width="50%"> -<p> -<A HREF="odbc-t4.php?dbuser=<?php echo "$dbuser&dsn=$dsn&dbpwd=$dbpwd" ?>">Proceed to next test</A> -| <A HREF="<?php echo $PHP_SELF ?>">Change login information</A> -<?php - } - } else { -?> -<form action=odbc-t3.php method=post> -<table border=0> - <tr><td>Database: </td><td><input type=text name=dsn></td></tr> - <tr><td>User: </td><td><input type=text name=dbuser></td></tr> - <tr><td>Password: </td><td><input type=password name=dbpwd></td></tr> -</table> -<input type=submit value=connect> - -</form> -<?php - } -?> -</BODY> -</HTML> - |