You are here: w100w.com  >  PHP  >  Database Tools

 
 
Sponsored Links

 
 

 
 
    PHPRunner 2.0
    PHPRunner builds visually appealing web interface for any local or remote MySQL database. Your web site visitors will be able to easily search, add, edit, delete and export data in MySQL database. Advanced security options allow to build password-protected members only Web sites easily. PHPRunner is simple to learn so you can build your first project in just fifteen minutes.

    Features:
    Easy to use wizard-like interface.
    Numerous search modes.
    Add, view, edit, copy and delete pages.
    Built-in FTP Client to upload PHP pages to the Web server.
    Multilingual templates. Ability to choose language while logging in.
    Creates password protected PHP pages.
    User self-register page, password reminder, change password pages.

    Platform:Windows
    Licence:
    Price199

    File Size:2797

    Download : http://www.asprunner.com/files/phprunner-setup.exe
    Homepage: http://www.xlinesoft.com
 
 


 
    Price:  $199
    Version:  1.1
    Platform:  Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003
    Download
    Home
PHPRunner

PHPRunner creates set of PHP pages to access and modify MySQL database. Using generated PHP pages users can search, sort, edit, delete, and add data into database. PHPRunner is easy to learn, you can get started in just 15 minutes. 21-Trial version availiable. Easy to use wizard-like interface. Generates pure PHP code. Numerous search modes. Add, view, edit and delete pages. Creates password protected PHP pages. Benefits of using PHPRunner are: Can save you time and money. Improve functionality of your web site. Create robust, easy to modify code. Easy to use, you can generate your first PHP pages in just fifteen minutes. No programming required. What PHPRunner can do for me: Collect user\'s information. Phone/address book. News articles. Products listing. Web-based database searching & data entry. Web-based reporting. Members only password protected web sites.
 
 

 
    Price:  5.00
    Version:  1.4
    Platform:  PHP 4.1.2+, MySQL 3.23+, Macromedia Flash Player 7+
    Download
    Home
phpFlashMyAdmin

This tool is very similar to phpMyAdmin, with the difference that the user interface is built using Macromedia Flash 7 technology. You may use phpFlashMyAdmin to edit mysql table definitions and perform other common data management tasks with MySQL. Since Flash is used, there are no annoying page refreshes, as there are with HTML-based management tools.

phpFlashMyAdmin takes MySQL management a step further... with this tool, you will now have the ability to create, edit, and remove InnoDB table relationships, a feature that is commonly found in advanced, GUI-based databases like MS Access and SQL Server. You may cascade updates and deletions of table data, and enforce referential integrity among your data. This is a feature which truly sets phpFlashMyAdmin apart from any other MySQL administration tools.

phpFlashMyAdmin also includes - like phpMyAdmin - the ability to edit MySQL table definitions, browse pageable datasets, perform custom SQL queries, copy/move tables, backup your database in a variety of ways, and much more. You can also manage multiple MySQL hosts by editing a configuration file which comes with the distribution. Thus, with only a single common interface, you can manage many MySQL databases on various servers, and perform advanced database-management tasks.
 
 

 
    Price:  5.00
    Version:  2.5
    Platform:  PHP 4.1.2+, MySQL 3.23+, Macromedia Flash Player 7+, Adobe Acrobat Reader 6+
    Download
    Home
MyPDF

PHP 4.1.2+, MySQL 3.23+, Macromedia Flash Player 7+, Adobe Acrobat Reader 6+ Description: Create PDF reports from MySQL tables, using a customizable, Flash 7-based layout builder. Fully customizable using Flash 7 css capabilities - change almost any part of the MyPDF display without recompilation of the .swf. Create nested grouping levels, and custom report filters and sorts. MyPDF has an intuitive data screen whereby you can specify filter conditions using operators such as LIKE, >, <, >=, etc.
 
 

 
    Price:  5.00
    Version:  1.4
    Platform:  Linux
    Download
    Home
phpFlashMyAdmin

Like phpMyAdmin? Don\'t like page refreshes? This tool is for you! Not only can you edit mysql table structures and data, you can also *visually* create foreign key relationships among InnoDB tables. Includes 100% of source code!
 
 

 
    Price:  5.00
    Version:  1.01
    Platform:  Macromedia Flash MX or MX/2004 DataGrid Component (works with Flash 6 or Flash 7)
    Download
    Home
DataGrid Extensions

Let\'s face it, the Macromedia Flash DataGrid component, as provided by Macromedia, is basically useless. No word-wrapping, no horizontal scrolling, no embedding of style sheets, etc. I, for one, have had enough! The TUFaT.com Flash Datagrid builds on the existing Macromedia DataGrid component, but adds a large amount of functionality, which finally makes this component useful to real-life applications. Flash developers now have much more control over the FDataGrid Component than you ever had before. You will now be able to change the font color and style of individual cells, change the background style of individual cells, specify the color of a column EVEN when alternateRowColors is enabled (previously, alternateRowColors overrided column colors), toggle horizontal gridlines, use horizontal scrollbars, wrap text (even text within the headers!), remove that ugly header dividing bar, insert .css style sheet properties, and much more! The FDataGrid Component is made by Macromedia to provide developers with a useful tool for displaying data in a sortable, editable grid. However, as provided by Macromedia, the DataGrid component has many limitations. These Extensions get around some of those limitations, while building on the existing DataGrid component, so that you do not lose any existing functionality. These modifications costs $5, and include 100% of the source code, as well as the examples illustrated in the demo, and an API for the new functions in PDF format. The download does NOT include the DataGrid component itself. It is assumed that you already posses the DataGrid component, available from Macromedia. If you are using Flash 7 (also known as Flash MX 2004), then the Datagrid component comes with the Flash authoring environment. If you are using Flash 6, then the DataGrid component must be purchased from Macromedia with a DevNet kit.
 
 

 
PHP Coding Ground :: Free Database Tools scripts

Coding Ground is Large Database website Listing Free Database Tools scripts, php tutorials, php-mysql tutorials, other tutorials, ebooks, webmaster tools, and more .
 
 

 

    Version:  1.5
    Platform:  windows
    Home
QuickData

Simply select an html form. QuickData parses the form elements and generates $_POST code, mysql table creation and insert scripts. Full version generates jsp,php and asp form data submittal scripts for MySql, Oracle and Microsoft SQL.
 
 

 

    Version:  1.54
    Platform:  linux, windows, freebsd, osx, sun
    Home
Assure Database Backup Software GPL

This Free Script will allow you to quickly backup your MySQL database and restore it. It is meant to be simple to install, and use. No programming knowledge required.
 
 

 

    Version:  2.1
    Platform:  linux, windows, freebsd, osx, sun
    Download
    Home
ezDatabase

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 your databases, create search forms, view database statistics, approve visitor uploads, implement user registration, use language files, and add built-in extras to your databases such as a comment and rating system for items, and automatic file download logging.
 
 

 

    Version:  0.1
    Platform:  linux, windows, freebsd, osx
    Download
    Home
class-1 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. 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
 
 

 
 
Sponsored Links

 
 

 
ezSQL

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.
 
 

 
    Price:  Free (GPL)
    Version:  3.1 beta
    Home
DaDaBIK

DaDaBIK is a PHP application that allows you to easily create a highly customizable front-end for a MySQL 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, customizable graphic layout to enable embedding of the forms in your own site, export to CSV. Available in English, Italian, Dutch, German, Spanish and French.
 
 

 
    Price:  Free (BSD)
    Version:  4.22
    Platform:  Linux, Unix, BSD, Win 95/98/NT/2000, Solaris
    Home
ADOdb Database Library for PHP

A PHP4 database abstraction library. It currently supports MySQL, PostgreSQL, Interbase/Firebird, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, Sybase SQL Anywhere, DB2, Informix, Frontbase, SQLite, LDAP, Netezza, SAPDB and generic ODBC/ODBTP. It provides support 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. 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.
 
 

 
    Price:  Freeware
    Version:  1.0
    Platform:  Unix, Linux, Win NT
    Download
    Home
PHP DB Admin Control V 1.0

This is a small web based database administration code using PHP 4+ and mySQL database. Features 1) Login 2) Control Panel 3) Add records 4) Edit records 5) Delete records 6) Logout
 
 

 
    Price:  Free Trial/$39.95
    Version:  2.1
    Platform:  Win 98/Me/NT/2k/XP/Server 2003
    Home
PHPMaker

PHPMaker is an automation tool (for Windows) that can generate a full set of PHP scripts quickly from MySQL database. Using the generated PHP, users can view, edit, search, add and delete records in the database easily on the Web. With the Quick Generate Wizard, you can generate your web site instantly with only a few clicks of the mouse. 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.
 
 

 

    Version:  2.1
    Platform:  linux, windows, freebsd, osx, sun
    Download
    Home
ezDatabase

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 your databases, create search forms, view database statistics, approve visitor uploads, implement user registration, use language files, and add built-in extras to your databases such as a comment and rating system for items, and automatic file download logging.
 
 

 
    Price:  GPL
    Version:  0.11.1 (build 90)
    Platform:  Platform Indipendent
    Home
WizMysqlAdmin

WizMySQLAdmin is a PHP script to manage MySQL databases. If your web site uses a MySQL database you can manage its contents with WizMySQLAdmin, as you can do with the most known phpMyAdmin: but my script is very simple to configure and use, because it's composed by only one file. So you can install it on your web site very easily.
 
 

 
    Price:  Freeware
    Version:  1.0
    Platform:  Unix, Win NT, XP
    Home
BENRUTH Instant Report!

This script was born out of necessity for me. I was creating quite a few reports that are to be extracted from MySQL database. Format them into a table like structure, with or without headers. And be able to view as HTML, download as HTML, or download as EXCEL. All settings to generate a report can be controlled by adjusting the variables found in config.inc.php This script helped me somewhat in having some spare time to go for a good round of fishing. I hope that it will aid you as it aided me. There would not be any technical assistance on this script. However you can pop a question or so to me at my email ( ben AT benruth DOT com ). It is good to say hi! This script requires some knowledge of SQL. Features-At-A-Glance ======================= - Configurable script - Simple table for - Download as EXCEL - Download as HTML - Viewing as HTML - Extraction from MySQL database
 
 

 

    Version:  1.1
    Platform:  linux, windows, freebsd
    Download
    Home
dbUtils

dbUtils is a simple, pure-PHP solution which allows anyone to manage multiple mySQL databases and tables. dbUtils currently consists of 5 functions to allow you to accomplish a number of copying, moving, renaming, and general management tasks. Designed originally for database backup without the need for command-line access or telnet access, but expanded to provide functions normally not available in most database management front-ends like phpMyAdmin.
 
 

 
    Price:  Freeware
    Version:  2.0
    Platform:  Unix, Linux, Win NT, XP
    Home
db Class (MySQL) with an errorlog! Secure your errors!

An "easy-to-use" db class with 2 included How-To-Files in english and german and an example php-file. For private or commercial use.- It's FREE!! Just rate my Script and habve fun!
 
 

 
    Price:  Freeware
    Version:  1.0
    Platform:  PHP 4.3.3 with MySQL
    Home
Database file upload / download

db_upload_file() stores a file in a database table. Make sure that the column data type is big enough for the files you will be storing. db_download_file() retrieves a file from the database and places it in the same path as the script calling it, and returns the relative URL. If the file does not exist in the database, it returns an empty string.
 
 

 
    Price:  Free(GPL)
    Version:  0.7
    Platform:  Unix, Win NT, XP, etc.
    Download
    Home
WebBased DBQuery Tool

A great WebBased DBQuery Tool. Very simple and very easy customization. Just run your queries , execute them and see the results. A great utility for webmasters.
 
 

 
    Price:  Free
    Version:  3.0
    Platform:  PHP and mySQL on any web server
    Home
EasySQL

EasySQL is a PHP application to easily connect to your MySQL database with just 1 php file and 3 easy steps. Useful for beginners, it lets you easily interact with a mysql database using only your web browser. Features: Automatic table formatting, reusable query, javascript assisted features, syntax help file and full versioning control for easy updates. Username and password security can be added with an optional, [free] addon sister product - Admin-Login-Only.
 
 

 

    Version:  2.1
    Platform:  Unix/Windows
    Home
MySql PHP Backup

This script allows you to make a backup of your MySql database in sql or gz format allowing you to restore in case of a server crash. The output sql is already compacted. You can download the backup from the server as sql or gzip. Very easy to use. 2.1 Drastically overhauled with a clickable listing of all tables in a database. Structure only also can be saved Overhauled version, better error checking. Works with windows/apache too, special changes for windows time-out.
 
 

 
    Price:  FREE (LGPL)
    Version:  1.16
    Platform:  All
    Download
    Home
EZ Results Paging Class

EZ Results is a paging class that can be formatted in any way you choose. Have a read through the documentation to see just how unlimited it is. Once you start working with it you will be amazed at how quickly you can prototype pages. Supports mySQL & Oracle.
 
 

 
    Price:  Free-to-try, Commercial
    Version:  3.0
    Platform:  Unix, Windows
    Download
    Home
ExcelExplorer Pro

This PHP class can read data from binary (XLS) Excel file without using COM, ODBC, etc. ExcelExplorer will work on any OS that supports PHP. Windows and Mac Excel files are supported. No additional classes, modules or configurations needed. Using ExcelExplorer you can read info about worksheets, columns, rows, cells. You can even read style info such as colors, alignment, fonts, borders and more. Have build-in caching, memory-safe mode. Demo version available on-line and for download.
 
 

 
    Price:  Free (GPL)
    Version:  1.0
    Platform:  Linux, Windows
    Download
    Home
webXadmin

webXadmin is a generic php/mysql application that performs data management through a web-based HTML interface. From an XML-based schema definition, webXadmin generates record lists, HTML forms and associated sql queries. Localization available through xml language list.
 
 

 
    Price:  Free
    Version:  0.21.2 alpha
    Platform:  Mac, Unix, Windows
    Home
DB_Table

Builds on PEAR DB to abstract datatypes and automate table creation, data validation, insert, update, delete, and select; combines these with PEAR HTML_QuickForm to automatically generate input forms that match the table column definitions.
 
 

 
    Price:  GPL
    Version:  2.0
    Platform:  Windows NT/XP, Linux, Unix
    Home
txtSQL

txtSQL is a flatfile database module, written in php, whose sole purpose is to extract data from a data stored in a text database (flat file). Fields are not character-dilimited, and an extremely limited SQL (structured query language) can be used to retrieve data.
 
 

 
    Price:  freeware
    Version:  1.0
    Platform:  win, linux, mac
    Download
    Home
GrantMySql

GrantMySql script allows user to manage users and rights of MySql database from Web browser in easy and simple manner. It is useful for novices as well as for advanced users. If you do not know line syntax of MySql or need often to change or give rights for MySql database, this script is ideal for you.
 
 

 
    Price:  GPL
    Version:  0.3.1
    Platform:  Linux/*BSD
    Download
    Home
Ariejan.net MySQL Backup Tool

A.M.B.T. - MySQL Backup Tool is designed to automate and simplify the process of making regular backups of your MySQL databases.
 
 

 
    Price:  Free (GPL)
    Version:  1.1.23
    Home
backupDB()

backupDB() is a PHP script that backs up MySQL tables and databases to a gzip'd file for easy daily backup. Can back up a single database and/or table, or all tables. Structure-only, complete-inserts optional. Can be called interactively or run as a cron job. Works well with doSQL() (also available on this site). Faster and more robust than phpMyAdmin's backup function.
 
 

 
    Price:  Free (Modified GPL)
    Version:  4.3.3
    Platform:  Unix, Linux, Windows
    Home
Text Database PHP Class

Using a unique database design I have developed a php class to have a completly text file database system. Just some of the functions included in the class are for: add/edit/delete records, add/edit/delete tables, sorting a database using a given field, and many more usful functions. This class is very usful for developers wanted to make applications for servers that do not support mySQL or something similar. Tutorials are available from our site.
Update: version 4.3.3 includes limiting the query() results, editfield() and removefield() were also added.
 
 

 
    Price:  GPL
    Version:  0.1
    Platform:  all platforms
    Download
    Home
nstrees - nested set tree library

This library consisting of a single php file implements hierarchical datastructures (trees) using the mysql database. Nested set trees are flexible, they can have an arbitrary number of nodes and their data/structure can be read efficiently. The library implements all important functions: Tree creation, queries, reorganization, walks (traversal) and tree printing.
 
 

 
    Price:  $99.95/Free trial
    Version:  4.02
    Platform:  Unix, Linux, Win 98/NT/XP/2000
    Home
PHP Excel Parser Pro

New in the latest version: optimized speed and memory usage. Need a script that reads Excel file and transports the information into Database or creates an HTML file? PHP Excel Parser Pro is the answer! Works under Unix, Linux, SunOS, Windows using PHP without any additional modules. The parser imports data from Excel files (versions 5.0/97/2000/XP). Imported Excel data types are: integer, float, string (compressed Unicode,8-bits per character, or uncompressed Unicode, 16-bits per character, formats), date, time, percent, formula (returns digits only). Parser Pro supports multiple Excel fonts and MAC files. The Demo & Trial versions are available at : http//www.zakkis.ca
 
 

 

    Version:  0.1.0-beta
    Platform:  linux, windows, freebsd, osx, sun
    Download
    Home
ezSqliteAdmin

ezSqliteAdmin is a tool written in PHP & XUL intended to handle the administration of SQLite over the Web. It requires PHP >= PHP5.0.0 & Mozilla platform to run.
 
 

 

    Platform:  linux, windows
    Home
MySQL Dialog

MySQL Dialog is a simple MySQL database access wrapper class to execute SQL queries and display the results in HTML tables. The class connects to a MySQL server, sends SQL statements, and gets the results as an array. A table with the data from the result sets can also be displayed. The class may optionally return error messages on failure based on the mysql_error() and user defined error messages.
 
 

 
    Price:  GPL
    Version:  v1.01
    Platform:  Unix
    Home
Simple SQL

DESCRIPTION: Simple SQL provides functions to retrieve single fields or rows of a table, insert rows given arrays of column names and values, update single fields of a given table row, delete given table rows and many other common needs. ADVANTAGES: - This PHP class file will eliminate nearly all code from the built in std mysql PHP functions. - Speed, it will dramatically decrease development and execution time. - Extremely easy to use; one hardly has to understand the MySQL syntax. - It automatically determines whether or not there is an open connection to the MySQL server. It will connect and reconnect automatically. - The built in debugging functions make it easy to solve syntax error and logic error. - Supports arrays for arguments and returns ASSOC arrays from the DB with indexes. - Stores resource links and common variables such as the last table used.
 
 

 
    Price:  GPL
    Version:  0.9.8-2
    Platform:  Linux, Win, ...
    Download
    Home
SQLiteManager

SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4 and work fine with PHP5. Work just as well on a platform Linux as on Windows or Mac OsX. This project is in course of developpement, but it is alway very functional. The various functionality are: - Management of several database - Creation 'Connection' to several database - Property of the database. - Management of the options of the database. - Creation / update / delete tables - Management of the indices - Showing / Insert / ALter / Suppression of data in the tables - Imports data from a file - execution of manual query from 'SQLite' format or from 'MySQL' format (conversion) - Create / Update / Delete of View - create / Update / Delete of Trigger - Management of the user defined function. (usable in SQLiteManager query) - exports structure and data to the SQL format
 
 

 
    Price:  59.00
    Version:  2.0
    Platform:  Linux, Win2K
    Home
Comdev CSV Data Tool v2.0

The CSV Data Tool component is the only tool that offers you the shortcut to maintain your MySQL database. Using CSV format file, everything is easy to work around with data that you have updated using spreadsheet software like Microsoft Excel. Key features: import csv file wizard, specify separator, onscreen columns & data viewing, select database to import and column matching, append / replace existing records / update using primary key. To backup your valuable data, you have the options to export only fields that you need from the selected table or simply export all of them to your local computer. Best of all, Comdev CSV Data Tool comes with Undo Import functionality that lets you preview lastest imported data, last backup data and undo import to restore all data. Packed with web based installation wizard that eases your pain from complicated configuration. Take advantage of our FREE Installation Support, get your copy today!
 
 

 
    Price:  Freeware
    Version:  1.0
    Platform:  PHP 4.3.3 with MySQL
    Download
    Home
table exists

I find this little script very useful for web applications that need to automatically generate tables. I wrote it because I felt it was wrong to have a script execute create table SQL statements for tables that already existed.
 
 

 
    Price:  FREE
    Version:  1
    Platform:  All
    Home
Database Manager (mySQL)

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.
 
 

 
    Price:  freeware
    Version:  1.0
    Platform:  all
    Home
GreenLight SQLTool

This tool consists of two files, one to execute queries submitted by form or uploaded as a file and display the results, and another to dump the database in MySQL or MSSQL format. The scripts can be used with either MySQL or MSSQL databases. Together they can be used to migrate a database (or at least the table structures and contents) from MySQL to MSSQL or vice versa.
 
 

 
    Price:  $60/Free Trial
    Version:  1.1
    Platform:  Unix, Linux, Win 98/NT/XP/2000
    Home
PHP Excel Parser

This script reads MS Excel file and transports its data into Database, or HTML-page, etc. It does this using PHP under Unix and Linux without Windows tools like COM. The parser imports data from Excel files (versions 5.0/97/2000/XP). Imported Excel data type: string, integer, float, date. String can be in compressed unicode (8-bits per character) or uncompressed unicode (16-bits per character) formats. To install and use this script you need installed and properly configured PHP only. Added MS Excel->MySQL builder. This is plugin (PHP program) - output in MySQL database. This program imports data extracted by ABC Excel Parser Pro from an Excel file into a MySQL database table. There are no PHP programming skills required to create MySQL database from your Excel file. The Demo and trial versions are available at www.zakkis.ca
 
 

 
    Price:  Free (BSD)
    Version:  1.16
    Platform:  Linux, Unix, Windows
    Download
    Home
OracleEditor.php

OracleEditor.php is a standalone PHP script which allows you to browse your Oracle database tables/views and insert, update and delete rows in any table. It has two modes for SQL entry - one is wizard-like, the other one allows executing arbitrary SQL statements. It requires no installation and no configuration. It is written for situations where you quickly need to do some small data manipulation and don't have a better tool available. OracleEditor.php is free and Open Source.
 
 

 
    Price:  free - PHP - License
    Version:  1.0
    Platform:  Win32, ev. Unix
    Download
    Home
php_db2util

At the moment, the php_db2util extension supports: *) connecting to DB2 *) load data from client or server with replace option or insert option *) export data from table to client ( also not possible with ODBC ) *) run the runstats utility to recreate indexes ( also not possible with ODBC ) *) disconnect from DB2 Loads 2.000.000 rows in 10 minutes into a DB2 table! All this functions returns the count of the written/exported/readed lines to the calling function. This extension will not replace the ODBC support to IBM DB2, it will extend it. Requirements: You must have installed the runtime client from IBM for accessing the API libs. You can get the runtime client free as fixpack from the IBM website. There is also a free developer version of DB2 8.2.
 
 

 
    Price:  GPL
    Platform:  PHP5/SQLite, PHP/MySQL
    Download
    Home
Zip Code Database Project

These archives include all files necessary to calculate the distance between two U.S. Zip Codes using PHP4+ and MySQL.
 
 

 
    Price:  FREE (Artistic License)
    Version:  3.0
    Platform:  Any platform where PHP is available.
    Download
    Home
FX.php

FX.php is a PHP class which combines the ease-of-use of FileMaker with the power of PHP. In the latest release, FX.php allows access to every version of FileMaker since version 5, and preliminary support has been added for MySQL. FX.php is designed to give FileMaker users the advantages and flexibility of using PHP. In addition, the new MySQL support adds the option of using data from multiple data sources, without knowledge of SQL.
 
 

 
    Price:  GPL
    Version:  Beta Release
    Platform:  Linux
    Download
    Home
ORAMON: Oracle Database Monitoring Tool

ORAMON is a free Oracle database monitoring tool. It can help you in managing critical database administration task easily. To avoid any complexity, we have tried to make the interface as much simple as possible.
 
 

 
    Price:  GPL
    Version:  v1.01
    Platform:  Unix
    Home
Simple SQL

DESCRIPTION: Simple SQL provides functions to retrieve single fields or rows of a table, insert rows given arrays of column names and values, update single fields of a given table row, delete given table rows and many other common needs. ADVANTAGES: - This PHP class file will eliminate nearly all code from the built in std mysql PHP functions. - Speed, it will dramatically decrease development and execution time. - Extremely easy to use; one hardly has to understand the MySQL syntax. - It automatically determines whether or not there is an open connection to the MySQL server. It will connect and reconnect automatically. - The built in debugging functions make it easy to solve syntax error and logic error. - Supports arrays for arguments and returns ASSOC arrays from the DB with indexes. - Stores resource links and common variables such as the last table used.
 
 

 
    Price:  Free (GPL)
    Version:  1.2.10
    Home
doSQL()

doSQL() is a PHP4 script that can dump data back from a SQL text file (generated by backupDB() (also available on this site), phpMyAdmin, or similar) to a new database, or run any number of SQL commands in batch mode. Detailed progress reporting, including time remaing, processing rate (text and graph available).
 
 

 
    Price:  $99
    Version:  2.7.7
    Platform:  Windows (w/ MSIE 6), Mac (w/ Mozilla).
    Download
    Home
QuB PHP :: Visual SQL Queries for Dreamweaver

For a dynamic web application developer, who needs create recordsets from multiple tables and is not an SQL expert, QuB is the tool that allows table relation management, automating SQL query generation. Unlike other tools, QuB manages tables, relations and conditions for queries in your web browser. Features: --Integrated Dreamweaver Recordset support; --Ease of use; --Increased productivity; --Tight database integration; --Automate SQL query generation; --Visual Query Editing; --All Dreamweaver server models support (PHP, CFM, ASP, .NET, JSP); --Support for various database servers.
 
 

 
    Price:  $499.00
    Version:  1.02
    Platform:  Linux
    Download
    Home
Accession for php

Accession is powerful development tool aimed at providing developers an intuitive framework through which they can develop complex, web-based database administration applications in a minimal amount of time. Accession promotes the use of 'List'-based, and 'Detail'-based views of your record sets. All a developer needs to do to build rich feature-filled database application is to define to Accession what view type it is to present along with the fields it is to manage, and how these fields are to be presented. Accession supports a plethora of data types and database back-ends, in addition to all the features you'd expect from a database application toolkit. Come see our demos , and we're sure you'll be sold on our solution in no time!
 
 

 
    Price:  Freeware
    Version:  1.4.0
    Platform:  Apache/PHP
    Download
    Home
phpMySQLDiff

A litte tool to create an alter-script for the differences between two databases. Since 1.4.0 InnoDB FOREIGN KEYS are supported. MySQLdiff 1.5.0 added support for FULLTEXT Indexes so a auto_increments. There was also added the (experimental) feature to upload sql-scripts to compare them against another script or an existing database.
 
 

 
    Price:  Freeware
    Version:  1.2
    Platform:  Linux
    Home
SqlCommand Class

The SqlCommand class is designed to provide a simple, effective, and yet powerful way to use Microsoft SQL Server stored procedures through PHP, with the aid of the PEAR database abstraction layer. It provides an object-oriented method of declaring and configuring stored procedures in your PHP code, performs strong parameter "typing" of all values passed to the database, and allows you to easily retrieve return and output parameter values from your stored procedures.
 
 

 
    Price:  39.97
    Version:  1.01.00
    Platform:  Unix
    Home
Laser BackUp

Amazing New Automated Software Can Virtually Guarantee You Never Lose Your Databases And The Vital Information It Contains! Back It Up Daily, Weekly, Monthly and Even Email It To Yourself Automatically! Laser Backup is a Client Side, Stand Alone, Web Based, Instant Database Backup Tool for your website database(s). For the first time, you can instantly back up any, or all of your databases with just a few mouse clicks. Even better, once you set it up, it will do it for you automatically!
 
 

 
    Price:  Freeware
    Version:  1.0.0
    Platform:  Unix, Windows
    Home
ADODB_SQL

ADODB_SQL allows you migrate your code using DB_Sql format (PHPLIB) to an another DB engine like ADODB.
 
 

 
    Price:  GPL
    Version:  1.22
    Platform:  Unix, Linux, Win 2K, Win NT, XP, etc.
    Home
MySQL database backup

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.
 
 

 
BigDump

Staggered import of large and huge MySQL Dumps (like phpMyAdmin 2.x 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 webservers with hard runtime limit and those in safe mode in a couple of short sessions.
 
 

 
    Price:  Free
    Version:  1.5
    Platform:  All
    Download
    Home
Shiegege Iseng Paging Class

A PHP class script that demonstrates how to build the Next/Prev buttons for given MySQL query results. Easily create a paging navigation bar like Google.
 
 

 
    Price:  Free (GPL)
    Version:  2.62
    Platform:  PHP and MySQL
    Home
MySQL Commander

A small tool to backup and restore MySQL Tables. Features: backup/restore of binaries; multiserver; Gzipping; killing of backup files; german/english; Online help in popup.
 
 

 
    Price:  Free (GPL)
    Version:  1.1
    Platform:  PHP and Oracle
    Home
Oracle Commander

Features: shows all tables of the Scheme; table structure; change and delete existing tablecolumns; add new tablecolumns; deleting and renaming of tables; displaying tabledata (inclusive sorting); creating new or edit existing tabledata (exclusive LOBS and BFILES); partitial views on tabledata; submit of SQL Statements; backup and bestore complete tables
 
 

 
phpSQLiteAdmin

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;
 
 

 
    Price:  Free (GPL)
    Version:  1.0.5
    Home
eSKUeL

eSKUeL is a MySQL database managment tool written in PHP. It's fully compatible with MySQL: drop, create, insert, etc. It's also fully skinnable.
 
 

 
    Price:  Free
    Version:  1.0
    Platform:  Linux, Windouz
    Home
phpUF

This script is oriented to chilean citizen. phpUF grab UF Value from Banco Central de Chile (UF is a chilean index money). Este script esta orientado a ciudadanos chilenos. phpUF captura el valor de la UF desde el Banco Central de Chile.
 
 

 
    Price:  Freeware
    Version:  1
    Platform:  Unix
    Home
Generate Online in minutes Custom PhpMySQL Database Scripts

You can generate database scripts to your own custom design of your database in PhpMySQL CGI-Perl and ASP Access with Add, Search, Edit and Delete functions. A user can edit and delete his own record only, protection being provided by user-selected password. Search results are paginated, the number of records per page being customisable. There are two databases, one for Matrimonial, the other for Classified Advertisements. The site also has Reciprocal Links Exchange Directory
 
 

 
    Price:  Open Source
    Version:  V8
    Platform:  Windows, Linux
    Download
    Home
MYXXL Object Modeler

MYXXL is a tool to model data structures (business models) on basis of objects and relations (similar to a PDM tool). MYXXL supports three roles, the "user", the "author" and the "business administrator". Features: Users can search for objects, authors can provide objects and the business administrator models the data model. Users can get in contact with the authors through MYXXL. To protect the authors info the contact will be anonymous. The author will decide if he gets in contact with the user or not after an object is requested. MYXXL works object oriented and is completely web based. It works on MySQL database server.
 
 

 
    Price:  Free (QPL)
    Version:  0.9b
    Platform:  Unix
    Home
phpMyBackup

phpMyBackup is a PHP written mySQL backup tool with many features.
 
 

 
    Price:  5$
    Version:  1.2
    Platform:  All Platforms
    Download
    Home
phpFlashMyAdmin

This tool is very similar to phpMyAdmin, with the difference that the user interface is built using Macromedia Flash 7 technology. You may use phpFlashMyAdmin to edit mysql table definitions and perform other common data management tasks with MySQL. Since Flash is used, there are no annoying page refreshes, as there are with HTML-based management tools. phpFlashMyAdmin takes MySQL management a step further... with this tool, you will now have the ability to create, edit, and remove InnoDB table relationships, a feature that is commonly found in advanced, GUI-based databases like MS Access and SQL Server. You may cascade updates and deletions of table data, and enforce referential integrity among your data. This is a feature which truly sets phpFlashMyAdmin apart from any other MySQL administration tools. phpFlashMyAdmin also includes - like phpMyAdmin - the ability to edit MySQL table definitions, browse pageable datasets, perform custom SQL queries, copy/move tables, backup your database in a variety of ways, and much more. You can also manage multiple MySQL hosts by editing a configuration file which comes with the distribution. Thus, with only a single common interface, you can manage many MySQL databases on various servers, and perform advanced database-management tasks.
 
 

 
    Price:  Free(GPL)
    Version:  0.7
    Platform:  Unix, Win NT, XP, etc.
    Download
    Home
WebBased DBQuery Tool

A great WebBased DBQuery Tool. Very simple and very easy customization. Just run your queries , execute them and see the results. A great utility for webmasters.
 
 

 
    Price:  29.90
    Version:  1.0
    Platform:  Win98/Me/NT/2000/XP
    Home
PHPMaker

PHPMaker is an automation tool (for Windows) that can generate a full set of PHP scripts quickly from MySQL database. Using the generated PHP, users can view, edit, search, add and delete records in the database easily on the Web. With the Quick Generate Wizard, you can generate your web site instantly with only a few clicks of the mouse. 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.
 
 

 
    Price:  free
    Version:  4
    Platform:  unix and windows
    Home
Database query script

Learn how to query a database and retrieve its values
 
 

    Price:  Free
    Version:  1.40
    Platform:  Linux, Unix, BSD, Win 95/98/NT/2000
    Download
    Home
ADODB Database Library

This is a PHP database library. It currently supports MySQL, PostgreSQL, Interbase, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, DB2, Frontbase and generic ODBC. Windows programmers will find it easy to learn because many of the conventions are similar to Microsoft's ADO. We also provide support code to handle inserts and updates which can be adapted to multiple databases quickly. Methods are provided for date handling, string concatenation and string quoting characters for differing databases. Also, 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. SQL to popup menu select and SQL to HTML table support included. Cached recordsets for x3 performance for readonly tables. Also proxy database server support for SQL queries via HTTP. 1.40 update: This version adds record paging with next/previous link support.

    Price:  Free (GPL)
    Version: 1.0
    Platform: Linux
    Download
Relational FormWizard for MySql

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/10/07/: The Form Wizard now uses PEAR libraries and can generate upto 5 relational forms on one screen. The script has been more streamlined towards class oriented scheme.

mylittlebase

mylittlebase is a little database component for delphi, kylix, php and c++ that covers most of development needs. No need to link to any external server, DLLs, it is 100% standalone. It supports ISAM formats and can query records with the LIKE operator.

 
 
Sponsored Links

 
 

Add a Listing

ScriptRequests.Com - Discussion w100w.net - Links


Copyright © 2000-2006 w100w. All rights reserved.