|
In http://gigantor/phpmyadmin/ and create the table.
I chose utf8-general-ci as it is a common encoding standard and it ignores CASE (useful in a search engine when you cannot readily control how your users input their search string) |
|
When you save the table, you get a confirm screen similar to the following - nice as you can edit any oddities [generally a good idea BEFORE you add any data] |
|
Next, insert a couple of rows of data - it is IMPOSSIBLE to test if an application is working right without some real-looking data. 2 rows should be sufficient for initial testing |
|
BROWSE the data to ensure it has made it into the table successfully |
|
Define a search form as the index.htm for your searcheriz0r folder - this makes it the default page for the browser.
Make the action POST and the target file results.php |
|
create a new file called results.php, add scripting to connect to the database, define a dumb (at this stage) query that goes and gets everything, and that then displays it sort of formatted as follows |
|
Searcherize for the first time, remembering that we are just jumping to an "all records" retrieval request.
You should see ALL rows of data entered - ordered by VOTES |
|
now we refine the query - edit your results.php file, remembering that the form POSTs the search term to a variable called "keyword" in the HTTP_POST_VARS memory on Gigantor. When next you use your searcherizOr, you should be able to search on the nominated term. |
|
Now edit your index.htm and add a link to the addlink.htm page |
|
create the addlink.htm page with a form named adddata, put in a table and ensure there are labelled textfields for
newurl, newsitename, newcategory, newwhoadded, newdescription
but NOT for urlid, dateadded or votes (why?)
add a submit button, labelled "add my site"
have it's action POST and the target file addit.php
|
|
compose a file called addit.php that performs an INSERTINTO your urlbank table and then re-directs back to the searcherizOr
... you know you want to :P |
|
|