<pre> 
﻿&lt;head>
&lt;title>Image Search&lt;/title>
&lt;/head>
&lt;body bgcolor=lightyellow>
&lt;h1>&lt;center>Image Search&lt;/center>&lt;/h1>
&lt;img id='e1' style='position:absolute; top:225; left:630;' >


&lt;?php

    error_reporting(E_ALL ^ E_WARNING ^ E_NOTICE);              //turn off PHP warnings & notices only

//  require "dbIO.php";                                         //include the dbIO.php file 
    require "/home/sultans/web/php/demo/4http/dbIO.php";        //make it absolute so it works with PHP*Tester

    $msg;

    if ($_POST)                                                 //if data was collected in $_POST array
    {
        retrieve();
        searchDB();
    }
    display();

//=============================================================================
    function retrieve()
    {
        global $type, $search;

        $type    = $_POST['type'];                              //get HTML form entry fields
        $search  = $_POST['search'];

        if (strtolower($type)!='book' &&  strtolower($type)!='software') 
            $type  = 'book';

        if ($search == '' || $search == ' ') 
            $search = '%';
    }
    
//=============================================================================
    function searchDB()
    {
        global $type, $search, $msg;

        $sql = "SELECT * FROM image
                 WHERE  type = '$type'
                   AND (name    LIKE '%{$search}%'
                    OR  owner   LIKE '%{$search}%'
                    OR  keyword LIKE '%{$search}%')"; 
        
        $data = dbIO('localhost','demo2','demo2','demo2', $sql);        //call the dbIO with the SQL    
        
        if (is_string($data))                                           //if string -> must be an error
            $msg = $data;
            
        if (is_numeric($data))                                          //if num -> must have been a update statement 
            $msg = $data . ' rows affected';                            //not used in this script

        if (is_array($data))                                            //if array -> must be a SELECT statement 
        {
            $msg .= "&lt;table border=1 width=600> \n";            
            $msg .= "&lt;tr bgcolor=tan>&lt;th>Name&lt;th>Author/Owner&lt;th>Keywords&lt;th>Image&lt;/tr> \n";

            for ($i=0; $i &lt; count($data); $i++)                                 //loop thru all the rows
            {
                $row = $data[$i];                                               //each row

                $msg .= "&lt;tr valign=top> \n";

                foreach ($row as $col_name => $col_value)                       //loop thru each row
                {                                   
                    if ($col_name=='name' || $col_name=='owner' || $col_name=='keyword')
                    {                                       
                        $col = preg_replace('/,/', '&lt;br>', $col_value);         //replace , with &lt;br>
                        $msg .= "&lt;td> $col &lt;/td> \n";
                    }
                    if ($col_name == 'filename')
                    {                                       
                        $url  = "/~sultans/javascript/demo/img/$col_value";

                        $msg .= "&lt;td>&lt;img src=$url height=100 width=70 
                                      onMouseOver=document.getElementById('e1').src='$url'>&lt;/td>";                 
                    }
                }
                $msg .= "&lt;/tr> \n";
            }
            $msg .= "&lt;/table> \n";
        }            
    }

//=============================================================================
    function display()
    {
        global $type, $search, $msg;
        global $search_error;

        if ($type == 'book')     $book_sel = 'selected';
        if ($type == 'software') $soft_sel = 'selected';
        
        print "&lt;form method=POST action=$_SERVER[PHP_SELF]> \n";        //itself
        print "&lt;table bgcolor=tan border=3 outset> \n";
        print "&lt;tr>";
        print "&lt;td>&lt;b>Image category:";
        print "&lt;td>&lt;select name=type> \n";
        print "    &lt;option value='book'     $book_sel>Books   &lt;/option> \n";
        print "    &lt;option value='software' $soft_sel>Software&lt;/option> \n";
        print "    &lt;/select> \n";
        print "&lt;tr>";
        print "&lt;td>&lt;b>Search:  &lt;font color=red> *$search_error &lt;/font>";
        print "&lt;td>&lt;input type=text name=search value='$search' size='30'> (any keyword or %) \n";
        print "&lt;tr>";
        print "&lt;td width=75>";
        print "&lt;input type=submit value='      Search      '>";
        print "&lt;td>";
        print "&lt;input type=reset  value='       Reset       '>";
        print "&lt;/tr> \n";
        print "&lt;/table> \n";
        print "&lt;/form>";
        print "&lt;hr> \n";
        print "$msg";
    }
?>

&lt;?php include "../include.php"; ?>              &lt;!-- hyperlink to see the code -->
&lt;/body>
&lt;/html>
</pre>