Mysql Select Syntax

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

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

PhpReportGenerator is a PHP class that generates customizable HTML reports with data from the result set of any MySQL SELECT query.You need to just pass the query and a MySQL database connection resource id, customize several look and feel aspects of your report like text color, header color,...


Platforms: PHP

Databrid is a Database tool for Oracle and/or MySql databases that is suited to all levels of users. Databrids core functionality is based around a main set of tabs that allow access to the following areas: SQL Editor, Database Browser, File Processing, Active/Inactive Jobs and Help. The...


Platforms: Windows, Mac, *nix, Java,Other

MySQL Global User Variables UDF is a MySQL extension to store persistent variables. This shared library adds simple user functions to MySQL in order to keep persistent shared variables in memory. These variables and their values are available to all clients. Any data can be stored into these...


Platforms: *nix

SplitPageResult is a class for splitting Interbase/Firebird/non MySQL database query results in multiple pages. As you may know, with the 'LIMIT' clause supported in MySQL SQL syntax, it is easy to paginate data. Since other databases do not support this clause, it is difficult to split large...


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

CSLH- Crafty Syntax Live Help is a free and live PHP customer support system for your website based on MySQL. It features for the ability to create your own questions, auto inviting visitors, referer tracking, page tracking, ability to view what the customer is typing as they type, multiple chat...


Platforms: PHP

MySQL DB Handler can be used to establish a connection to a MySQL server and execute MySQL database queries. This script executes queries like INSERT, SELECT, UPDATE and DELETE. It can log the database access errors to a file.


Platforms: PHP

MySQL-Formmaker is a tool for creating easy administration forms and output of data.MySQL-Formmaker creates MySQL database, admin, and output files on the fly after you defined your forms, types of input, order, and so on. Ideal tool to create small dynamic sites with a backend to control your...


Platforms: PHP

SQL SELECT queries can be executed and the fields of each result set row can be retrieved into class variables.Object based MySQL can also insert or update records of a table getting the values from class variables with the same name as the fields.


Platforms: PHP

The base calls establishes MySQL database connections, sanitizes values used in SQL queries, executes SQL queries, retrieves SELECT query results into arrays and retrieves the last inserted identifier.There is also a sub-class that can retrieve the list of fields of a table, compose and execute...


Platforms: PHP

KG MySQL Class can connect to a specified MySQL server and select the database to access.Key Features of KG MySQL Class:- Execute SQL queries eventually returning the last inserted record identifier- Retrieve query results into objects or whole result sets into array


Platforms: PHP

class mysql is a wrapper to access MySQL databases.class mysql provides functions for opening and closing connections to a MySQL server, list databases, tables and table fields, execute SQL insert, update delete and select queries and retrieve the result set data into arrays, dump database data...


Platforms: PHP

coMySQLClass is a MySQL database access wrapper.Functions of coMySQLClass:- Establish database connections to a given host and database name- Execute SQL queries- Retrieve query results into associative arrays- Compose and execute SELECT, UPDATE and INSERT queries to a given table from lists of...


Platforms: PHP

This PHP class is a mySQL database access wrapper. PHP mySQL Database Wrapper Class provides methods for interracting with a mySQL database from within PHP easily and securely.Features of PHP mySQL Database Wrapper Class:- connecting to a mySQL host and selecting a database- method that is an...


Platforms: PHP

MySQL stored procedures emulates stored procedures for MySQL databases used (MySQL) client side files to define the SQL code of the procedures. It executes simple queries defined within a named block, known as "stored procedure".The query syntax within a stored procedure is compliant with...


Platforms: PHP

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

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

Simple MySQL dump can be used to dump a MySQL database as a list of SQL statements. It can retrieve the database tables metadata and execute and SQL SELECT query to retrieve all the data of the tables to be dumped.Simple MySQL dump returns a string with the table creation and record insertion...


Platforms: PHP