Multicolumn Select

LSM Explain Plan can retrieve the explanation of the execution of a given MySQL database SELECT query and compute a relative performance factor.LSM Explain Plan executes an EXPLAIN query to retrieve the information about the tables, columns, indexes and search methods involved in a SELECT...

SELECT, INSERT, UPDATE and DELETE queries can be executed from lists of parameters defining tables, fields, field values and condition clauses with MySQL Database Layer With Dynamic SQL Generators.

SQL Engine can execute SELECT, INSERT, UPDATE and DELETE queries. It takes care of emulating auto-increment fields if these are not supported, using sequences.SQL Engine can also create a new database table or alter its fields if the table already exists. A separate class can be used to log the...


Platforms: PHP

Argument values that define tables, fields, field values and condition clauses can be passed to INSERT, UPDATE and SELECT queries.


Platforms: PHP

basic_db can perform SQL queries SELECT, INSERT, UPDATE and DELETE from arguments defined programmatically. The tables are defined by arguments to query, fields, WHERE and ORDER by clauses.


Platforms: PHP

UtilsClass for phpLib, provide 4 methods to select, insert, update and delete data from database.UtilsClass is really a simple work, but it was helpful to me, so I thought to make it available.


Platforms: PHP

SELECT, INSERT, UPDATE and DELETE queries are supported in dbclass with execution query.The results from SELECT queries are gathered in a single array with values stripped from any slashes.


Platforms: PHP

classDataObject executes SELECT questions to a database table and retrieves records into arrays. It can generate pagination links to browse listings of table records split in many pages.classDataObject can also execute INSERT and UPDATE queries to set table records with data from array parameters.


Platforms: PHP

Oh!DB Table Data Gateway can perform the following operations:- Execute SQL SELECT queries from list of fields of a table- Retrieve the highest or the lowest value from an integer primary key table field- Get or delete one record of a table with a given primary key value- Delete all records of a...


Platforms: PHP

sql4array can execute SQL SELECT queries on bi-dimensional array, for which the first dimension is the row number and the second dimension the field names.The WHERE clause can be used to specify conditions with operators such as =, >,The results are returned as arrays and can be sorted with the...


Platforms: PHP

PDO_EXT provides one class that extends the PDO database access abstraction class to simplify the execution of SELECT, INSERT, UPDATE and DELETE queries. Another class can be used to execute an SQL query and generate an XML document from the results.


Platforms: PHP

SELECT, INSERT, UPDATE and DELETE SQL queries can be executed, using the specified table and field names, field values, condition clauses and other parameters.


Platforms: PHP

SQL SELECT queries can be executed to retrieve values of individual rows with a specified primary key value into an array.DELETE queries can be executed to remove rows with a given primary key value.


Platforms: PHP

Easy Connect to MySQL is a very simple class that can be used to connect to a MySQL database and execute a SQL SELECT query.It consists of a single function that does everything at once: connects to a given MySQL database, executes a given SELECT query and returns the query results in a...


Platforms: PHP

Form Classic is meant to output forms with common input field types: text, hidden, password, textarea, radio, checkbox, select.Characteritics are:- Can disable each of the inputs- Custom picture for radio and checkbox inputs- Select inputs can have a sorted list of options from a default value to...


Platforms: PHP

Simple Paging can be used to show navigation links to browse MySQL SELECT query results split in multiple pages. It can calculate the total number of pages to display the results of a given MySQL select query.Simple Paging generates a navigation bar made of HTML links to go to the next, the...


Platforms: PHP

populate_sel populates the select form field from mysql table.


Platforms: PHP

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


Platforms: PHP

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


Platforms: PHP

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.


Platforms: PHP