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

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!

Thread Thread
 
hariharanumapathi profile image
Hariharan

@darkain would you like to share your beast brother?

Thread Thread
 
darkain profile image
Vincent Milum Jr

You can find it here: pudl.dev/