Mysql Done Right is a PHP 5.0+ class that provides a safe, clean, object-oriented, and efficient way to do database development. All queries except those with multiple row results return exactly what you need in one line of code. This is all done while still maintaining use of prepared queries and bound parameters to eliminate the risk of SQL injection attacks and operate more efficiently. No extra coding is needed on your part to reuse prepared queries. You simply write the same query again, and if you have used that one before, the prepared handle is reused. The newly bound parameters are used against the existing prepared handle, and the results are recomputed. The results themselves are not cached. Database connectivity is implemented using MySQLi.
The uFlex class can be used to manage registrations and authenticate users with records in a MySQL database. It can perform several types of operations with registered users of a site. Currently, it can create or update registered user records, activate user accounts, reset passwords, authenticate a user and start a login session, end a login session, and automatically login. As its name implies, the class is very flexible as you can add, modify, and validate any field in the registration and updating process.
Xyndravandria Dyverath composes and executes MySQL database queries programmatically. It represents a database system with PHP classes. Other classes are available to compose other parts of the queries like conditions, fields, values, limit clauses, etc. A separate class can also query database table metadata like table fields and primary keys.