Queries

MySQL Transact is a simple class can queue several MySQL database queries and execute them all at once in a single transaction. It provides means to add SQL queries to a queue.Once all SQL statements are added, MySQL Transact can start a transaction, execute each statement and finishes the...

Simple and Speed MySQL Layer establishes a connection to a MySQL host, executes SQL queries and retrieves results as objects or in an array.

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.


Platforms: PHP

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

MySQL Object provides a few classes that execute several types of queries and extend the ArrayObject class to access the query results as if that was an array.Additional classes are used to traverse generic query result rows, traverse query result row columns, traverse the query result columns...


Platforms: PHP

A connection to a specified MySQL server is established and SQL queries are executed.Key Features of WG DB Class:- Retrieve query results into arrays- Retrieve the result set number of rows, last inserted identifier or the number of affected rows- Check if a database table record exists matching...


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

TextSQL can parse some types of SQL queries and translate the queries into actions to store and retrieve data from text files.CREATE TABLE, INSERT and SELECT SQL queries are supported.


Platforms: PHP

Connection to MySQL database servers can be established and SQL queries can be executed in Osiris Core.Key Features of Osiris Core:- Change the character set- Return query results in arrays, HTML tables, or XML documents- List, optimize, create and drop database tables- Generate HTML to edit data...


Platforms: PHP

This is a PHP script to execute database queries via an XML RPC interface. It reads XML data from a XML-RPC request, extracting from it the database user name, password and the query to execute.The script executes the requested query and returns the results as XML-RPC response.


Platforms: PHP

This is a PHP script to run database queries with PDO from preset parameters. It takes parameters that define tables, fields, values and conditions to run SELECT, UPDATE, INSERT and DELETE queries.The PDO extension is used to access any supported database.


Platforms: PHP

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.


Platforms: PHP

SQLaL is a PHP Abstraction Layer script which makes it is easy to access and run queries on a MySQL database. It is designed to simplify the use of MySQL databases.The PHP script can be used for connecting, accessing, querying and reading results from a MySQL database. SQLaL is a good tool for...


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

This script can execute MySQl queries build from parameters. It can establish connections to MySQL database servers using configuration loaded using a separate auxiliary script.The MySQL script can execute INSERT, UPDATE, DELETE, SELECT queries and stored procedure calls from parameters that...


Platforms: PHP

This class can be used to execute MySQL queries read from files.It can open a given text file and read its lines with SQL statements to be executed.


Platforms: PHP

Entire Class/Functions is a connection to a MySQL server can be established and SQL queries can be executed.Here are some key features of Entire Class/Functions:- Retrieve query results into single value variables or arrays- Execute queries to retrieve and display paginated listings


Platforms: PHP

DbProxy can be used to execute MySQL queries from SQL templates defined in XML files.The script can parse a given XML file that contains definitions of SQL query templates. DbProxy can execute given MySQL queries eventually replacing template parameters with given values.


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