Welcome to WebmasterWorld Guest from 220.127.116.11
Do you already have the database? Do you need to create it, and periodically update it?
Any CMS should provide the necessary tools to do this.
Otherwise, probably some custom programming - PHP, Perl, whatever with MySQL. It's unlikely you are going to find something already written tailored to your unique requirements.
And that's what I would use - a textbook.
Pick up any good tutorial book on, say, PHP and MySQL (there are many books out on that combination), and there will almost certainly be a follow-along simple database application, that they will probably use for several chapters. Likely a simple name-and-address database, etc.
You'll be killing two birds with one stone. You'll be solving your immediate problem. And you'll be learning some skills that you'll find quite useful in the future.
Sounds like you need a simple Perl regular expression search. That way it is easy to return the page or article containing the relevant text.
No, not in this case. The original post is a bit confusing, as it says "I would like to add a search to my site...".
He's not interested in adding a "site search", but a simple database that users can look stuff up in, as an additional site feature.
The data isn't currently on the website or in a database. (The author stickied me with some details.)
He has a list of numbers that each correspond to a set of words.
You enter a word, it tells you the number. You enter a number it tells you the words.
Simple database schema, one table.
Duplicate ids allowed. Duplicate words not allowed. The primary key would be id+word, with id and word and additional keys.
With no details of the posters hosting plan of level of technical knowledge, interest in learning programming, etc. it's hard to give concrete advice, though.
To put it in the most basic terms, though:
- You will need to have a database package (for example, MySQL) installed on your host.
- You will need to have some scripting language (e.g. PHP, Perl, etc.) on your host.
- You will need to create a database schema (layout).
- You will need to create a form for inputting the search criteria.
- You will need to do a bit of programming to take the form data, do a database lookup, and format a results page.
- You might have to do a bit of server configuration
For an experienced web developer, this is certainly less than a day's work - perhaps as little as a couple of hours.
For a newbie with no experience - perhaps weeks - but it will be fun! :)