need good sql library for php

Question

I need a library like Crystal Project I currently use Crystal, but it has bad join and table prefix support, and doesn't have a function for getting row-count, so I need to change to something with better support for these.

I don't need an ORM or abstraction library. I just need good mysql wrapper with chain method support eg:

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

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