Top rated packages with tag mysql query

Recommend this page to a friend!

			All class groups	>	Search tags: mysql query

	1. Remote MySQL Query		mysql 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. Ultimate MySQL		mysql query

Supplied by: Jeff Williams <e-mail contact>

MySQL database access wrapper

This class is the ultimate MySQL database access wrapper.

It can:

- Establish MySQL server connections
- Execute SQL queries
- Query a single value or a single row
- Retrieve query results into arrays or resource objects
- Retrieve the last inserted ID
- Manage transactions (transaction processing)
- Retrieve the list tables of a database
- Retrieve the list fields of a table
- Retrieve the length or position of a field
- Measure the time a query takes to execute
- Display query results in an HTML table
- Format SQL parameters (safe against SQL injection hacks)
- Generate SQL
- Handle errors (optional Exception handling)
- Convert records into XML or JSON
- And MUCH more

All these feature while still blazing fast and low on memory and resources!

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (92.6%)`	`Good (91.0%)`	`Good (87.7%)`	`Good (86.9%)`	`-`	`-`	`Sufficient (72.9%)`	106
Month:	There are not enough user ratings to display for this class.

	3. baaGrid		mysql 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

	4. SQL fast query		mysql 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