PHP Database Tools

Phlat makes it easy to work with flatfiles in PHP. You have all basic and some not so basic operations available with very simple commands, like, add, delete, modify, truncate, and more.

Is an (php/mySQL) tool for mySQL Server database comparison. It allows you to view the tables differences in compared database. If the tables compared are not identical, is showing the columns of table and return message NOT IDENTICAL. Is designed to compare different versions of the same database and is freeware solution....
(show more)
(show less)

With this tool you can easily create a web forms to insert/update/delete data in a MySQL database. It automatically generates advanced search panel and form validation too. You can view the data in a short list view and in a detail view. You can easily change the look and feel with using css files. From version 0.5 you can connect to a remote server as well. ...
(show more)
(show less)

DaDaBIK is a PHP application that allows you to easily create a highly customizable front-end for a database. The strength of DaDaBIK lies in its ability of customization. For each field of a table you can choose: if the field should be included or not in the search/insert/update form; the form label; the content of the field; the input type; the possible values, also driven from another table. Other features: files uploading, checking for possible duplication during an insert, authentication and authorization restrictions on view/update/delete, customizable graphic layout to enable embedding of the forms in your own site, export to CSV, e-mail notices, table aliases. DaDaBIK uses the ADOdb Database Abstraction Library in order to support as many DBMS as possible, at the moment it has been tested on MySQL, PostgreSQL, Oracle and MS SQL Server. It's available in several languages....
(show more)
(show less)

phpMyAdmin is intended to handle the administration of MySQL over the web. Currently it can: create and drop databases, create, copy, drop and alter tables, delete, edit and add fields, execute any SQL-statement, even batch-queries, manage keys on fields, load text files into tables, create and read dumps of tables, export data to CSV values, and administer multiple servers and single databases, check referential integrity. It supports about 40 different languages....
(show more)
(show less)

A class that makes it ridiculously easy to use mySQL, Oracle8, Inerbase/Firebase, PostgreSQL, SQLite (PHP), SQLite (C++) and/or MS-SQL database(s) within your PHP/C++ script. Includes lots of examples making it very easy to understand how to work with databases. ezSQL has excellent debug functions making it lightning-fast to see what’s going on in your SQL code. ezSQL can dramatically decrease development time and in most cases will streamline your code and make things run faster as well as making it very easy to debug and optimise your database queries. It is a small class and will not add very much overhead to your website....
(show more)
(show less)

A PHP4 and PHP5 database abstraction library. Supports MySQL, PostgreSQL, Interbase/Firebird, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, Sybase SQL Anywhere, DB2, Informix, Frontbase, SQLite, LDAP, Netezza, SAPDB, generic ODBC/ODBTP, PDO etc. ADOdb provides code to handle inserts and updates that can be adapted to multiple databases quickly. A basic paginated grid is also provided, and support for database-backed session variables. Support for PHP5 iterators and exceptions included. Methods are provided for date handling, string concatenation and string quoting characters for differing databases. A metatype system is built in so that you can figure out that types such as CHAR, TEXT and STRING are equivalent in different databases. Able to create databases, tables, indexes portably using an xml schema or programatically. Also has sql performance monitoring and schema creation using XML....
(show more)
(show less)

A web based program for creating online databases, written in PHP and MySQL. An Admin CP allows you to create databases, fields, categories, users, user groups and customize your databases using powerful templates & settings. Visitors can access your databases via the Visitor File. Export a database, create search forms, view database statistics, approve visitor uploads, implement user registration, use language files, and add built-in extras to your databases such a comments, ratings, and automatic file download logging. All clients receive 3 months free hosting with our partner, ThinkHost....
(show more)
(show less)

DataMan is a simple tool to manage data in a mysql database. You only need to point the tool to a db host, and the tool does the rest. Databases, tables and fields are generated automatically from the host server. It is a great tool for content management - so you do not have to worry about providing admin interfaces - just create a great looking front-end. Dataman also logs all queries. ...
(show more)
(show less)

phpMyDataGrid 2007 offers a toolkit to build a DataGrid in a PHP based environment. It allows the application programmer, to build and deploy with very few lines of code and in a short period of time a complete AJAX enabled datagrid with paging, searching, sorting and more, much more... It is useful for all PHP database-driven Web site and online-based data administration. It is also useful for dynamic content management and PHP-based hosting providers. # Easy to use: Even the most novice php programer can deploy a complete and professional looking datagrid in few minutes using a minimum of code lines. # AJAX Enabled: Differ to previous versions, the 2007 version is cross-browser totally AJAX enabled (addition, Edition, inline edition, deletion, pagination, ordering, etc.) # Auto pagination: phpMyDataGrid Allows 3 styles for pagination, and you may define how many records to display per page. and much more features... visit website for more info...
(show more)
(show less)

QLR Manager is a server based reporting, graphing and e-mail distribution tool for MySQL, Oracle and PostgreSQL. The application is 100% HTTP server based and is accessible using any newer mainstream browser... No client code to install. QLR Manager can be used as a stand-alone product or as middleware to integrate Report Objects into a website using an extensive set of PHP Class functions. Features include the ability to author and save individual or batches of queries, format reports by creating and saving layouts (Standard, Table, Pivoted and Custom), graph data with 5 chart styles, distribute output as e-mail, or download as HTML, XML, PDF and CSV files. You can also define macros to run queries with their associated layouts, organize queries and macros into menus, control access to limit user authorities, create HTML form controls to collect user input, and distribute customized e-mails based on addresses in your database. With the Wizard, knowledge of SQL isn't even required....
(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)

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)

Bear SQL is a light, easy to use, web front end to MySQL. It allows you to manage databases, tables and users, including backup and restore functionality. With Bear SQL you can create and remove databases and tables, add, edit and delete records, alter tables, add and remove primary keys and indexes, add edit and delete columns, change column properties, search tables, optimize tables, write your own queries, save queries, save query results, add and manage users and more. All from a simple web front end. ...
(show more)
(show less)

How many times have you hand coded a simple editor for a MySQL table in php? PHPMyEdit is a code generator to write this sort of editor for you automatically. You may never need to hand code a table editor again. PHPMyEdit can be used for anything that fits in a single MySQL table. Some of its examples include a visitors' book; an estate agent's database; and a company phone book....
(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)

Designed to create a daily snapshot of the dynamic data on your website. (e.g. content management systems, forums, guestbooks etc.) Some of the features include: - Backup multiple databases and servers with different users and passwords. - Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems). - Create daily, weekly and monthly snpashots of your database. - Keep the daily, weekly and monthly backups for a user-specified time. - Archive and compress the SQL files (*.tar.gz). - Creates a detailed report of everything that has been done. - Reports can be mailed to you or any other user-specified email-address, saved to disk or displayed in browser. - Generated SQL files can be mailed to you or any other user-specified email-address. - Generated SQL files can be uploaded by FTP to any user-specified FTP server. - Choose to create SQL files for each table or one for each database - No system calls, everything in 100% pure PHP....
(show more)
(show less)

NOW released under GPL License. phpMySQLAutoBackup the simple way to backup MySQL databases - automates the backup of your MySQL databases. Exports your database (data and structures), compresses it into gzip format and emails it to you. Schedule it to run every day/week by adding it to a cron job, or use phpJobScheduler. New features include the ability to select separate tables for backup, and limit the backup to start and stop at pre-set table row numbers, this will now allow a section of a large table (with millions of records) to be selected for backup. Features: * option to ftp backup file to remote server * email zipped database to your specified address * option to save to backup folder * backup limited to once per hour (easily changed) prevents malicious attempts at bringing down your server * specify specific tables to include or exclude, or backup the whole database * set ranges to backup - from start row number to last specified row number ...
(show more)
(show less)