Top rated packages with tag query

Recommend this page to a friend!

			All class groups	>	Search tags: query

	1. Remote MySQL Query		query

Supplied by: Jeff Williams <e-mail contact>

Execute remote MySQL queries across the Web

Easily execute queries on a remote MySQL server using only HTTP.

It works by accessing a PHP script on the remote web server that executes queries based on passed in URL parameters.

The client passes a secret key to the remote script to prevent unauthorized access.

The remote script passes back the results to the requesting client using XML to marshal the data.

The class parses the results XML data returned by the server script and returns an array.

It, also, retrieves (into class variables) the number of records returned by the query and the time the query took to execute.

The server script may be used to execute MySQL queries that can be retrieved by programs written in other languages besides PHP.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Perfect (100.0%)`	`Good (95.8%)`	`Sufficient (70.8%)`	`Sufficient (75.0%)`	`-`	`-`	`Sufficient (74.2%)`	73
Month:	Not yet rated by the users

	2. baaGrid		query

Supplied by: Barry Andrew <e-mail contact>

Data grid to present database query results

This class is a versatile data grid class that is meant to present database query results. Also produces cross-tabs (pivot tables)

It supports displaying totals, subtotals, definining row and column styles and conditional cell highlighting.

It supports querying databases like MySQL, PostgreSQL and others via ODBC.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (89.8%)`	`Good (89.8%)`	`Good (87.5%)`	`Good (83.6%)`	`-`	`-`	`Sufficient (71.0%)`	159
Month:	Not yet rated by the users

	3. SQL Query Builder		query

Supplied by: David Regla Demaree <e-mail contact>

Dynamically build SQL queries

This class can be used to dynamically build SQL database queries.

It provides functions for defining query parameters such as the query type, tables, columns, the clauses where, order by, group by and having, limit row range.

The class builds the query SQL statement according the query type and returns the SQL string.

The documentation is available in Engligh and Spanish.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (77.3%)`	`Good (88.6%)`	`Good (84.1%)`	`Good (81.8%)`	`-`	`-`	`Sufficient (64.1%)`	508
Month:	Not yet rated by the users

	4. SQL fast query		query

Supplied by: Vincenzo <e-mail contact>

Execute MySQL queries composed programmatically

This class can be used to execute MySQL database queries composed programatically.

It provides functions to compose SELECT, INSERT, UPDATE and DELETE queries, as well to associate query condition clauses, define the query tables, fields and values.

The class can execute the composed queries and return result set resource handles.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Not sure (50.0%)`	`Not sure (56.2%)`	`-`	`Good (81.2%)`	`-`	`-`	`Insufficient (38.8%)`	2001
Month:	Not yet rated by the users

Copyright (c) Icontem 1999-2012	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products