Phrozen


CJ's Technical Playground
Warning: Most of these code examples are from 10-13 YEARS ago (OLD STUFF). All projects listed here are currently UNMAINTAINED, available for HISTORIC purposes only.
ASPCorbaJavaJavaScriptLinuxMySQLPerl
PHPPython and JythonShockwaveVRMLXML


Back To My Resume

MySQL
Search Engine/Site Index: A very large, useful database on my IIS server containing all the most frequently-used, pertinent information about all of my urls. The database contains two tables.  The first table called 'keywords', indexes every word in all of my pages (several thousand rows).  (see a picture)

The table called 'thesites' is used mainly for creating the Yahoo-style index, by grouping related pages together under the column named 'itsgroup'.  For instance, all versions of my AOL home pages are grouped under the number 1, all of my NYC sites under 2, etc.  (see a picture).  So, when I want to pull out all NYC, I can just throw an SQL query like: SELECT * FROM thesites WHERE id='2'  I know what you're thinking: why didn't I just add the 'itsgroup' column to the table called 'keywords', making just one table instead of two?  Simple, the 'thesites' table is easier to maintain in terms of changes in URL locations, page titles, etc. because it contains fewer rows = fewer rows to update = can be updated more frequently.  'Thesites' has 65 rows, while 'keywords' has several thousands or rows.  Using the 'thesites' table as a point of reference and throwing out a SQL query like : 

SELECT DISTINCT thesites.url, keywords.thetitle, thesites.itsgroup,thesites.thedate FROM keywords,thesites WHERE keywords.keyword LIKE '%$searchword%' AND thesites.url=keywords.url
I can ensure that the search results will return the most current information in the database.  I have my web pages stored under a few different user names, so I use MySQL to help me keep track of all my pages, images, etc and to search my sites.  Below is a PHP3 script I use to extract information from the MySQL database to create a Yahoo-like index as the home page on my IIS/PWS server. Also, I've provided an abbreviated version of the dump file I used to create the database for my "Yahoo" index.  The entire version is over 3 MB, so I won't be posting it here, but the abbreviated version is 40KB.
abbreviated dump file
php3 file
Snapshot of Yahoo-style index:
Accessing Keyword Search Engine: - php3 file