root/tests/odbc-t5.php

/* [<][>][^][v][top][bottom][index][help] */
<HTML>
<HEAD>
<TITLE>Database test #5</TITLE>
</HEAD>
<BODY>
<H1>ODBC Test 5 - Blobs</H1>
<?php
  if(!isset($gif1file) && !isset($display) || 
                ($gif1file == "none" && $gif2file == "none" 
                 && $gif3file == "none")){
?>
<H2>Please select the images (gif) you want to put into the database</H2>
<FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>" ENCTYPE="multipart/form-data">
Image 1: <INPUT TYPE="file" NAME="gif1file" VALUE="" SIZE="48"><P>
Image 2: <INPUT TYPE="file" NAME="gif2file" VALUE="" SIZE="48"><P>
Image 3: <INPUT TYPE="file" NAME="gif3file" VALUE="" SIZE="48"><P>
Blob database type name: <INPUT  TYPE="text" NAME="datatype" VALUE="LONG BYTE" SIZE="32">
<P>
<INPUT  TYPE="hidden"  name="dsn" value="<?php echo $dsn ?>">
<INPUT  TYPE="hidden"  name="dbuser" value="<?php echo $dbuser ?>">
<INPUT  TYPE="hidden"  name="dbpwd" value="<?php echo $dbpwd ?>">
<INPUT  TYPE="submit"  VALUE="Send  File(s)">
| <INPUT  TYPE="reset"  VALUE="reset">
</FORM>
</BODY>
</HTML>
<?php
        exit;
  }
 
  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>
<?php
                if(isset($display)){
                        if(($res = odbc_exec($conn, 'select id from php_test'))){
                                echo "<H3>Images in database</H3>";
                                while(odbc_fetch_into($res, &$imgs)){
                                        echo "$imgs[0] : <IMG SRC=\"odbc-display.php?id=$imgs[0]&dbuser=$dbuser&dsn=$dsn&dbpwd=$dbpwd\">\n<P>";
                                }
                        }else{
                                echo "Couldn't execute query";
                        }
                        echo "\n</BODY>\n</HTML>";
                        exit;
                }
?>
Dropping table "php_test"
<?php
                Error_Reporting(0);
                $res = odbc_exec($conn, "drop table php_test");
                if($res){
                        odbc_free_result($res);
                }
?>
 - OK<p>
Creating table "php_test":
<?php
                $res = odbc_exec($conn, "create table php_test (id char(32), gif $datatype)");
                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
            }
                        odbc_free_result($info);
?>
</table>

Inserting data:
<?php
                        echo "$gif1file - $gif2file - $gif3file";

                        odbc_free_result($res);
                        $res = odbc_prepare($conn, "insert into php_test values(?,?)");
                        if($gif1file != "none"){
                                $params[0] = "image1";
                                $params[1] = "'$gif1file'";
                                odbc_execute($res, $params);
                        }
                        if($gif2file != "none"){
                                $params[0] = "image2";
                                $params[1] = "'$gif2file'";
                                odbc_execute($res, $params);
                        }
                        if($gif3file != "none"){
                                $params[0] = "image3";
                                $params[1] = "'$gif3file'";
                                odbc_execute($res, $params);
                        }
?>
 - OK<P>
<A HREF="<?php echo "$PHP_SELF?display=y&dbuser=$dbuser&dsn=$dsn&dbpwd=$dbpwd" ?>">Display Images</A>
<?php
                }
        }
  } else {
?>
<form action=odbc-t5.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>

/* [<][>][^][v][top][bottom][index][help] */