Database Tools

Micro DB Installer is a small PHP script which helps you to automate MySQL database creation. If you don't want to use web your existing web admin interface or you want to extend your script with easy DB installation then you can use this tool.

Micro DB Manager is a database abstraction class written in PHP using object oriented technologies. The class realize the following functionalities: * Connectiong to the databse * Executing queries * Converting results to associative array * Get selected rows * Get affected rows * Get last insert id * Get the number of executed queries * Get the execution time of the queries * Get error messages and codes ...
(show more)
(show less)

Micro Database Browser is a simple PHP script which can list your available databases, tables and displays data stored in it. It's purpose to give you an easy installable product to verify your actual DB status without installing professional database management tools. ...
(show more)
(show less)

This small tool helps you to convert your MySQL database layout into XML. Just specify connection informations and you can display or save the generated XML output.

Xataface (formerly Dataface) is a flexible and shapeable skin that sits on top of MySQL making it accessible to normal, every-day users. In practical terms, it automagically generates the appropriate forms, lists, and menus for a user to interact with the database without having to know any SQL (structured query language). It is also a full-featured web application framework which gives developers the flexibility to customize the features and behavior of their application by way of configuration files (using the simple INI-file syntax), templates, and plug-ins. The real power lies in a developer's ability to customize as much or as little about the application as he wants. A generic Xataface application is fully functional out of the box, but it can be customized and extended easily to make the application fit any requirements....
(show more)
(show less)

Staggered import of large and huge MySQL Dumps (like phpMyAdmin dumps and even GZip compressed dumps). Do you want to restore the huge backup of your mySQL database (or a part of it) into the new or the same mySQL database? You can't access the server shell and you can't import the dump using phpMyAdmin due to hard memory/runtime limit of the web server. BigDump will do it even through the web servers with hard runtime limit and those in safe mode in a couple of short sessions....
(show more)
(show less)

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 more. Username and password security can be added with an optional, [free LGPL] addon sister product - Admin-Login-Only....
(show more)
(show less)

PHPMaker is an automation tool (for Windows) that can generate a full set of PHP scripts (for any Windows/Linux server or other server that PHP supports) quickly from MySQL database. Using the generated PHP, users can view, edit, search, add and delete records in the database easily on the Web. Clean and straightforward codes which are easy-to-customize. This useful tool can save you tons of time and is suitable for both beginners and experienced PHP develpers alike. Support BLOB, ENUM and SET data types. PHPMaker supports Advanced Security with built-in Administrator and Anonymous user level, User Registration System with option to send confirmation email, Custom View with query builder, Report, ASP.NET style Inline Editing, Export to HTML/Word/Excel/CSV/XML, Multi-column Sorting, User Selectable Page Size, Table-specific List Page Options, Dynamic Table Loading, Composite key, Inline Delete, Highlighted and Selected Row Colors, etc. ...
(show more)
(show less)

DB-RSE is a PHP program intended to be a very simplified MySQL database record selector and editor. Having only two files, it is simple to install and setup. Just put both files in a folder (preferably either secure or obscure), modify the dbconnect.php file, and load the main file in your browser. It also acts as a back-end to its parent program, "Form-a-Form -- Quick and Simple Form Creator for PHP"....
(show more)
(show less)

PHP AJAX DataGrid - is a powerful script, that allows you to display data in grid layout. It is very simple to set up and works with AJAX module.

This script will allow a user (with no MySQL knowledge) to display results from a database on their web site. This is also simple to customise and is completely free. If you do anything really cool, then send me a copy back so I can include it next time....
(show more)
(show less)

PHP Report Maker is a powerful reporting tool that can generate dynamic PHP Web reports from MySQL database. You can instantly create live detail and summary reports or crosstabs reports for your Websites. Basic Flash charting (Column, Bar, Line or Pie charts) is also supported. The generated Web pages are pure PHP, no server-side or client-side components are required. PHP Report Maker is designed for high flexibility, numerous options enable you to generate the reports that best suits your needs. The generated codes are clean and easy-to-customize. PHP Report Maker can save you tons of time and is suitable for both beginners and experienced developers alike....
(show more)
(show less)

Simple free Web based MySql database query tool. This free DBQ script is to add, save, manage user queries and query mysql database. This script is written in php.

The Advanced MySQL Database Class is probably one of the simplest database objects/classes to use for PHP. Once the object is created, the number of lines of code that you need to use for any function in this class is just 1! Any query at all can be called and return a result whether it be data or true/false. Other things this class can do is: retrieve database information, backup one or all of your databases to either a SQL string variable or a SQL file, execute queries from a SQL file, print a results table, and sort a non-indexed table's records....
(show more)
(show less)

When it comes to web DataGrids, fast loading of large data combined with advanced Excel-like operations has been always a challenge. Having a solid experience in web technologies, we designed our AJAX powered PHP Grid to eliminate this tradeoff. Easy-to-use, rich client-side API, myriad of features topped with an unbeatable performance is what we call KoolGrid. Key features: Very easy to use, simple PHP code. (1) Rich client-side API and events (2) AJAX Capability (3) State persistence through postback and ajax callback (4) Support Auto CRUD (5) Scrolling with position persistence (6) Sorting (7) Filtering (8) Grouping (9) Row Selecting (10) Form and Inline Editing (11) Localization (12) Many skins are available to choose. (13) Skin can be all customized as wished. View and Download Now!...
(show more)
(show less)

A basic wrapper class for the MySQL database engine. Contains methods for connecting to a database, fetching and returning results, building insert and update queries, optimization and more. * Creates a persistent connection to a specified database * Can store and connect to multiple databases * Stores the connection within a Singleton instance * Logs queried information and total executed queries * Binds variables to SQL statements; similar to PDO * Cleans all binded data to prevent mysql injection * Fetches data as an object or an associative array * Logs each queries execution time * Has support for a debug mode * Pre-built methods for CREATE TABLE, DELETE, DESCRIBE, DROP, UPDATE, INSERT, SELECT, TRUNCATE and OPTIMIZE * And much more......
(show more)
(show less)

Pagination just means numbering pages. In the project that I was working on, I was retrieving large amounts of data from a MySQL database and realized that I would have to break the data up into pages for two main reasons, 1) there was so much data that it could hang the browser when it was loading and 2) from a user perspective (we still care about that right?) it was unruly to say the least. If I was returning 50,000 rows from a database query, I knew that I would need to slice that up into more manageable chunks. Now in the past, I had written basic pagination functions to handle this type of issue and sometimes copied and pasted functions from older scripts to cut down on development time, fixing and re-coding where necessary. But I realized that for this new project I could try to write a pagination class that I would be able to just plug into any script and have it do the pagination for me....
(show more)
(show less)