|
|
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!
dbForm - Free (GPL)PHP class that creates a Web Data Entry Form for a database table and handles all processing of the form including validation of data, inserts, updates and deletes. Very customisable and flexible. Uses ADODB to connect to databases and simple Templates. PHPMySQLBackup - Free (GPL)Backup of a mysql database in mysqldump format without using mysqldump or a system command, only PHP. The class makes a SQL script or GZip archive to download.
MySQL dbDump - Free (GPL)A simple script used to Dump your remote MySQL database. Particulary useful on your personal PC, when PHP hosting servers are limiting the runtime interval of PHP scripts. Now you can to download big dumps too. (demo version with 15 seconds PHP script runtime) PHXCodeMaker - FreePHXCodeMaker is a utility to generate mysql table admin forms in php pages. Simply type the sql select corresponding to the columns and table desired and the source code will be automatically generated and created. Global search condition on all significant columns, page browsing with next/previous navigation & controlled pages number, alphabetical simple search, sorting asc and desc on column headers, auto links on emails or url fields, image field display, update and creation in table list view and form view, duplication, deletion, multi-language, number alignment, quotes input in string, line color alternance, graphics, cookies, etc. phpdbgrid - Free (GPL)phpdbgrid uses Adodb to view data in a database. It has many options to customize the layout. PHP CSV Importer - FreeA script to import data to a MySQL database from CSV files. Open a CSV file and preview it. Then, connect to your MySQL database, select which fields should receive which column (or set value) and then import. You can add, update or even add and update with this script. This new version allows you to create tables prior to import, import via rules (insert/update only where column X is greater than 13), delete from table and save your rules. There is also now a file browser to find your file. SQLconf - Free (GPL)Writing and reading configuration for your scripts has never been so easy. Using MySQL as the backend and a minimal, automatically updated conf.php file, SQLconf provides a solution for all your configuration needs.
ms2my - Free (GPL)A tool that helps with MSSQL to MySQL converting/replicating (both csv&dump) under *nix. Possible to use it with crontab for regular data fetching.Keeping mySQL-based data warehouse refreshed could also be one of the possibilities of using this script. MySQL-Formmaker - Free (GPL)MySQL-Formmaker is a tool for easily creating administration forms and displaying the output of data for MySQL. You define your forms, types of input, order, etc., and the system makes a database, the admin-files and the output-files for you. Version 1.3 focuses on a lot of javascript features for admin's textarea. A lot of bugfixes offcourse, mostly mentioned by users. Small Unit Raid - Free (LGPL)Small Unit Raid is a non-OO database abstraction
layer written in PHP with the objective of being
fast and small in size. Based on the idea of
using structures (method-less classes as php doesn't support struct), it provides a high level of abstraction and impressive speed in comparison to OO based layers. Its target audience are those developing Web sites that do not need/want the overhead of feature rich libraries and/or the performance penalty of objects. Create SQL - Free (GPL)A class that creates your common sql query code using just a given array. The author uses this class as an extension to his database class to do some cool stuff. Automating is the key. N Table Dropper - FreewareThis is an extreamly easy to use mysql table dropper for quickly removing unwanted tables. Matt's MySQL Control Panel (MPanel) - Free (GPL)This is a collection of PHP scripts that provides a Web interface to administrate MySQL database. Some of its main features include: Create, update, delete MySQL databases; Create, modify, delete table fields; Abililty to import/export data into and from the database; Password-protected admin, and much more. DataMan - Free (GPL)DataMan is a simple tool to manage data in a mysql database. You only need to point the tool to a db host, and the tool does the rest. Databases, tables and fields are generated automatically from the host server. It is a great tool for content management - so you do not have to worry about providing admin interfaces - just create a great looking front-end. Dataman also logs all queries.
OpenDb - Free (GPL)An extremely flexible application to catalogue all sorts of things including DVD, VCD, CD, VHS, GAMES, BOOKS & Laser Discs. The OpenDb allows you to add new types, by describing them in system database tables designed for the purpose. This software provides flexible borrowing system, title rating, statistics, import (CSV) export (Excel, CSV, XML), role based user authentication and administration. phpMyDumpA web-based script dumping definitions and data from MySQL. cleverSQL tool - FreewareIf you ever created or administrated a remote database, you know how difficult it is to change smth. in it remotely. cleverSQL tool is a small but still powerful script that will help you to administrate you remote databases quickly and easily. Text to DB - Free (GPL)This simple php script shows how to Dump delineated text file export of table to SQL (MySQL) table. cy_virtual hostaccount manager - FreeThe author writes "This is a little script I wrote in order to make quick backups of the numerous virtual accounts I got running for clients. This script is far from complete, i'm working on a validation addon, and a function to auto optimalise tables. Installation is pretty easy, create a database, create table by running the .sql file and configure db.php."
mysql_html_table - FreewareThis very simple script will display your mysql table in an html table with an option to do simple pagination like next and previous.
|
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
| |
|