<pre> 
&lt;?php
//===============================================================================
// Search the orders for any field that matches the search criterea 
//===============================================================================
    error_reporting(E_ALL ^ E_WARNING ^ E_NOTICE);      //all error but warnigns & notices

    session_start();                            //get a handle to session

    if (! $_SESSION['cust_id'])                 //if there is no session for customer                           
        header("Location: shop.php");           //redirect to login page
?>
&lt;html>
&lt;head>
&lt;title>Search data in database&lt;/title>
&lt;style>
a     {text-decoration:none; color:brown}
table {font-family:arial; font-size:11pt; background-color:f9f9f9; border:2px solid brown}
td    {border:1px solid gray} 
&lt;/style>
&lt;/head>
&lt;body bgcolor=lightyellow>
&lt;h1>&lt;center>The Ice Cream Shop&lt;/center>&lt;/h1>

&lt;?php

    $data = array();                            #define an array
    
    display_form();

    if ($_GET)                                  
    {
        read_data();
        display_result();
    }

//===============================================================================
// Display search form
//===============================================================================
    function display_form()
    {

        print "&lt;h3>Welcome back $_SESSION[cust_fname]&lt;/h3>";

        $search = $_GET['q'];                   #get the search argument
        $sort   = $_GET['s'];                   #get the sort order

        print "&lt;form method=get action=$_SERVER[PHP_SELF]>                
               Search for: 
               &lt;input type=text   name=q value='$search'>
               &lt;input type=submit        value=Search>
               &nbsp; use &lt;b>%&lt;/b> for all
               &lt;hr> \n";
    }

//===============================================================================
// Read / search for orders based on search criterea
//===============================================================================
    function read_data()
    {
        global $host, $data;   

        $host      = 'localhost';
        $DBname    = 'demo2';
        $DBuser    = 'demo2';
        $DBpswd    = 'demo2';
 
        $search = "'%". $_GET[q] ."%'";                         #wrap the search in % wildcards
        $search = str_replace(' ','%',$search);                 #for multi-words, insert % wildcard                                             

        if (!$_GET[s])                                          #if no sort order is provided 
             $_GET[s] = 'order_id-desc';                        #sort by last order_id

        $sort   = explode('-', $_GET[s]);                       #split on '-'
        $field  = $sort[0]; 
        $seq    = $sort[1]; 

        $connect = mysqli_connect($host,$DBuser,$DBpswd,$DBname);   #connect to db server 
        if (! $connect) 
            die('Could not connect: ' . mysqli_connect_error());

        $query = "SELECT firstname,lastname,address,flavor,topping,creditCard,order_id 
                  FROM cust_order
                  WHERE (cust_id = $_SESSION[cust_id])          
                    AND (lower(firstname) LIKE $search
                     OR  lower(lastname)  LIKE $search
                     OR  lower(address)   LIKE $search
                     OR        flavor     LIKE $search
                     OR        topping    LIKE $search
                     OR        creditCard LIKE $search
                     OR        order_id   LIKE $search) 
                  ORDER BY $field $seq";                        

        $cursor = mysqli_query($connect,$query);                #execute the query
        if (! $cursor) 
            die('Could not execute query: ' . mysqli_error($connect));
       
        $i=0;
        while ($row = mysqli_fetch_array($cursor))              #get each row as an array
            $data[$i++] = $row;                                 #store row in 2 dim array    

        mysqli_free_result($cursor);                            #free result buffer
        mysqli_close($connect);                                 #close connection
    }

//===============================================================================
// Display the list of matching orders in an HTML table
// allow sorting of columns 
//===============================================================================
    function display_result()
    {
        global $data;   

        $search = $_GET[q];                     #get the search argument
        $sort   = $_GET[s];                     #get the sort order

        if (! $search)
        {
            print '&lt;font color=red>Please enter search criteria, or % &lt;/font>';
            return;
        }

        $name_seq = ($sort =='lastname-asc')  ? 'lastname-desc'   : 'lastname-asc';
        $addr_seq = ($sort =='address-asc')   ? 'address-desc'    : 'address-asc';
        $flav_seq = ($sort =='flavor-asc')    ? 'flavor-desc'     : 'flavor-asc';
        $topg_seq = ($sort =='topping-asc')   ? 'topping-desc'    : 'topping-asc';
        $card_seq = ($sort =='creditCard-asc')? 'creditCard-desc' : 'creditCard-asc';
        $ordr_seq = ($sort =='order_id-asc')  ? 'order_id-desc'   : 'order_id-asc';

        print "&lt;table width=800> 
               &lt;tr bgcolor=tan>
               &lt;th>&lt;a href=$_SERVER[PHP_SELF]?q=$search&s=$name_seq>Name&lt;/a>
               &lt;th>&lt;a href=$_SERVER[PHP_SELF]?q=$search&s=$addr_seq>Address&lt;/a>     
               &lt;th>&lt;a href=$_SERVER[PHP_SELF]?q=$search&s=$flav_seq>Flavors&lt;/a>     
               &lt;th>&lt;a href=$_SERVER[PHP_SELF]?q=$search&s=$topg_seq>Toppings&lt;/a>    
               &lt;th>&lt;a href=$_SERVER[PHP_SELF]?q=$search&s=$card_seq>Credit Card&lt;/a> 
               &lt;th>&lt;a href=$_SERVER[PHP_SELF]?q=$search&s=$ordr_seq>Order Num&lt;/a> 
               &lt;th width=110>Action&lt;/th> \n";

        foreach($data as $row)
        {
            $first      = $row[0];
            $last       = $row[1];
            $address    = $row[2];
            $flavor     = $row[3];
            $topping    = $row[4];
            $creditCard = $row[5];
            $order_id   = $row[6];
                
            $address2  = nl2br($address);                       #change all \n to &lt;br>
            $flavor2   = str_replace("," , "&lt;br>", $flavor);    #put multiple values
            $topping2  = str_replace("," , "&lt;br>", $topping);   #on separate lines

            print "&lt;tr valign=top>";
            print "
                   &lt;td>$first $last&lt;/td>&lt;td>$address2&lt;/td>&lt;td>$flavor2&lt;/td>
                   &lt;td>$topping2&lt;/td>&lt;td>$creditCard&lt;/td>&lt;td>$order_id&lt;/td>
                   &lt;td>&lt;a href=shopDBUpd.php?order=$order_id>&lt;img src=update.gif title=update border=0>&lt;/a>
                       &lt;a href=shopDBUpd.php?order=$order_id>&lt;img src=delete.gif title=delete border=0>&lt;/a>&lt;/td> \n";              
        }    

        print "&lt;/table> &lt;hr>\n";
    }

//===============================================================================

?>

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

&lt;center>
&lt;base href=/~sultans/php/demo/5session/shop/ >
&lt;a href=shopCart.php>   shop          &lt;/a> |
&lt;a href=shopDBAdd.php > checkout      &lt;/a> | 
&lt;a href=shopDBList.php> list orders   &lt;/a> |
                        search             |
&lt;a href=shopProf.php>   profile       &lt;/a> |
&lt;a href=shop.php?out=y> logout        &lt;/a>
&lt;/center>
&lt;/body>
&lt;/html>
</pre>