|Classes of Dimitri Sitchet||>||dframework||>||system/dependencies/envms/fluentpdo/readme.md||>||Download|
FluentPDO is a PHP SQL query builder using PDO. It's a quick and light library featuring a smart join builder, which automatically creates table joins for you.
The latest (2.x) release of FluentPDO officially supports PHP 7.1, 7.2 and 7.3. v2.x is actively maintained.
The legacy (1.x) release of FluentPDO works with PHP 5.4 to 7.1. Note: v1.x is no longer supported and will not be maintained or updated.
The preferred way to install FluentPDO is via composer. Version 2.0 is now released! Please start using 2.x in your projects and let us know of any issues you find, they will be resolved quickly.
Add the following line in your
update your dependencies with
If you prefer not to use composer, create the directory
to the top of your application. Note: You will need an autoloader to use FluentPDO without changing its source code.
Create a new PDO instance, and pass the instance to FluentPDO:
Then, creating queries is quick and easy:
which would build the query below:
To get data from the select, all we do is loop through the returned array:
Using the Smart Join Builder
Let's start with a traditional join, below:
That's pretty verbose, and not very smart. If your tables use proper primary and foreign key names, you can shorten the above to:
That's better, but not ideal. However, it would be even easier to not write any joins:
Awesome, right? FluentPDO is able to build the join for you, by you prepending the foreign table name to the requested column.
All three snippets above will create the exact same query:
Close your connection
Finally, it's always a good idea to free resources as soon as they are done with their duties:
CRUD Query Examples
*Note: INSERT, UPDATE and DELETE queries will only run after you call
Full documentation can be found on the FluentPDO homepage