need good sql library for php

Question

hello, SO

need library like crystal (crystal-project.net). at this time i use crystal, but this library not really for me at the moment (bad join and table prefix support, don't have function for get rows count).

i don't need in ORM or abstraction library. i just need good mysql wrapper with chain method support

(->order_by('-id')->limit(($page - 1) * 20, 20)->print_sql();)

edit: please sorry my english

Answer 1

Right, I wouldn't use Crystal yet. The author has a long way to go before he develops a useful database library.

You seem to have some likes and dislikes for the API, but you haven't described what they are. So I'll just give a list of database interfaces for PHP and you can go check them out to see if they are to your liking:

• CoughPHP
• Doctrine
• Outlet
• Pork.dbObject
• Propel
• Redbean
• Repose

Also several general web app frameworks provide some kind of database access layer:

• Axon (part of Fat-Free framework)
• Flourish
• Kohana
• Prado
• Solar
• Zend Framework