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

A PHP4 and PHP5 database abstraction library. Supports MySQL, PostgreSQL, Interbase/Firebird, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, Sybase SQL Anywhere, DB2, Informix, Frontbase, SQLite, LDAP, Netezza, SAPDB, generic ODBC/ODBTP, PDO etc. ADOdb provides code to handle inserts and updates that can be adapted to multiple databases quickly. A basic paginated grid is also provided, and support for database-backed session variables. Support for PHP5 iterators and exceptions included. Methods are provided for date handling, string concatenation and string quoting characters for differing databases. A metatype system is built in so that you can figure out that types such as CHAR, TEXT and STRING are equivalent in different databases. Able to create databases, tables, indexes portably using an xml schema or programatically. Also has sql performance monitoring and schema creation using XML.

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

With the "Txt-Db-API" you can access normal text files like a SQL database. You need no special Database Software on the Webserver, but can still use SQL. You can use the API to create, query, change, delete Tables, and you don't have to bother with the Text-Files themself, (almost) everthing can be done with API calls. The Txt-Db-API is object oriented and very simple to use.

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.

phpMyAdmin is intended to handle the administration of MySQL over the web. Currently it can: create and drop databases, create, copy, drop and alter tables, delete, edit and add fields, execute any SQL-statement, even batch-queries, manage keys on fields, load text files into tables, create and read dumps of tables, export data to CSV values, and administer multiple servers and single databases, check referential integrity. It supports about 40 different languages.

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).

Ease of use was the main idea behind this class. The goal was to develop a class that has few but powerful functions. Additional, advanced features like paging, and dumping of data are provided as well. Works with PHP4 and PHP5.