So You Want Your Own Searchable Database, Huh?
WEBINAR: On-demand webcast
How to Boost Database Development Productivity on Linux, Docker, and Kubernetes with Microsoft SQL Server 2017 REGISTER >
My guess is that most of you came by this page through using the Goodies Search Engine or through the Database tutorial.
Either way (or neither way) this tutorial will finally answer one of the most asked questions in the Goodies mailbox -- How do I set up a searchable database for my own Web site?
If you haven't yet seen my search engine work, here's a link to it. Give it a try and see if you like it. I do.
Okay, enough yackin'! (Can you "yak" in writing?) Let's make a database.
First you need the script. I have a link to it below. But first, please understand that the author has a few requirements for you to use this script:
- Keep the copyright comments in place.
- Do not alter the script except to add your pages to search.
- If you are a non-profit site, you may use it as long as you keep the copyright comments in tact.
- If you are a for-profit site, you must first ask the author's permission.
You'll notice in my database version that a line was added by the author stating that I have permission to use it, as HTML Goodies is a for-profit site.
Read what's below... please?!
I cannot stress this enough: You must get the entire script and this is a big pup. I have tested the script you get above three times. It works. If you download it and it doesn't run, it is either your browser, the download, or the use of margins when you edited it.
In all honesty, 99% of all troubles people have with scripts from my site are solved by losing the margins. Here's a tip: When you get an error, go to that line (from the top of the page, not the top of the script), and see if moving the line below it up doesn't solve the problem. Also, fix one error at a time. Do the one earliest in the script first. You see, that may be the only true error. The others may be caused by that one goof-up.
Read what's above... please?!
Now that you have the script, you'll need to change one thing, and begin adding your pages to the script. Let's start with adding items to search. See these little groupings about halfway down the script?
title[#]="yahoo search engine"
desc[#]="the yahoo search engine"
- title[#]="yahoo search engine"
The words inside the quote marks are the words the script searches. Separate the words you put in by a space. These are the items searched, so make them descriptive. There is no limit to how many you can use, but remember, the more you use, the larger the script, thus the longer it takes to load and search.
- desc[#]="the yahoo search engine"
This is the description that appears on the results page.
The is the link that is offered.
Don't touch this except to change the # to a number. This stays the same no matter what number of pages you enter.
- Be sure to make the number increase as you add pages.
You will use the same number for each grouping. The first grouping of four all get the number 1. The second group of four all get the number 2, and so on. If you fail to do this, you will get a lot of errors -- one for every page out of order.
Just add pages until you get in all you want to be searched. Once you're done, look for this line in the script:
Change that number 6 to whatever number of pages you have entered. My Goodies Search page has 96, I think. If you don't change the number, only the first six will be searched.
That's how you do it. It's time-consuming, let me tell you, but worth it. Just remember, the more pages and code words that you use, the larger the page will be and the longer it will take to search and download.
Hopefully this will help a great deal. It will certainly lighten my e-mail.