Top rated packages with tag mysqli

Recommend this page to a friend!

			All class groups	>	Search tags: mysqli

	1. MySQLi Database		mysqli

Supplied by: Costin Bereveanu <e-mail contact>

MySQL database wrapper using MySQLi extension

This package is a wrapper around the MySQLi extension to access MySQL databases.

The package is composed of two classes: one extends the MySQLi class to execute several types of database access functions and another extends the mysqli_result class to manipulate result sets.

It features:

- Optional exception throwing on connection or query errors
- All the result fetching functions use the fetch_object function. Support for retrieving results in associative arrays can be implemented later
- Perform several types querying and retrieval of results: query, query_all (fetches all rows), query_one (fetches only the first row), query_value (fetches only the first field and casts it to desired type)
- Retrieve the number of rows affected by the query, that can be used if you just want to know if a certain record exists
- Paginated queries (query_page, query_page_all, query_page_one) to retrieve only a given page of results
- Return the total number of rows in a paginated query (not only that on the current page)
- Support a complete set of MySQL error codes and data type constants
- Provides a function to compare the last error to a constant code
- Automaticaly cast the query results to given data type equivalent to database data types
- Altered mysqli constructor to accept a flexible connection string that can be used with database abstraction layers
- PHPDoc documentation

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (82.1%)`	`Sufficient (78.6%)`	`Sufficient (71.4%)`	`-`	`-`	`-`	`Not sure (56.1%)`	1071
Month:	Not yet rated by the users

	2. MySQLi access		mysqli

Supplied by: Julie Duvillier <e-mail contact>

MySQL database access using MySQLi

This package can be used to access MySQL databases using MySQLi.

The main class extends the MySQLi class : establish connection, execute SELECT, INSERT, UPDATE and DELETE queries from lists of parameters and get the fields of a table.
Exceptions of the class are handled by MySQLi_exception_class which extends the class Exception.

Other auxiliary classes deal with query results and prepare query statements.

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (75.0%)`	`Good (83.3%)`	`-`	`Good (83.3%)`	`-`	`-`	`Not sure (54.2%)`	1206
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