Top Rated Scripts | PHP | Scripts & Programs | Database Tools

This script creates the backup of the MySQL tables in SQL format and saves it into a ZIP file on server. Also, it can restore the MySQL tables in your database from the SQL backup stored in ZIP archive. Supports both PDO and MySQLi for accessing MySQL databases in PHP. It has options to Download or Delete the back-up files from server.

Sql dump utility for MySQL and PostgreSQL Databases

This class can be used to generate backups of PostgreSQL. It accesses a given database and generates SQL statements that can be used to recreate the database tables and the values stored on their rows. The generated SQL is stored in a given file. The class can also restore a database from a previously generated backup by executing the SQL statements stored in a backup file.

Oracle Information Site allows DBAs to view the most important informations about all configured Oracle databases. Support for Oracle 8i, 9i and 10g (untested) is integrated. OIS gives the DBA many informations like - Instance Configuration parameter - Running processes with detail view - Redo Log and Rollback segment usage - Tablespaces - Overview of all defined DBMS_JOBs - Memory Usage - Basic tuning views - General instance statistics - Very basic schema browser In addition OIS has a small integrated management interface which allows DBAs to have an overview of all DB machines with saveable comments. Finally a basic table exporter is also integrated. To use OIS you'll need PHP4 or newer with OCI8 extension build in, and of course at least one Oracle instance. As OIS reads Oracle's internal tables it require DBA rights to access them, else OIS won't work.

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

This is a dynamic query generator for MySQL and PHP4. It can create a new query or run an existing query. Several tables can be selected from a single database for relational queries. The query can be edited, saved and run dynamically. <br> <br> <b>Update (2001-06-18)</b>: The browser related bugs have been fixed. The query results are presented in a tabular form.

Sypex Dumper is a PHP-script, which can help you create a backup (dump) of a MySQL database, and also restore the database from the backup if needed. Unlike many similar programs (scripts), is optimized for maximum performance, as well as for working with large databases of hundreds or thousands of megabytes. Key features, briefly - backup and restore of MySQL database without using third-party programs, just pure PHP; - impressive performance; - support for two formats, file compression (Gzip and Bzip2); - friendly Web 2.0 interface with AJAX; - work in several stages (to bypass the restrictions about time); - special file format with the meta-information; - MySQL service functions (check, optimize, repair); - smart backup with post-processing;

phpSQLiteAdmin is a Web interface for the administration of SQLite databases. Right now the following operations are supported: Create, drop and vacuum databases; Show database information (schema, tables, indexes, file metadata); Create, browse, empty and drop tables; Show table structure and indexes; Execute sql;

This script can generate forms on two tables where one index in the first table is realtionally linked to another index in the secondtable. This script can also generate a single table form. This work is an extension of earlier work on PHPFormWizard 2.0. Update (2001/12/02): Updated to get rid of the system commands such that it would be compatible with Linux, Unix and Windows OS. The PEAR libraries have been removed as it made the script litle sluggish. Forms can be generated from single upto five related tables. An example is also provided.

The class can be used to execute MySQL database queries imported from a file. It opens a given file and reads it line by line to execute as SQL queries to a given MySQL database.

MADAL is an Ajax based database access layer for MySQL written in PHP and Javascript. It generates PHP and Javascript/jQuery source code that is well documented, so you can use your IDE's auto-completion against database tables and fields. The documentation was designed with PHP Eclipse in mind, but should work for any IDE that recognizes PHP doc. Features: * PHP Model - generates a set of PHP classes that mirror your database schema * Javascript Model - generates a set of javascript/jQuery classes allowing for simple client side display and modification * MADAL Web Service - generates an easy to use web-service for accessing your database (includes security) * Easy ajax - simply print the input field and you've got an ajax enabled field * Field validation - input fields are validated for their type * jQuery ui themes - MADAL includes the whole set of default jQuery ui themes for styling of your pages. * Optimistic concurrency

Flexible PHP Pagination is a Generic Pagination Class that allows you to paginate your MySQL or otherwise results. On top of that it's easy to use, has full customization and can even be translated if you really want. Unlike other CSS and HTML predefined Pagination Classes, our Pagination class not only allows you to fully integrate this pagination with your design, but also allows you to use this with Mod Rewrite. Which means you can change the link structure however you like. Giving you FULL SEO Customization.

QLR Manager is the affordable, yet powerful, server based Report, Chart and data editor for DB2, MS SQL, MySQL, Oracle, PostgreSQL, SQLite3 and ODBC data sources. In addition to its exceptional reporting capabilities, QLR Manager provides support for integrated e-mail distribution. User Menus can be created to simplify report generation and limit user access to sensitive data. Forms can be created to add, edit and delete data in your database tables. The application is 100% HTTP server based and accessible using any newer, mainstream web browser. Accessing your databases has never been easier with its intuitive browser interface, and there is no client code to install and maintain. QLR Manager can be used as a stand alone product or as middleware to integrate Report Objects into your website. Using QLR "Widgets", you can directly embed reports and other objects into Content Management Systems, such as Drupal, simply by copying and pasting a secure link generated by QLR Manager.

If you have ever wasted your time re-writing code for database administration, this tool may be for you. The Add, Edit, Delete Admin Tool allows you to quickly and easily create administration tools for any mySQL database table. A.E.D. gives you all the options you would have if you were hand-coding each tool. Simply put, you supply the options and information, and A.E.D. will generate the PHP code for you. Automatically generate add, edit and delete admin tools for any table in your mySQL database.

This class can be used to backup large MySQL databases into multiple files. It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creating a new database. The class stores the generated SQL statements in files. A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.

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.

The page navigation (pagination) of lists with records from a (MySQL) database is often used on a lot of dynamic websites. This class is extremely easy to use in your existing application: just use your own SQL statement and voila you get information like the result set (you need this for later output, page navigation links and the (current) number of records. While using this class all other query string parts are included inside the page links. An example database table (with data) is included. New in Version 1.03: There is a new variable $max_rows, this variable is used to limit the maximum of results during a query. That will say if there are more rows then the number of $max_rows only the last one will show up. Use the new variable $outstanding_rows if you need to inform the user about that.

This class can access different types of SQL database using PDO. It provides a common interface to access different types of database like MySQL, PostgreSQL, Microsoft SQL server, IBM DB2, SQLite, Oracle, Informix, and Firebird. The class can establish connections, execute queries, retrieve single result rows or single row columns, the number of result rows, the last inserted record identifier, the names of tables columns, and execute INSERT, UPDATE and DELETE queries from parameters. It can use prepared queries to prevent SQL injection attacks.

A virtually 100% secure database which divides the sensitive information and then distributes it to be stored inside of multiple, geographically diverse, embedded machines. This makes it 0 day attack and brute force proof as well as physically secure. Every secret has a unique token and a user-set password associated to it so that not even the sysadmin can reach it.

A class for very basic MySQL database connectivity. Written to reduce redundant code in my own projects aswell as aid in debugging and error reporting during the developement phase. Currently connects to a database, execute external files containing SQL commands, insert and update from an array of key => value pairs, insert and update with sql command, query (one result), query (multiple rows), and dump a select query to a table. The zip file contains the class aswell as a demonstration script.