Database Tools

• MORE DETAILS
• VISIT PUBLISHER SITE

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)

• MORE DETAILS
• VISIT PUBLISHER SITE

PM Report is a PHP/MySQL report generator. It creates customizable reports and is very simple to setup and use. You can select which database, table, and individual fields to use on your report. You can also select the order in which the fields should appear on the report, the field you would like to group by, the field you would like to sort by, and whether or not you would like a total for each column. Once the report has been generated, you can highlight individual rows and export the results to CSV. You can also enter your own custom SQL query manually. As of version 3.0 you can generate PDFs. Version 4.0 allows you to save, modify, and/or delete reports.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

LabStoRe is a modular, optionally account-based, inventory or LIMS system that provides a way to collect, maintain, present and archive information on laboratory stocks and records. A laboratory with a good inventory, or better, information system, saves time, reduces errors, prevents wastage, and occasionally even provides insights. The interface to this system is web-based, making it conveniently accessible and even though it is web-based, embedded security measures make it secure. Being PHP/MySQL-based, the system is very flexible (imagine making Excel behave in a way that you want). The database (MySQL-based) is kept separate from the interface (web, i.e., PHP/HTML-based), which gives it a significant advantage over, say, an Excel- or Filemaker-based system. MySQL and PHP are very stable, widely-used and supported (and free) platforms. If required, the database can be exported for use in more-traditional application based systems (Excel, Access, Filemaker, etc.). ... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

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)

• MORE DETAILS
• VISIT PUBLISHER SITE

ADOdb4PHP is a database abstraction layer with pagination support, written in OOP style, providing exceptions support, for PHP 5.1+ running on Windows machines.

• MORE DETAILS
• VISIT PUBLISHER SITE

This class can execute queries from parameter lists using MySQLi. It extends the MySQLi class with functions that can compose and execute SELECT, INSERT, UPDATE, DELETE, REPLACE and HANDLER queries with parameter values that define tables, fields, field values, conditions, etc.. The class destructor function disconnects from the MySQL server.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

chaozzDB is a simple to use Flatfile Database System. Functions include updating, adding, deleting and searching of records. The package includes a clear manual and an example database.

• MORE DETAILS
• VISIT PUBLISHER SITE

phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite2 and SQLite3. Following in the spirit of the flat-file system used by SQLite, phpLiteAdmin consists of a single 100KB source file that is dropped into a directory on a server and then visited in a browser. Setup is as simple as specifying which databases to manage and creating a password. The available operations, feature set, interface, and user experience is comparable to that of phpMyAdmin for MySQL. If you know how to use phpMyAdmin, then you know how to use phpLiteAdmin. Even if you have no experience with database managers, the intuitive interface makes it easy to learn. The password for the demo is "admin".... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Makes connecting/querying a MySQL database from PHP a snap.

• MORE DETAILS
• VISIT PUBLISHER SITE

TbsSQL makes it pleasant and easy to use your Databases with your PHP applications. Its most interesting feature is that it can protect and format values before merging them into the SQL statement. TbsSQL is available for MySQL, MySQLi, Microsoft SQL Server, Oracle and PostgreSQL. It is compatible with TBS. It's only one file to install. It has also a cache feature and a debug console.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

Zebra_Database it is an advanced, compact (one-file only), lightweight, object-oriented MySQL database wrapper built upon PHP's MySQL extension. It provides methods for interacting with MySQL databases that are more intuitive and fun to use than PHP's default ones. The class provides a comprehensive debugging interface with detailed information about the executed queries: execution time, returned/affected rows, excerpts of the found rows, error messages, etc. It also automatically EXPLAIN's each SELECT query (so you don't miss those keys again!). It encourages developers to write maintainable code and provides a better default security layer by automatically escaping strings. Zebra_Database's code is heavily commented and generates no warnings/errors/notices when PHP's error reporting level is set to E_ALL.... (show more)

• MORE DETAILS
• VISIT PUBLISHER SITE

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.

• MORE DETAILS
• VISIT PUBLISHER SITE

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)

• MORE DETAILS
• VISIT PUBLISHER SITE

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)