dbUtils is a simple, pure-PHP solution which allows anyone to manage multiple mySQL databases and tables. dbUtils currently consists of 5 functions to allow you to accomplish a number of copying, moving, renaming, and general management tasks. Designed originally for database backup without the need for command-line access or telnet access, but expanded to provide functions normally not available in most database management front-ends like phpMyAdmin.
Builds on PEAR DB to abstract datatypes and automate table creation, data validation, insert, update, delete, and select; combines these with PEAR HTML_QuickForm to automatically generate input forms that match the table column definitions.
doSQL() is a PHP4 script that can dump data back from a SQL text file (generated by backupDB() (also available on this site), phpMyAdmin, or similar) to a new database, or run any number of SQL commands in batch mode. Detailed progress reporting, including time remaing, processing rate (text and graph available).
This function returns an array of 3 values that makes browsing through your SQL results, or any other list of results, very easy. The navigation bar looks very similar to ones used in most sites [ <<6 7 8 9 10>> ]. You can limit the amount of rows displayed, the amount of page numbers to display, the previous and next buttons/text. etc.
Easily access your MySQL databases with this set of PHP classes. If you program using the ADO object model, you will find these methods and properties familiar.
EasySQL is a PHP application to easily connect to your MySQL database with just 1 php file and 3 easy steps. Useful for beginners, it lets you easily interact with a mysql database using only your web browser. Features: Automatic table formatting, reusable query, javascript assisted features, syntax help file and full versioning control for easy updates. Username and password security can be added with an optional, [free] addon sister product - Admin-Login-Only.
Very simply Echelon allows you to create an HTML form with the action pointed to the Echelon script and Echelon will automatically create the SQL on the fly, connect to the database, and execute your query. This allows the web developer to modify database information very quickly when using HTML forms. 1.3 update: This version includes improved security and error checking.
