Search multiple fields
5 posts by 2 authors in: Forums > CMS Builder
Last Post: March 21, 2012 (RSS)
By benedict - March 16, 2012
Hi guys,
Using your search engine for the first time, but it does not seem to be working too well. I want the search to search across a product code, supplier code or description.
My search field is this:
And it just goes to products_search.php which is just a normal list viewer page.
Is there anything I'm missing? Am I able to search multiple fields in the one search form?
Using your search engine for the first time, but it does not seem to be working too well. I want the search to search across a product code, supplier code or description.
My search field is this:
<form method="POST" action="products_search.php" class="search-form">
<fieldset>
<div class="input-bg">
<input class="searcharea" name="supplier_barcode, code, description_keyword" type="text" value="Product Search"/>
</div>
<input class="search-btn" type="submit" value="" title="search" />
</fieldset>
</form>And it just goes to products_search.php which is just a normal list viewer page.
Is there anything I'm missing? Am I able to search multiple fields in the one search form?
Re: [benedict] Search multiple fields
By (Deleted User) - March 20, 2012
Hi benedict,
When the form submits it sends all the post data to products_search.php which then uses that data to limit the records it loads for display.
At the top of products_search.php you should have something like:
I've added the if statement in case you want to display a message about not having entered any search criteria.
You can then manipulate the returned results as you need to.
Hope this helps,
Tom
When the form submits it sends all the post data to products_search.php which then uses that data to limit the records it loads for display.
At the top of products_search.php you should have something like:
if ( @$_REQUEST['supplier_barcode, code, description_keyword'] != '' ) {
// load records
list($records, $recordsMetaData) = getRecords(array(
'tableName' => {the table},
'perPage' => {the number of results per page, if desired},
));
}I've added the if statement in case you want to display a message about not having entered any search criteria.
You can then manipulate the returned results as you need to.
Hope this helps,
Tom
Re: [Tom P] Search multiple fields
By benedict - March 20, 2012
Thanks Tom - I'm aware of that.
I found the issue - I had spaces in the name of the search box.
Should have been:
I found the issue - I had spaces in the name of the search box.
Should have been:
<input class="searcharea" name="supplier_barcode,code,description_keyword" type="text" value="Product Search"/>Re: [benedict] Search multiple fields
By (Deleted User) - March 21, 2012
Hi benedict,
I needed more coffee yesterday it seems!
Good catch.
Tom
I needed more coffee yesterday it seems!
Good catch.
Tom