DEV Community

Discussion on: Create a Query Builder with PHP and SQL

Collapse
darkain profile image
Vincent Milum Jr

If you're interested in something a little more feature complete, I'd suggest checking out PUDL (PHP Universal Database Library). It contains connection manager (including clustering support), SQL query generation, data transformation, and tons more. It also has data sanitization built in, and works with countless databases engines (MySQL, MariaDB, SQL Server, PostgreSQL, and several more)

github.com/darkain/pudl

Collapse
daepher profile image
Daepher Author

That's a nice project! I decided to create my Query Builder as small as possible, but I didn't cover all the features in this post.

Collapse
darkain profile image
Vincent Milum Jr

My goal when I built mine too was to create something "as small as possible", but over the course of a decade, needs continued to grow! hahahaaaa When it first started, it was a simple single file with just a couple of helper functions, no classes. Now its a beast that can handle tons of stuff!