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

ext_shapelib provides access to Shapefiles (.shp/.shx/.dbf) as used in GIS applications. Currently, creating of new files and adding shapes to those files is supported, however, full shapelib support is planned for upcoming releases.

A simple PHP class to manage all sqlite database related operations, including database creation, queries, etc.

ezSqliteAdmin is a tool written in PHP & XUL intended to handle the administration of SQLite over the Web. It requires PHP >= PHP5.0.0 & Mozilla platform to run.

MySQL Dialog is a simple MySQL database access wrapper class to execute SQL queries and display the results in HTML tables. The class connects to a MySQL server, sends SQL statements, and gets the results as an array. A table with the data from the result sets can also be displayed. The class may optionally return error messages on failure based on the mysql_error() and user defined error messages.

These archives include all files necessary to calculate the distance between two U.S. Zip Codes using PHP4+ and MySQL.

This is an extreamly easy to use mysql table dropper for quickly removing unwanted tables.

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.

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.

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.

This is a set of classes used to connect, select, and disconnect mysql. Currently it only works with mysql but the future versions will also support oracle, msql, and postgresql.

This is a simple MySQL PHP class that allows you to easily connect, do queries, etc with your DB. Easy to set up.

EZDB is a php script/tool developed for simplifying form creation and sql insert tasks for database. It creates the scripts and puts them into separate files. Currently only MySQL is supported. v2.0 update: this is a better version, it has some more features requested by hotscripts users.

This is a handy script that provides a quick query-based interface to your MySQL database. Whilst PhpMyAdmin may be the best solution for managing mysql databases, there are cases, when for a simple peek into your mysql database, you need for wait for long for the entire PhpMyAdmin page to execute and download. In those cases, this WebSQL can come in handly. There is another nice advantage for users who would like to type in their queries against the normal trend of click and pick.

QueryPrint is a PHP class that prints the results of a SQL query in HTML format. The printing is defined in a seperate module class that can be modified or replaced. QueryPrint also supports multiple page queries allowing the user to decide how many records to show on each page. The previous and next buttons are added automaticaly and as defined by the printing module. This site requires registration in order to download the script.

Mlam is an advanced set of PHP4 libraries that allows developers to easily create database-driven projects using MySQL. It can handle various types of data (text, date, number, file, picture, external keys, link tables, etc), and includes its own management tool to edit and list (with search engine) database content for the given projects. Mlam also features user access restrictions, contains its own cache system, and supports English and French. Tutorials are also available to present the basics of mlam.

ADODB_SQL allows you migrate your code using DB_Sql format (PHPLIB) to an another DB engine like ADODB.

This is a page numbering class that generates previous, next, pages number and results range links for database queries.

Database Abstraction Layer is a project to produce a general way to access databases from within PHP. The DAL class takes care of the administration involved with the different kinds of databases. DAL is extendible via plugins so support for different dbms' can be added dynamicly. Also switching from one DBMS to another is simple because not very much has to be altered to support the new DBMS.

MyLibrary is a PHP/MySQL application to manage a library or a list of books and authors. It features search engine, statistics, and is very easy to customize for your site. MyLibrary is written in French.

This is an attempt to create a relational form wizard for the PostgreSql database. Presently it only works for two tables which are relationally indexed. All the form features are available from previous work on the Formwizard for PostgreSql v1.0. Update:12/18/2001: The script has been updated to work on single table to five related tables. An example is provided. The script now works on Linux, Unix and Windows platforms.