Queries

Connections to a MySQL host can be established and SQL queries can be executed with Database Abstraction Class.Key Features of Database Abstraction Class:- Retrieve results into objects and array- Retrieve the length of the column fields- Retrieve the number rows affected by a query- Determine...

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.

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

Simple db class is able to execute arbitrary SQL queries.Key Features of Simple db class:- Connect to a MySQL database server host- Execute INSERT, UPDATE and DELETE queries passing only the table name and the values of the fields, values and conditions


Platforms: PHP

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

A connection to a MySQL database can be established and SQL INSERT, UPDATE, DELETE and DESCRIBE queries can be executed from parameters that specify the tables, fields and values to use.http://www.downloadplex.com/index.php?a=admin&b=programs&os=Scripts&add


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

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


Platforms: PHP

DABAJAX Toolkit can execute SQL queries to an Oracle database to complete text typed in form fields using parameters passed by javascript code to PHP scripts using AJAX requests.Parameters from different form fields defining filters for the data to be queried, can be passed to the queries.


Platforms: PHP

The PDO API is used to connect to the SQLite database and execute SQL queries. The data may be outputted formatted an an HTML table, a XML document or as a series of URL-encoded values.


Platforms: PHP

gsmysql can compose and execute several types of SQL queries to a MySQL database table given a list of parameters. Currently gsmysql can compose and execute SQL queries for SELECT, INSERT, UPDATE and DELETE.HTML form GET values can also be generated to insert or update the records of the...


Platforms: PHP

my_mysql connects to a MySQL database and can execute SQL queries. The query result sets are traversed and their values get displayed in cells of HTML tables, with optional columns to edit or delete the respective table records.


Platforms: PHP

IdealMySQL Class, a connection can be established to a MySQL server and SQL queries can be executed.Key Features of IdealMySQL Class:- Return the affected rows for manipulation queries like INSERT, DELETE. UPDATE, REPLACE and DROP- Return query result set handles for data retrieval queries like...


Platforms: PHP

INSERT, UPDATE and DELETE SQL queries can be performed on a specified MySQL table using lists of parameters to define the fields, values and conditions to be applied.


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

Mysql DBObj is meant to simplify the composition and execution of MySQL database SELECT queries.Mysql DBObj has functions that can establish the database connection and others to specify the query conditions, columns to sort the results, result row limits and execute the queries.


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

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

Database connections can be established and SQL queries can be executed. Currently GV Conection Class only supports MySQL but it is meant to support other database types in the future.


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