www.mithril.ca

PHP Code Samples :: MP3 Database Search Script

Web-Based Apps
phpClassifieds Demo
MP3 Database Search
MP3 Search Engine
Search Engine
Mithril Web Mail
Photo Gallery
Code Samples
PHP
    - DB Abstraction Layer
    - Site Usage Tracker
    - MP3 Database Search
    - MP3 Search Engine
    - Search Engine
    - Employee's Section
    - phpClassifieds Demo
PHP-GTK
    - mediaCat-GTK v2.0.8
Visual Basic
more info.....
Links of Interest
php.net
gtk.php-net
OSDN.org
SourceForge.net
Corrado Club of Canada
The Onion
more links...
Personal Info.
About Geoff A. Virgo
View my Resume
Site Statistics
Contact the Sys. Admin
This is a relatively simple database search application designed towards indexing and search mp3 collections, however it can be easily adapted to query and display just about any database table.  The application does not give any information regarding the server's file system to the end user and does not link to any specific mp3.  Up to two category/sub-category levels can be specified for each record with SQL queries are generated at run time based on the information the user has provided in the search form.  There are no web-based record administrative functions, but the records can be added, modified, and removed from the database using medaCat-GTK.  mediaCat-GTK must be run on the same local network as the webserver, and there is currently no plan to add remote administrative capablities as that would be very insecure.

Features:

  • compartmentalized into two functions allowing for easy integration into an existing site
  • font and table background colours/images are variable defined
  • full abstraction layer separating the database interface with the rest of the application
  • user controls which table fields to display in a result set
  • user can control text wrapping with cells of the results table
  • searches can be limited to either broad or narrow parameters
  • number of rows displayed per page can now be limited

The following links will allow you to either view or download the source code.  If you find my script useful, please sign my guestbook or link to my page.

View the script's source codeDownload the script


Page generation: 0.034666 sec