[PHP] search array

[Russell Brackett]

I need help with this code to echo all items in the general database and not 
just the fields I'm searching for.....

<?php

// filter function
function cleanInput($input) {

                $search = array('OEM Name, Category, OEM Name');

                $output = str_replace($search, '', $input);
                return $output;
}
                //define layout name
                $layoutName = 'SYSTEMS CONFIGURATOR';

                //block for pagination
                if(isset($_GET['page']) && !empty($_GET['page'])){
                                $page = $_GET['page'];
                }
                else{
                                $page = 1;
                }

                $max = "20";
                $skip = ($page - 1) *  $max;

                // grab their search query and clean it
                if($_POST){
                                $searchQuery    = $_POST['q'];
                                $_SESSION['searchQuery'] = $searchQuery;
                }
                else{
                                if(!isset($_SESSION['searchQuery'])){
                                                header('location: index.php');
                                }
                }
                //$searchQuery                = "amat";

                // sanitize
                $cleanInput = cleanInput($_SESSION['searchQuery']);

                // Add 1st request for serial number
                $findSerial = $fm->newFindRequest($layoutName);
                $findSerial->addFindCriterion('OEM Name', $cleanInput);


                // Add 2nd request for category
                $findDesc = $fm->newFindRequest($layoutName);
                $findDesc->addFindCriterion('Category', $cleanInput);
                // search the description field
                //$find->addFindCriterion('description', $cleanInput);

                // sort the results
                //do a compound find with above two search conditions
                $compoundFind = $fm->newCompoundFindCommand($layoutName);
                $compoundFind->add(1, $findSerial);
                $compoundFind->add(2, $findDesc);
                $compoundFind->addSortRule('Serial #', 1, 
FILEMAKER_SORT_ASCEND);

                // set skip and max values
                $compoundFind->setRange($skip, $max);

                // run the search
                $result = $compoundFind->execute();
                $records = $result->getRecords();

                //get found count and get total page number
                $foundCount = $result->getFoundSetCount();
                $totalPage = ceil($foundCount / $max);

                // create the smarty object
                $smarty = new Smarty();
                $smarty->force_compile = true;
                $smarty->debugging = false;
                $smarty->caching = false;
                //$smarty->cache_lifetime = 120;
?>
Russell Brackett
Web Developer

Capitol Area Technology
3500 Comsouth Suite 500
Austin, Texas, 78744
rbrack...@capitolabs.com<mailto:c.h...@capitolabs.com>
Office 512-610-3246
Cell 979-412-3018

Capitol Area Technology:
Integrity-Courtesy-Customer Satisfaction