Most Popular Scripts | PHP | Scripts & Programs | Database Tools

phpFastCache dropped the database load to almost nothing, yielding faster page load times for users, better resource utilization. It is simple yet powerful phpFastCache also supports APC, MemCache, MemCached, WinCache, Files & PDO. It will auto detect and pick a good cache for your pages.

AbstractDB is a PHP database abstraction layer, objected oriented and extensible via driver implementations which extend from a common base class. This package encapsulates all of the basic functions required by most developers without the complexity and/or utter simplicity of many other abstraction packages. Incorporating AbstractDB into your applications is as easy as including a single file. AbstractDB is currently only distributed with a driver for MySQL but can easily be extended for use with other database servers or even other abstraction libraries.

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.

Roundbase is a way to easily enter information into a mysql database, Features include easy install, customizable php tables, small file, stats for totals, and a small file to download. NEW IN VERSION 2.5: HTML TAG STRIPPER SECURITY HOLE IS FIXED IN THIS VERSION.

If you have ever wasted your time re-writing code for database administration, this tool may be for you. The Add, Edit, Delete Admin Tool allows you to quickly and easily create administration tools for any mySQL database table. A.E.D. gives you all the options you would have if you were hand-coding each tool. Simply put, you supply the options and information, and A.E.D. will generate the PHP code for you. Automatically generate add, edit and delete admin tools for any table in your mySQL database.

This class can be used to create HTML forms for entering values to create new records of a MySQL database table. It identifies the list of fields of a given mysql table. Then it generates HTML for a form that includes inputs to enter values for the fields of a new record of that table. The class generates text or textarea inputs depending on whether a text field has more than 50 characters limit length. It also generates password inputs for MySQL password table fields, and select inputs for enum table fields. The class also can display the results of a query that retrieves the records of a given table.

This PHP class can import data from an Excel file without using COM, ODBC, etc. It will be useful in content management systems, for writting various converters (Excel to HTML, Excel to MySQL, etc.). On-line demo and trial version available for download. ExcelExplorer will work on any PHP5 platform. Supports Windows and Mac Excel files. No additional classes, modules are required. No configurations needed. Just include it in your own script and use it. With this class you can read such data as used color, fonts, rich text, asian phonetics, etc. Shapes and images also supported. What data can be imported: worksheets name, type (ordinal, chart or Visual Basic Module), visibility flag; rows and columns info; cells - type (integer and float numbers, percentage, text, formula, logical, error, date in Windows Excel and Mac Excel formats), empty, blank and merged.

noSQL is a small set (7kb) of SQL-like PHP functions to manage a database in an SQL-like way without a SQL-server. Everything is stored in flat .csv-formatted files, so putting data into noSQL or getting data from noSQL inside a spreadsheet program works immediately. If you are too lazy to setup an SQL-server, or you simply don't have one right now but perhaps later in the future, use noSQL.

This comes handy because you can simple edit the appropriate fields, upload it along with the csv file and call it from the web and it will do the rest. It allows you to specify the delimiter in this csv file, whether it is a coma, a tab etc. It also allows you to chose the line separator, allows you to save the output to a file (known as a data sql dump). It also permits you to include an empty field at the beginning of each row, which is usually an auto increment integer primary key. This script is useful mainly if you don't have phpmyadmin, or you don't want the hassle of logging in and prefer a few clicks solution, or you simply are a command prompt guy. Just make sure the table is already created before trying to dump the data. Kindly post your comments if you got any bug report.

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

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

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

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!

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.

phpMyBackupPro is a web-based MySQL backup application in PHP. You can schedule backups, download, email or upload them with FTP and backup whole file directories. Zip and gzip compression, easy interface and installation. Many languages and online help!

DbFacePHP is a self service report and dashboard builder for SQL databases. With the straightforward interface, you can build tabular, summary, chart, number, google map without coding a single line of code.

Webmasters, Save time on your projects ! Powerful Data Management Tool, PHPEasyData is a PHP application which allow you to manage and display on the web your dynamics data and directories . PHPEasydata will largely facilitate all steps of a classical development to put data on your website (fields definition,database creation, forms to add/update records , php process to display records, members area, comments etc.) and more classical functions ... It will fulfill the requirements of professional webmasters as well as not experts webmasters wishing a genuine tool which combines powerful and facility of installation for the realization of various part of a website or to realize a complete directory. Data Directory means Link directory for the simplest usercase as well as complete ans customized directory with your own informations.

Backup outputs a copy of a MySQL database in sql format directly to your web browser. You can either backup all tables within the database or chose to just backup specific tables. Simply run this script, copy the output, paste it into plain text file and save it for future use. If you have access to cron or would prefer store zipped backup files on your server for later download via FTP, see the BackupZip scriptlet.

Micro Database Browser is a simple PHP script which can list your available databases, tables and displays data stored in it. It's purpose to give you an easy installable product to verify your actual DB status without installing professional database management tools.

This class can be used to generate backups of PostgreSQL. It accesses a given database and generates SQL statements that can be used to recreate the database tables and the values stored on their rows. The generated SQL is stored in a given file. The class can also restore a database from a previously generated backup by executing the SQL statements stored in a backup file.