|
|
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!
class-1 Backup/Restoreclass-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 EZ Results Paging Class - FREE (LGPL)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. ExcelExplorer Pro - Free-to-try, CommercialThis 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. xSQLiteA simple PHP class to manage all sqlite database related operations, including database creation, queries, etc. MySQL Class - $18MySQL database connection and query class.
Sets the database details and connection and allows you to insert or query your MySQL database.
A perfect tool for developers. Raga's MySQL DumperThis MySQL database dump manager was coded to make taking backups of databases and managing them easier. You can dump and gzip any database just by browsing your way to the script and inputting the relevant details to a form and clicking a button.
The built-in directory indexer shows you all the timestamped database gzips in the folder and allows you to download and delete them as necessary.
No .htaccess or other methods of protection are necessary, the script is safe to leave online as it is due to its access password verification.
See the URL for a screenshot of the script in action. Assure Database Backup Software GPLThis 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. webXadmin - Free (GPL)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. txtSQL - GPLtxtSQL 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. DB_Table - FreeBuilds 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. backupDB() - Free (GPL)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. Text Database PHP Class - Free (Modified GPL)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.<br><b>Update</b>: version 4.3.3 includes limiting the query() results, editfield() and removefield() were also added. Ariejan.net MySQL Backup Tool - GPLA.M.B.T. - MySQL Backup Tool is designed to automate and simplify the process of making regular backups of your MySQL databases. PHP Excel Parser Pro - $99.95/Free trialNew 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 SnfoorOne file, 24KB size, to backup your database and dump it again at anytime, for large databases, easy and powerful. No database for it. u can backup many databases and the script will show every data base with the date and time when it backed up and u can dump any one by simple click. this script dumped 650MB database with no problem and very fast. It required password to login the script Control panel. I invite u to take a look at demo. visit my site :). nstrees - nested set tree library - GPLThis 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.
table exists - FreewareI 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. SQLiteManager - GPLSQLiteManager 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 Simple SQL - GPLDESCRIPTION:
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. Comdev CSV Data Tool v2.0 - 59.00The 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!
|
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
| |
|