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-t2.php | |
| parent | e50b33c2402d53fc7b1ead9444e09d420d0c7b7c (diff) | |
| download | php-git-1e949e6caa61f6a0c33ae5241056007226108021.tar.gz | |
Test scripts for ODBC added
Diffstat (limited to 'tests/odbc-t2.php')
| -rw-r--r-- | tests/odbc-t2.php | 82 |
1 files changed, 82 insertions, 0 deletions
diff --git a/tests/odbc-t2.php b/tests/odbc-t2.php new file mode 100644 index 0000000000..a500b09e8b --- /dev/null +++ b/tests/odbc-t2.php @@ -0,0 +1,82 @@ +<HTML> +<HEAD> +<TITLE>Quick & dirty ODBC test #2</TITLE> +</HEAD> +<BODY> +<H1>ODBC Test 2 - Create table</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> +Dropping table "php3_test" +<?php + Error_Reporting(0); + $res = odbc_exec($conn,"drop table php_test"); + if($res){ + odbc_free_result($res); + } +?> +- OK<p> +Create table "php_test" +<?php + error_reporting(1); + $res = odbc_exec($conn, 'create table php_test (a char(16), b integer, c float, d varchar(128))'); + if($res){ + odbc_free_result($res); +?> + - OK<p> +Table Info:<br> +<table> + <tr> + <th>Name</th> + <th>Type</th> + <th>Length</th> + </tr> +<?php + $info = odbc_exec($conn,"select * from php_test"); + $numfields = odbc_num_fields($info); + + for($i=1; $i<=$numfields; $i++){ +?> + <tr> + <td><?php echo odbc_field_name($info, $i) ?></td> + <td><?php echo odbc_field_type($info, $i) ?></td> + <td><?php echo odbc_field_len($info,$i) ?></td> + </tr> +<?php + } +?> +</table> +<P> +<HR width=50%"> +<P> +<A HREF="odbc-t3.php<?php echo "?dbuser=$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 (DSN): </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="Continue"> +</form> + +<?php + } +?> +</BODY> +</HTML> |