Joe Celko Nested Sets is meant to manage tree database structure using Jeo Celko's nested sets approach.You can add node with 7 queries, delete a node with subnodes with 4 queries and move node with 11 queries.The number of queries per action does not depend on the number of sub-nodes, so it is a scalable solution.

MySQL Server Status retrieves the status of a MySQL server using SHOW STATUS query and returns the values in an array.Also, it provides functions for formatting these status values for better presentation: Formatbytes (determines TB, GB, MB, or KB and limits output to a number of decimal places that you provide) also TimeSpanFormat (returns the number of days, hours, minutes, ...

my_sql is meant to interface with MySQL or SQLite databases.my_sql can be used to execute queries, show query execution time, to create execution time statistics, to check replicated queries, to export data dumps to file, to import data dumps from a file, etc..

Using a hash array, a user may escape or un-escape any string using any string. Also unescape it, or customize it for any database, or other application. It prevents(?) or lessens the likelyhood of SQL injection.

DatabaseAccess abstracts database queries (UPDATE, SELECT, INSERT, REPLACE, DELETE) by passing data to class methods, the query will be generated and run automatically.DatabaseAccess is meant to be used in conjunction with the ADOdb database library.

MySQL utility is a class meant to execute tasks for multiple purposes of accessing a MySQL database.Functions of MySQL utility:- Take a backup and restore a database using MySQL dump files- Execute the most common types SQL queries passing lists of parameters- Perform controlled rollback to undo the last executed SQL query whenever possible- Copy a database from a local ...

This Visual Basic and PHP combination allows you to remotely execute and retreive SQL queries to and from your online databases. The VB code makes http requests to an online script (written in PHP) which executes your query and returns the result. The queries and results are encrypted using rc4 encryption, which is now free for use (no patent fees ...

DBI MySQL is MySQL database access wrapper.It can establish database connections, execute SQL queries, retrieve the query result set data, present SELECT query information details like the time it took to execute and the returned result rows.

Simple Users Online is meant to keep track of the users currently accessing a site. It stores the unique IP addresses of each users online in a database. The class tries to determine the real IP address of uses behind proxy servers.Simple Users Online also performs the maintenance task of deleting all the records of user IP addresses that are ...

Metafire is a very simple database abstraction layer for firebird/interbase. To use it, you have to know things about php-function for firebird/interbase. But still you can use it as you use mysql or postgres in a simple way

c_mysql is a MySQL database access wrapper that can retrieve data records either in arrays or XML documents. It can execute SQL queries for selecting, inserting updating and deleting data records in a given MySQL database table.c_mysql also provides error reporting support by either outputting error messages to the browser, to a error log file, both or neither.