22 projects tagged "CGI Tools/Libraries"
im2html walks a directory hierachy filled with categorised images and makes HTML indices and thumbnails for everything. It's easy to customise the titles of each page, add descriptive HTML for images or the page as a whole, add references to related web pages etc. It's incremental, so you can run it nightly in a cron job to keep things up to date, reducing most maintenance to "copy the image into the right subdirectory and wait overnight". It's careful to not rewrite index files unless their contents change, making maintenance of a remote gallery from your master copy with a tool like rsync efficient.
clsDB.inc is a PHP class for making connections to a MySQL database. Its features include error checking, error logging, optional error output, email notification of errors, devel mode for a development server, and test mode for outputting the queries to a page with or without execution. It returns pertinent information when the query is run (number of records updated, insert id, etc). Results are left as a MySQL result so that they may be manipulated by any MySQL functions. The class can also perform table grooming.
WebMySQL is a Web interface to a MySQL database server. It supports the following SQL queries: SELECT, DESCRIBE, JOIN, SHOW, DROP, CREATE, and USE, and advanced query options such as LIMIT, DISTINCT, and GROUP. Empty databases and tables and mysqldump file imports and exports are supported. It has a fully customisable look and feel, and outputs either HTML results or a downloadable CSV file.