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!
Appgini PHP Generator For MySQL - Freeware/$35Instantly create PHP web database applications that let users view, sort, search and edit data of a MySQL database easily from a single web page. You can customize the look of the generated files using CSS. You can define foreign key fields that let you easily create dynamic drop down menus that bring their contents from your database tables, and insure referential integrity. You can define image fields, which store image paths. Image fields display the images automatically to users. You can also allow users to upload images and you can set limits for image sizes. You have total control over how users can interact with data. Using the intuitive graphical interface of AppGini, you can create the database and tables without any SQL code. Or if you already have an existing database, you can import it to AppGini using our add-on wizard: MySQL2AppGini. You can also allow users to save data as CSV files compatible with Excel. Download a free trial now. wtcSQLitewtcSQLite allows you to add/edit/delete indexes, fields, tables, triggers, views, data, and manage multiple database aliases without knowing any SQL at all.
wtcSQLite also provides ALTER TABLE transactions similar to MySQL, as SQLite does not support them right now. It also allows you to export data in multiple forms, so you can always have a backup copy. On top of all of this, an admin template system is provided so that you may customize the templates wtcSQLite uses with a user-friendly interface. dataMinerdataMiner is a PHP script for manipulating data stored in a database. Table metadata is loaded internally by PHP, leaving configuration minimized to bare essentials. Features like file upload handling, image thumbnails, advanced form controls w/ javascript, data importing / exporting, a popup calendar, WYSIWYG editor, and css themes are included. ezSQL - Free (LGPL)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. DaDaBIK - Free (GPL)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. ADOdb Database Library for PHP - Free (BSD)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. PHP DB Admin Control V 1.0 - FreewareThis 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
PHPMaker - Free Trial/$39.95PHPMaker 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. phpMySQLAutoBackup - automate your MySQL backups - freewarephpMySQLAutoBackup 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 the excellent phpJobScheduler: QuickDataSimply 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.
Check out arthurcote.com for FormSketcher - wysiwyg html designer - auto generates database, tables and validation rules based on reg expressions. PHP Coding Ground :: Free Database Tools scriptsCoding Ground is Large Database website Listing Free Database Tools scripts, php tutorials, php-mysql tutorials, other tutorials, ebooks, webmaster tools, and more . BigDump - GPLStaggered 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. ezDatabaseA 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. WizMysqlAdmin - GPLWizMySQLAdmin 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. BENRUTH Instant Report! - FreewareThis 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 ezDatabaseA 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. WebBased DBQuery Tool - Free(GPL)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. EasySQL - FreeEasySQL 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. db Class (MySQL) with an errorlog! Secure your errors! - FreewareAn "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! MySql PHP BackupThis 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.
|
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
|