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

txtSQL (pronounced "text-sequel") is a class containing a variety of functions designed to mimic a database system, using only regular text files. It is object-oriented and can be looked at as sort of a framework in creating larger scripts (such as guestbooks, polls, forums etc.) There are two levels of access; a low-level implementation that works on just function calls and the other relies on the support of SQL (a parser/lexer is currently being developed). As far as I know, txtSQL is VERY efficient in how it handles its data and the way in which it is handled has also almost never caused any major concerns (data loss is rare). txtSQL does not require any outside plugins to operate, it's in the ballpark of "plug and play" (with a few exceptions of course). But most importantly, txtSQL is an opensource project (listed under Sourceforge), licensed under the GNU, which means that it's totally free of charge and will remain as such forever.

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.

Do you want to move your DB to the Web without programming a dedicated app? DaDaBIK is a very popular software which makes the creation of PHP online database apps easy. Now also for Wordpress! No coding required; if you have a MySQL, PostgreSQL, SQLite or MS SQL Server DB you can create a basic CRUD (Create, Read, Update, Delete) database front-end in minutes or, through a visual interface configurator, a more sophisticated database application. Features include: forms generation/customization, datagrid generation/customization, datagrid HTML template customization, 12 field types, file uploading, master/detail views, duplication checking, authentication, granular permissions, integration with external user/group/password lists, record locking, record ownership authorizations, CSV and PDF export, email alert, SQL logging, Revision/Audit, pre-defined/custom formatting rules, pre-defined/custom validation rules, front-end in 22 languages

Generate your database reports with this wizard in only a few minutes on any of your existing MySQL databases. Since this is a php driven application you simply upload the application files to a folder within your web site and you are ready to generate reports. Execute statistical queries such as sum a column.

Create dynamic-easy-to-use data grid controls for your web site in seconds

Designed to create a daily snapshot of the dynamic data on your website. (e.g. content management systems, forums, guestbooks etc.) Some of the features include: - Backup multiple databases and servers with different users and passwords. - Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems). - Create daily, weekly and monthly snpashots of your database. - Keep the daily, weekly and monthly backups for a user-specified time. - Archive and compress the SQL files (*.tar.gz). - Creates a detailed report of everything that has been done. - Reports can be mailed to you or any other user-specified email-address, saved to disk or displayed in browser. - Generated SQL files can be mailed to you or any other user-specified email-address. - Generated SQL files can be uploaded by FTP to any user-specified FTP server. - Choose to create SQL files for each table or one for each database - No system calls, everything in 100% pure PHP.

Backup program for MySQL databases that creates MySQL database backup files on your server. The backup files are in the same format as the phpmyadmin dump files. Simple installation. Optional german or english language. Comments in German and english.

The main difference between this script and other backup solutions is that the current script are splitting the backup process into more than one sub processes and each sub process is saving a small part of your database.

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.

SQLiteManager 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

PHP DataGrid has been created for selecting data, displaying it as a grid, and to perform routine operations on it. It allows paging through results, editing, deleting and inserting new data. PHP DataGrid can be very helpful for you to display any complex data from database and to automatically perform any needed operations of them. By enabling or disabling its features you can turn PHP DataGrid into something very helpful for you. You know how important such a tool for creating web applications is. Really, data grid is heart of almost every web application.

phpdbgrid uses Adodb to view data in a database. It has many options to customize the layout.

This class works under PHP4/PHP5 and all MySQL Versions from V3.x and newer. It features an easy-to-learn API and an error-management which includes auto-sending of EMails in case an DB error occured. The archive comes with complete documentation and some examples to show basic usage of this class.

Populate Mysql database with as much data as wanted. very useful in testing stage

dbfConverter is a PHP script that reads data from dbase files (dbf,dbt,fpt) and convert them into the mysql or postgres tables. Initially, it create sql tables & insert data, and then updates old data. It does not support index files converting jet. Configurable feautures: join 2 or more dbf files in one mysql table, add primary key id field, support more same named dbf files from different locations (directories), transform characters or words in data, update sql tables with new data from dbf files in 2 modes, filtering data which you don't need in sql tables.

This is a Simple CSV Upload script that makes use of the 'LOAD INFILE' Query of MySQL. This is a script which can upload CSV (Comma separated values) file to the database, provided that the the fields in the file match the fields of the database provided in the configuration, irrespective of the database structure. Features * Upload Files and retain them * Loads data irrespective of the database structure

With HMS_BACKUP you can make a backup of your MySQL-database. This backup can be sent by e-mail or uploaded through FTP. This script doesn't need privileges to execute *nix commands. It's 100% pure PHP.

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.

MySQLDataManagement is a set of php scripts to manage your data for selected DBs. All your tables will be shown you for data management on them. MySQLDataManagement allows you to add / edit / delete / list records on selected table - DB. Easuy to use and install.

This is a function to convert a user's query in boolean syntax ("hotels AND mexico NOT cockroaches) into a SQL query over the appropriate database fields.