Top Rated Scripts | PHP | Scripts & Programs | Database Tools

It�s a wrapper for the mysqli methods and query constructor with pagination. It make simplier to work with the daily sql statements in a fast wizard way.

Now includes detailed reporting - phpMySQLAutoBackup the simple way to backup MySQL databases - 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 phpJobScheduler. New features include the ability to select separate tables for backup, and limit the backup to start and stop at pre-set table row numbers, this will now allow a section of a large table (with millions of records) to be selected for backup. Features: * option to ftp backup file to remote server * email zipped database to your specified address * option to save to backup folder * backup limited to once per hour (easily changed) prevents malicious attempts at bringing down your server * specify specific tables to include or exclude, or backup the whole database * set ranges to backup - from start row number to last specified row number

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.

This database management script is a great basis for writing code for using a database. It includes error catching and sanitation.

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.

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.

Micro DB Manager is a database abstraction class written in PHP using object oriented technologies. The class realize the following functionalities: * Connectiong to the databse * Executing queries * Converting results to associative array * Get selected rows * Get affected rows * Get last insert id * Get the number of executed queries * Get the execution time of the queries * Get error messages and codes

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.

PuszBaza is a flat textfile-based database script based on PHP4. Data is stored in a similar stucture to the csv files. Puszbaza can be used to easily create guestbooks, forums, counters, etc. Please note PuszBaza currently includes no security feature. Anyone who knows the name of your data file will be able to view your data. The documents are available in English and Polish. Version 1.2.2 includes new documentation, new capabilities, and delete-last-line bug fixed. At hotscripts you can find a several scripts based on puszbaza: phpPuszAdmin (to manage PuszBaza database), PuszGuestBook (simple guest book), PuszForum (simple discusion board).

DB-RSE is a PHP program intended to be a very simplified MySQL database record selector and editor. Having only two files, it is simple to install and setup. Just put both files in a folder (preferably either secure or obscure), modify the dbconnect.php file, and load the main file in your browser. It also acts as a back-end to its parent program, "Form-a-Form -- Quick and Simple Form Creator for PHP".

This class can be used to execute MySQL queries and get paginated results. It can insert, update and delete MySQL database table records with eventual prior validation of the field values according to given rules. The class can also execute SELECT queries with support to retrieve results to show in paginated listings.

Pandra (PHP-Cassandra) is a light weight, flexible PHP based CRUD extension for Cassandra / Thrift suitable for object relational models or factory design patterns. Pandra objects can be created on the fly from existing keyspaces or dynamic user data without requiring any kind of schema. However, it will happily enforce ColumnFamily/SuperColumn schemas and validate column values where needed with minimal overhead.

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.

Zebra_Database it is an advanced, compact (one-file only), lightweight, object-oriented MySQL database wrapper built upon PHP's MySQL extension. It provides methods for interacting with MySQL databases that are more intuitive and fun to use than PHP's default ones. The class provides a comprehensive debugging interface with detailed information about the executed queries: execution time, returned/affected rows, excerpts of the found rows, error messages, etc. It also automatically EXPLAIN's each SELECT query (so you don't miss those keys again!). It encourages developers to write maintainable code and provides a better default security layer by automatically escaping strings. Zebra_Database's code is heavily commented and generates no warnings/errors/notices when PHP's error reporting level is set to E_ALL.

The CSV Importer 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 Importer 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!

Upload your CVS converted MS Excel or Text files to your Mysql database very easily with this simple little script. You can use it independently or integrate into your existing script. Free to download for non commercial use. Visit our site for more FREE stuff

phpFriendlyAdmin is a remote database administration tool made specifically for non-technical people. After your database is set up, phpFriendlyAdmin is then configured to abstract database structure, making it easier for users to focus on manipulating content. Every field and table is given an alias and a description so as to bypass the complexity of interacting with database variables and offer a simplified form-driven approach to data entry.

Bear SQL is a light, easy to use, web front end to MySQL. It allows you to manage databases, tables and users, including backup and restore functionality. With Bear SQL you can create and remove databases and tables, add, edit and delete records, alter tables, add and remove primary keys and indexes, add edit and delete columns, change column properties, search tables, optimize tables, write your own queries, save queries, save query results, add and manage users and more. All from a simple web front end.

PHP Admin Panel (PHP AP) provides you access to the control features of your site as creating static or dynamical pages and allows your easily manage database tables with embedded PHP DataGrid. It includes Creating, Reading, Updating and Deleting (CRUD) records in database tables on your existing site. You can edit menu options "on fly" and create new menu just in a few clicks.

BackupZip creates a .gz zipped backup of a MySQL database on demand. You can either backup all tables within the database or chose to just backup specific tables. Used with cron and an automated ftp download, you can completely automate database backups! If you don't have access to cron, setup a reminder or scheduler to run this script daily or weekly via your web browser and download the zipped files via FTP when convenient. If you don't have access to cron or would prefer to output the backup file directly to your web browser, see the Backup scriptlet.