Creating a Search page

6 posts by 2 authors in: Forums > CMS Builder
Last Post: July 13, 2010   (RSS)

By dsternalski - July 11, 2010

Hi,

I've added a search form onto the site and have made it so that when you search for your keywords, it's goes to the search page. However, are you able to help me with the code that searches the table and displays the relevant information?

please find attached the code with the search panel and the listview page.
Attachments:

listview.php 5K

navigation_009.php 8K

Re: [dsternalski] Creating a Search page

By Jason - July 12, 2010

Hi,

Can you tell me which fields in the "contact" table you are trying to search on?

Let me know and I can help you build the appropriate "WHERE" clause.

Thanks.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [dsternalski] Creating a Search page

By Jason - July 12, 2010

Hi,

Okay, could you let me know exactly what you're searching for?

Thanks
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Creating a Search page

By dsternalski - July 13, 2010

Hi,

The search will be used to search all of the site, so when a user adds a word into the keyword search, a page then appears with the results.

Re: [dsternalski] Creating a Search page

By Jason - July 13, 2010

Hi,

CMS Builder is used to search for records and fields that are inside the database, and doesn't come setup by default to do site wide searches.

I think you may be looking for something like a google site search. Take a look at this:
http://www.google.com/sitesearch/#utm_campaign=en&utm_source=en-ha-na-us_ca-sk&utm_medium=ha&utm_term=site%20search

Let me know if you have any other questions.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/