HOME/Database Tools

This script was born out of necessity for me. I was creating quite a few reports that are to be extracted from MySQL database. Format them into a table like structure, with or without headers. And be able to view as HTML, download as HTML, or download as EXCEL. All settings to generate a report can ...click here for more

This is a code developed to pull data from mysql db and create a drop down menu. the menu choice when selected shows the corresponding data text in a textarea box below it. search and search for something similar - couldn`t find it. This is the result of that. thought others could use it....click here for more

The Flatfile package is designed to be a simple, light replacement for an SQL database when the performance of a real database is not needed, or when in the prototyping stage. All data is stored in tab-delimited text flat files. It supports a very powerful and extensible WHERE clause mechanism, whic...click here for more

Search a database for a certain item, name, etc. and have it return what you searched for and a link that corresponds to that item or name that was searched for. Great for small databases and large databases alike....click here for more

RDLDB is a hierarchy-related flat file database management system written in PHP5. It is developed with the idea of easier web development, for the people without access to MySQL or similar database management systems. It is also intended for the web developers, who wish to be free, and to be able t...click here for more

A class that handles common MySQL functions: - Connect - Query - Close Connection - Get Number of Rows returned - Get the Number of Affected rows by update or insert opreations - Fetch resultset (as array,assoc or object) - Free Result in Memory - Display Custom error message - Display MySQL generat...click here for more

phpBackupMySQLdiff is a Web Application to do MySQL differentials backup into XML files compressed ("zip" or or "tar" "tar.gz"): - Just save the structure" and the "rows" changed - Restore the data into SQL queries - Select two date to restore the data - ...click here for more

This script converts user entered 12-hour time to the 24-hour time used by mySQL. It was written to aid in the development of web forms using PHP and the time field type in mySQL. The form submits to itself, minimizing the number of files you must modify. It also includes default variables making in...click here for more