diff options
| author | Andreas Karajannis <kara@php.net> | 2000-05-28 12:50:19 +0000 |
|---|---|---|
| committer | Andreas Karajannis <kara@php.net> | 2000-05-28 12:50:19 +0000 |
| commit | 1e949e6caa61f6a0c33ae5241056007226108021 (patch) | |
| tree | bc38f0c690bd0fe3ca1f5e94ccc044258b529cae /tests/odbc-t3.php | |
| parent | e50b33c2402d53fc7b1ead9444e09d420d0c7b7c (diff) | |
| download | php-git-1e949e6caa61f6a0c33ae5241056007226108021.tar.gz | |
Test scripts for ODBC added
Diffstat (limited to 'tests/odbc-t3.php')
| -rw-r--r-- | tests/odbc-t3.php | 95 |
1 files changed, 95 insertions, 0 deletions
diff --git a/tests/odbc-t3.php b/tests/odbc-t3.php new file mode 100644 index 0000000000..edfdc658f8 --- /dev/null +++ b/tests/odbc-t3.php @@ -0,0 +1,95 @@ +<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> + |