Path = Home > PHP Scripts > Database Tools

Free Database Tools PHP Scripts

Free database tools scripts which help you manage and make backup of the databases on your websites.

phpMyViews

phpMyViews is a small PHP script, which allows you to easily create mySQL queries and put the output in HTML pages. But that's not the only thing, phpMyViews not only shows mySQL data, but can also manage small formular based mySQL editing actions, including INSERT, SELECT, UPDATE, DELETE, ...
Requirements: PHP and MySQL
Version: 0.3
Status: Free

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

MySQL Commander

This tool makes backups of all the tables in a database. The data will be stored in textfiles located in the "data" directory. You can backup and restore the "SQL create table command" and the "content". So you can easily make copies of your tables. (i.e. copy a whole database with a few clicks).
Requirements: PHP and MySQL
Version: 2.65
Status: Freeware

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

OracleEditor.php

OracleEditor.php is a standalone PHP script which allows you to browse your Oracle database tables and insert, update and delete rows in any table. It requires no installation and no configuration.
Features:- Connects to any Oracle database (local databases, aliases from tnsnames.ora, or complete connection strings) - Lists all tables and views owned by the user, and those owned by other users where access has been granted - Simply select a table or view to display (SELECT) its records - Modify the list of fields to select (optional) Add a WHERE clause (optional) - Records are displayed in sets, allowing you to browse huge tables Foreign key values are linked to the master record: Simply click on the value to display the master record Fields which are used as foreign keys in other tables have links allowing you to browse all child records with one click - Last 25 SELECT statements are in the History popup - Exports your result set as an HTML, XML or CSV file - UPDATE, DELETE, and INSERT rows in any table - When updating or inserting, field values can either be strings or function names (allowing you to insert sequencer values, function calls, or NULL) String values are sent to Oracle as bound variables, so that you don't have to escape single quotes - When inserting, nullable fields are pre-set to NULL so that you know which fields can be left blank -Optional free SQL statement entry - Debug mode logs all SQL statements in the PHP error_log - Oracle error messages are displayed so that you know what went wrong -Works with register_globals=off, and with both magic_quotes on and off.
Requirements: PHP
Version: 1.18
Status: Open Source

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

MySQL Table Manager

The PHP/MySQL Table Manager is designed to simplify administration of a MySql web database. With it you can easily create, drop or rename tables. Alter tables structures by adding or dropping keys and indexes. Adding, removing or changing the properties of columns. Edit, add, search or delete table records.
Requirements: PHP and MySQL
Version: 2.8
Status: Free

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

DaDaBIK

DaDaBIK is a free PHP application that allows you to easily create a highly customizable front-end for a database in order to search, insert, update and delete records; all you need to do is specifying a few configuration parameters.
Requirements: PHP
Version: 4.0a
Status: Free

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

HDBQ (Web Base DB Query Tool)

This is a simple webbased database query tool. Features:- Queries can be executed using this tool - Easy Configuration - Simple To Use.
Requirements: PHP
Version: 1.0
Status: Free with copyright link

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

MySQL database backup

Most people will used it to have a daily snapshot of the dynamic data on their website. (e.g. content management systems, forums, guestbooks etc.) The script reads all tables in the MySQL databases you choose and exports (dumps) them in SQL files. The generated SQL files can be used to rebuild the tables on any other MySQL database or server or on the same server in case of data-loss. db_backup has been tested sucessfully on large databases with 1.5 mio records. Features:- 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. PHP Safe-mode compatible.
Requirements: PHP and MySQL
Version: 1.6
Status: Free

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

class-1 MySQL Backup/Restore

class-1 Backup/Restore is a PHP script that allows backup and restore of MySQL tables. It can be used as a stand-alone script or you can incorporate it into your own scripts. It incorporates the following features:- Extremely easy installation. Extremely easy usage. Backup from any database. Restore to any database. Select which tables to backup. Choose whether to backup just table structure, data or both. Choose whether to restore just table structure, data or both.
Requirements: PHP
Version: 0.1
Status: Free

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

Database Manager

This script allows an object orientated interface to be created around a mySQL connection. It provides numerous functions to speed up the use of a mySQL database, especially useful is the dumpResultSet() function which prints out the results of the previous query.
Requirements: PHP and MySQL
Version: 1.0
Status: Free

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )

MySQL Backup Utility Pro

PHP script to make SQL commands to delete, insert, and modify MySQL database table entries. Useful: when you update your database offline and import the changes to online database (especially incremental backups), or when you update your database online and want a SQL backup of the changes.
Requirements: PHP
Version: 2.0.1
Status: Free

Visit the Author's website - Is this link dead or broken? - Report it
( will open in new window )