|
|
Database Tools
PHP » Scripts and Programs » Database Tools
A D V E R T I S E M E N T
Want free Oracle Magazine? Apply here now!
phpMyAdmin - Free (GPL)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. Fasdab - Free (LGPL)Fasdab is a PHP database abstraction layer that enables the user to write minimal, yet readable code. It supports PostgreSQL, MySQL, and ODBC. EZDB - Free (GPL)EZDB is a php script/tool developed for simplifying form creation and sql insert tasks for database. It creates the scripts and puts them into separate files. Currently only MySQL is supported. v2.0 MySQL Display Content - Free (GPL)This is a PHP script to display content from a MySQL database. Very easy to setup. Some script modification is need.
Dynamic Excel or Word File from MySQL - FreewareThis script takes the contents of a MySQL table and dumps it to either a dynamically-generated MS Word File (file with ending '.doc') or a dynamically-generated MS Excel File (file with ending '.xls'). You can place this script on any Unix/Linux or Windows Server running PHP & MySQL, but you have to access it using a browser on a Windows computer with Word or Excel installed on it. This script does not use COM objects and does not support multiple Worksheets in Excel. It can be used not only for creating complete dumps of MySQL tables (as Word or Excel files), but can be very easily modified to support any kind of select statement you'd like to use. Table Optimizing Script - FreewareThis script automatically searches for the databases within MySQL on your server. It then goes through each of the databases (it checks first to see if you have permission to those databases) and optimizes all the tables within them. The only thing you have to change in the script is your hostname, username and password for MySQL. MySQL Add Content - Free (GPL)This is a PHP script that allows you to add content into a MySQL Database. Some script modification is need.
PHPLIB Sql_pager - Free (GPL)This is an extension class to the PHPLIB library. It splits a SQL query into more pages like search engiens does. You can change the layout very easy. Uses the SQL function LIMIT so it may not work on all SQL databases. Xt-Dump - FreeXT-Dump allows to backup a table either all the contents of your Mysql database, under different forms of files in the choice, spreadsheet Excel, file sql, and file php for a later automatic restoration. XT-Dump allies simplicity and efficiency for a fast, effective and intuitive use. Application Builder for MySql - Free (GPL)This package contains integrated tools for database management, form, query and report generation. This package supersedes its previously published Relational Form Wizard for MySql and Sql Query Maker for MySql. The Database script is borrowed from SooMin Kim. The report builder is a fresh attempt to create reports from queries in HTML and PDF formats. Mlam - Free (GPL)Mlam is an advanced set of PHP4 libraries that allows developers to easily create database-driven projects using MySQL. It can handle various types of data (text, date, number, file, picture, external keys, link tables, etc), and includes its own management tool to edit and list (with search engine) database content for the given projects. Mlam also features user access restrictions, contains its own cache system, and supports English and French. Tutorials are also available to present the basics of mlam. Relational FormWizard for PostgreSql - Free (GPL)This is an attempt to create a relational form wizard for the PostgreSql database. Presently it only works for two tables which are relationally indexed. All the form features are available from previous work on the Formwizard for PostgreSql v1.0.
Update:12/18/2001: The script has been updated to work on single table to five related tables. An example is provided. The script now works on Linux, Unix and Windows platforms. Relational FormWizard for MySql - Free (GPL)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. FTDatabase - FreewareFTDatabase (FTDB) is a database extension for the FastTemplate library. FTDB allows to display results of a database select automatically in a template. In addition, FTDB allows to scan templated forms and to generate insert and update statements automatically. Numerous format specifiers are available for select, insert, etc. AMRSSBOSM - FreeAMRSSBOSM (Abu Mami's Ridiculously Simple SQL Backup and Offsite Storage Mechanism) uses resources found on your server to create a backup of your mySQL data and automatically send it to safe offsite storage. If you have a small database, this is a cheap and easy way to ensure proper backup of your valuable data.
|
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
| |
|