Advanced Sql Queries

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.

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.

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

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

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


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

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

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

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

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

Miester Search class indexes multiple tables, builds dictionaries, creates btree indexes, and creates sql queries based on user input.


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