SQL wrapper - steffan

This is a simple MySQL database access wrapper class. It provides functions to connect to a given MySQL database, execute a SQL query, retrieve the query result data and number of rows.

SQL XML - Rich Zyg

This class can be used to generate XML documents from MySQL query results. The class executes a given MySQL query. It may restrict the range of extracted rows to a given page on which a configurable limit number of rows is returned. The generated XML documents are defined by row and column tags that contain the values of each query result row and column. The XML documents also include tags that export the total number of rows, number of results per page, total number of pages and the cu

sql2dia - Daniel A

This class creates a diagram from your sql file.

sql2excel - Erh-Wen,

This class is designed to provide a easy way to output mysql sql content in Excel Format & stream it on the user's browser directly.

sql2table - Erh-Wen,

This class is designed to provide a easy way to display mysql sql content in HTML table form with pages information and navigation link.

SQL2TXT - Pablo Da

This class select data of PostgreSQL DataBase by SQL instructions and write results into TXT file (SDF). Alignment and lenghts of columns are configurable.

sqlCache API Library - Dmitry S

This package can be used to cache the results of SQL database query results in files. The idea is to increase database application performance by avoided to access databases to retrieve the results of queries being executed repeatedly. This package provides an API that encapsulates the execution and caching of SQL database queries that maybe executed by several types of database APIs. Currently it supports supports AdoDB and PHPBB DAL. The package stores cached result sets in files and

SQLCall - Vincent

SQLCall uses PHP's highly dynamic nature to give the calling class unprecedented access to the result set in an intuitive way. It currently only supports connections to mySQL databases. This class is perfect for those who like their results at hand - no hashes or lists to have to walk through.

SqlClass - Adam Wi&

Class to interface with multiple SQL databases. It supports mysql, msql, mssql, pgsql, ODBC, interbase and sybase. Only interbase is not fully supported (doesn't have the numrows method). It's now only the 0.9beta version.

SQLite DB Handler - José Au

This class can be used to create and manage SQLite database files. It can create databases tables from a list of field declarations passed as an array. SQLite does not implement many types table alterations. This class can emulate table alterations by recreating a table with the altered fields and inserting the old table field values. The class also supports a turbo mode by executing special pragma statements that can enhance the database access performance. The class error messages

SQLite Full Text Search - Setec As

The class implements a User Defined Function (UDF) that adds full text search SQL commands to SQLite. This User Defined Function allows to execute a simple full text search queries against the text fields of SQLite database tables.

Sqlitei - Andrea G

This class can provide an interface to access SQLite databases that is similar to mysqli interface. It emulate the following mysqli features: - prepare to setup prepared or direct queries - bind_param to automatically parse given ? placeholders - bind_result to chose the name of the variables that will be initialized with values returned by queries - execute to execute prepared or direct queries ) - close to free a result set or close database connection

SQLm - cypreess

This class is meant to process and execute SQL queries to PostgreSQL databases using template files to define the SQL statements and the Smarty engine to process the SQL templates and assign the query parameter values. The class includes means to profile the queries that are executed keeping track of the time that they take. The class may also highlight the query statements with SQL syntax using the GesHi package.

sqltoolkit - Erik Gib

The PHP SQL Toolkit is a PHP class system for abstracting database calls. Using classes or functions, it abstracts the underlying database structure into data sources in a manner similar to ODBC. Data sources are defined in one file and a standardized syntax is used for connecting to all databases. This is useful for portable code or for referencing multiple databases on multiple platforms all at the same time.

sql_Generator - Carsten

This class is meant to make it easier to generate SQL queries for inserting or updating records in a database table. Just specify the required fields, and then call the class functions to retrieve the SQL statement to perform an insert or update query.

sql_query_generator - Toby All

This class will generate a large range of SQL SELECT queries from a submitted form. It provides facilites for simple queries on one field on a table, joins, selection of fields to be returned, aliasing of fields (eg. SUM(Price) AS Total), ORDER BY, even multiple queries from one form. Comes with a basic demo file, which I hope to update in time. GROUP BY and HAVING are also provided, but not entirely reliable. Demo file provides overview of creating forms necessary to generate results.

Storeip - Bas Jobs

To Store ip-addresses in a database, you will need a field type of Char(15). This class let's you store the ipnumbers as an integer ( between -2139062144 and 2139062143) This class has two functions 1) decode ip->number 2) encode number->ip Both functions return false for empty or wrong ip-numbers While using this class you will spare typical 11 bytes for every ipnumber you store. Char(15) needs 15 Bytes SIGNED INT(10) needs 4 Bytes

SunMatDB - Mattias

This is actually three classes combined: DB, RS and ROW. The DB class opens a connection to the database, executes queries and takes care of the error handling. The RS class takes care of traversing the actual result set including the prev() and next() methods. The ROW class wraps one row of the result set that is returned from a RS object when prev() or next() methods are called.

swemc - Uwe Stei

This class can connect of a MySQL database, execute SQL query and output the query results in HTML tables. It provides functions that can: -Execute select, update, insert and delete SQL queries -Output query results in HTML tables that can have their presentation customized with CSS. -Output HTML tables also customizable with CSS with the results of queries that retrieve single database table records -Retrieve specific query result values by column name or field number -Retrieve a spec

Sync DB Content - Huda M E

This class is meant to synchronize two MySQL database copies. It queries a source database to determine which rows were updated since a given date and generates a text file that contains SQL queries for updating the target database to synchronize its contents.