Free database driven web software for linux

Database Functions is a PHP class that can be used to build and execute MySQL database queries.

It can build SELECT, INSERT, UPDATE and DELETE queries from lists of parameters and values.

The class can also execute the generated queries and retrieve the SELECT query results into associative arrays.

AOLserver is a multithreaded, Tcl-enabled, massively scalable and extensible Web server tuned for large scale, dynamic Web sites.

AOLserver includes complete database integration, dynamic page scripting, and an open, extensible architecture.

Used Textbook Database provides a database for listing used textbooks.

Used Textbook Database is a Web-based textbook database that lets users to create an account and list their used textbooks or books.

It is very modular and customizable and allows for easy integration into an existing Web site.

Car Dealer Website allows you to get your car dealership inventory on the Web. Car Dealer Website projects easy-to-use system features full searching capability by make/model, price range, and year range.
Each listing has a contact form where buyers can easily make contact from your site on a particular vehicle.
You can upload as many images as needed per listing and setup as many makes and models as needed for your dealership. It is fully template driven, and is easy to customize.
Installation:
-copy all files to your web host
-use phpmyadmin or your mysql interface to run site.sql against your database.
-chmod 777 upload/ and upload/tmp/
-open site.xml and edit the database section with your database details.
-go to admin/ and login with username of admin with a password of test.
-be sure to change the passwords for the admin and regular user.
Setup the site.xml file with your database settings as follows.
< database type="mysql" >
< server >database server address< /server >
< login >database login< /login >
< password >database password< /password >
< default >mysql database name< /default >
< /database >
Add this to your htaccess file to prevent viewing of the xml config file.
< Files ~ ".xml" >
Order allow,deny
Deny from all
Satisfy All
< /Files >
Enhancements:
- Some of the lines of code within the library files were fixed up to improve the speed of the system.

uni PHP DataGrid is a simple, innovative and powerful tool for generating data-bound grid control, specially designed for Web developers. It is useful for all PHP database- driven Web site and online-based data administration.
It is also useful for dynamic content management and PHP-based hosting providers. The goal is to make free PHP DataGrid generating and editing as simple as possible for Web developers.
Enhancements:
Added:
- ability to define array of page sizes
- case sensitivity (filtering mode)
- ability to define search field to be a dropdown box (filtering mode)
- ability to add optional column in datagrid by editing SELECT SQL statement
- new css template (default)
- ability to define column data to be a link on edit mode page ("linktoview" in setColumnsInViewMode())
Improved:
- setModes()
- css class "default"
- working with $_REQUEST vars
Fixed bugs:
- in filtering mode
- in tabular layout drawing
- in columnar layout drawing
- in paging after search
- empty table bug

Audio::DB::Web is a Perl module that assists in web-based queries of an MP3 Database.

SYNOPSIS

use Audio::DB::Web;
my $mp3->

Audio::DB is a module for creating relational databases of MP3 files directly from data stored in ID3 tags. Once created, Audio::DB provides various methods for creating reports and web pages of your collection. Although its nutritious and delicious on its own, Audio::DB was created for use with Apache::Audio::DB, a subclass of Apache::MP3. This module makes it easy to make your collection web-accessible, complete with browsing, searching, streaming, multiple users, playlists, ratings, and more!

Apache::TimedRedirect is an Apache (mod_perl) TransHandler.

SYNOPSIS

use Apache::TimedRedirect;

requires TimePeriod be installed (go to nearest CPAN)
requires Apache have mod_perl installed.

httpd.conf entry...

**** NOTE ***

CANNOT be inside < LOCATION >< /LOCATION > tags
PerlTransHandler Apache::TimedRedirect
PerlSetVar B< redirecturl > http://www.somewhere.far/
PerlSetVar B< timewindow > hr {6am-8pm}
PerlSetVar B< uriregex > foo|bar|do or maybe ..*(foo)>
PerlSetVar B< log > 1
PerlSetVar B< excludeip > 127.0.0.0

Apache::TimedRedirect is a mod_perl TransHandler module that allows the configuration of a timed redirect. In other words if someone enters a a website and the URI matches a regex AND it is within a certain time period they will be redirected somewhere else.

It was first created to politely redirect visitors away from database driven sections of a website while the databases were being refreshed.