Queries

AEDEDL class handle database queries automatically: Add, Edit, Delete, Enable, Disable, Listing.

This script can execute MySQL databases queries using arrays. It can connect to a MySQL database and execute SELECT queries retrieving the results as associative arrays.The script can also excecute INSERT or UPDATE queries taking arrays of field values. It can also execute DELETE queries.

MySQL DB Management Class can access a MySQL database and execute SQL queries retrieving the results into arrays in a single call.MySQL DB Management Class can also show links to browse the query results split among multiple pages.INSERT and UPDATE can be executed from lists of parameters.


Platforms: PHP

Insert Retrieve data from Table can be used to execute MySQL database queries to insert and retrieve data from table records. It can insert a record in a table given an array of fields and the respective values.Insert Retrieve data from Table can check if there is already duplicated record giving...


Platforms: PHP

Simple Operations can be used to build SELECT, UPDATE and DELETE SQL queries to MySQL from lists of parameters.Features of Simple Operations:- Establish a database connection automatically from the constructor function- Build a SELECT query to a table with a given optional condition and order by...


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

EZ Select is a class to make it easier to create complex MySQL "SELECT" queries, especially based on user input.


Platforms: PHP

rsmysql is a simple MySQL database access wrapper class that can measure the time spent executing the database queries.rsmysql can establish persistent and non-persistent connection to a given MySQL database server, execute SQL queries and return the query results in arrays.The total number of...


Platforms: PHP

This tool consists of two files, one to execute queries submitted by form or uploaded as a file and display the results, and another to dump the database in MySQL or MSSQL format.GreenLight SQLTool can be used with either MySQL or MSSQL databases. Together they can be used to migrate a database...


Platforms: PHP

Closes comments on old posts on the fly, without any DB queries. By default it's 14 days, change that setting by editing the plugin file.


Platforms: PHP

This module provides functions which allow the developer to deliver the results of queries in tables which are capable of vertical and horizontal scrolling. The most obvious use is for "matrix" style displays which would be too large for normal screens.There are two main functions:crosstab_table...


Platforms: PHP

This script can generate SQL queries from objects or arrays. It can traverse the list of variables of the object or a given associative array and generate SQL INSERT or UPDATE queries to create or update records of a given database table.The names of the table fields are taken from the object...


Platforms: PHP

MySQLQueryGenerator is a set of classes that can compose queries to run on MySQL from a list of parameters that define tables, fields, field values and conditions.Separate classes can compose different query types like SELECT, INSERT, UPDATE and DELETE.


Platforms: PHP

SQL Parse Convert to Tree Array takes a given SQL query and parse it to extract the structure or queries and sub-queries. The resulting structure is returned as an array.SELECT, INSERT, UPDATE and DELETE queries are currently supported.


Platforms: PHP

Auto Insert can process the array of form posted values to build and execute MySQL INSERT or UPDATE queries that can add or change records of a given table.Value array indexes submitted to the form are used to automatically set the names of the form fields.


Platforms: PHP

MM::CMySQL can be used to execute parameterized MySQL database queries. It is a concrete implementation of the CDatabase abstract base class that implements support for executing MySQL database queries and retrieve its results.MM::CMySQL also uses CLog class for showing error messages in popup...


Platforms: PHP

MySQL Paginator can be used execute MySQL database SQL queries and display the results split in multiple HTML pages. It can connect to a given MySQL database and execute an SQL table.Then MySQL Paginator can display a limited number of results in an HTML table with links to navigate between the...


Platforms: PHP

Mysql Database Functions is a wrapper around MySQL database access functions that can execute SQL queries, retrieve data from tables, list tables, list table fields and optimize or truncate tables.


Platforms: PHP

Operaciones Database can be used to compose and execute SQL queries to a PostgreSQL database.It provides several functions that can build SQL INSERT, UPDATE, DELETE queries from a list or arguments that define the fields and values used in the queries.


Platforms: PHP

MARK_MYSQL class is a wrapper for MySQL queries. It is very easy to use.


Platforms: PHP