2017 © Pedro Peláez
 

library fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

image

lichtner/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

  • Monday, July 23, 2018
  • by lichtner
  • Repository
  • 53 Watchers
  • 635 Stars
  • 109,381 Installations
  • PHP
  • 12 Dependents
  • 0 Suggesters
  • 158 Forks
  • 28 Open issues
  • 13 Versions
  • 3 % Grown

The README.md

FluentPDO Build Status Maintainability

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., (*1)

Features

  • Easy interface for creating robust queries
  • Supports any database compatible with PDO
  • Ability to build complex SELECT, INSERT, UPDATE & DELETE queries with little code
  • Type hinting for magic methods with code completion in smart IDEs

Versions

Version 2.x

The stable release of FluentPDO and actively maintained. Officially supports PHP 7.3 to PHP 8.0, but it can work with previous versions of PHP 7., (*2)

Version 1.x

The legacy release of FluentPDO. It is no longer supported and will not be maintained or updated. This version works with PHP 5.4 to 7.1., (*3)

Version 3.x - alpha

This version is a full rewrite of Fluent from the ground up. Its main advantage is significantly less memory usage and much greater performance in query building. It also places a few additional restrictions to make queries easier to read and maintain. Documentation has also been a very common request, and version 3 is being fully documented alongside development. Details and metrics will be posted once available., (*4)

Reference

Sitepoint - Getting Started with FluentPDO, (*5)

Installation

Composer

The preferred way to install FluentPDO is via composer., (*6)

Add the following line in your composer.json file:, (*7)

"require": {
    ...
    "envms/fluentpdo": "^2.2.0"
}

update your dependencies with composer update, and you're done!, (*8)

Download Zip

If you prefer not to use composer, download the latest release, create the directory Envms/FluentPDO in your library directory, and drop this repository into it. Finally, add:, (*9)

require '[lib-dir]/Envms/FluentPDO/src/Query.php';

to the top of your application. Note: You will need an autoloader to use FluentPDO without changing its source code., (*10)

Getting Started

Create a new PDO instance, and pass the instance to FluentPDO:, (*11)

$pdo = new PDO('mysql:dbname=fluentdb', 'user', 'password');
$fluent = new \Envms\FluentPDO\Query($pdo);

Then, creating queries is quick and easy:, (*12)

$query = $fluent->from('comment')
             ->where('article.published_at > ?', $date)
             ->orderBy('published_at DESC')
             ->limit(5);

which would build the query below:, (*13)

SELECT comment.*
FROM comment
LEFT JOIN article ON article.id = comment.article_id
WHERE article.published_at > ?
ORDER BY article.published_at DESC
LIMIT 5

To get data from the select, all we do is loop through the returned array:, (*14)

foreach ($query as $row) {
    echo "$row['title']\n";
}

Using the Smart Join Builder

Let's start with a traditional join, below:, (*15)

$query = $fluent->from('article')
             ->leftJoin('user ON user.id = article.user_id')
             ->select('user.name');

That's pretty verbose, and not very smart. If your tables use proper primary and foreign key names, you can shorten the above to:, (*16)

$query = $fluent->from('article')
             ->leftJoin('user')
             ->select('user.name');

That's better, but not ideal. However, it would be even easier to not write any joins:, (*17)

$query = $fluent->from('article')
             ->select('user.name');

Awesome, right? FluentPDO is able to build the join for you, by you prepending the foreign table name to the requested column., (*18)

All three snippets above will create the exact same query:, (*19)

SELECT article.*, user.name 
FROM article 
LEFT JOIN user ON user.id = article.user_id
Close your connection

Finally, it's always a good idea to free resources as soon as they are done with their duties:, (*20)

```php $fluent->close();, (*21)


## CRUD Query Examples

##### SELECT

```php
$query = $fluent->from('article')->where('id', 1)->fetch();
$query = $fluent->from('user', 1)->fetch(); // shorter version if selecting one row by primary key
INSERT
$values = array('title' => 'article 1', 'content' => 'content 1');

$query = $fluent->insertInto('article')->values($values)->execute();
$query = $fluent->insertInto('article', $values)->execute(); // shorter version
UPDATE
$set = array('published_at' => new FluentLiteral('NOW()'));

$query = $fluent->update('article')->set($set)->where('id', 1)->execute();
$query = $fluent->update('article', $set, 1)->execute(); // shorter version if updating one row by primary key
DELETE
$query = $fluent->deleteFrom('article')->where('id', 1)->execute();
$query = $fluent->deleteFrom('article', 1)->execute(); // shorter version if deleting one row by primary key

Note: INSERT, UPDATE and DELETE queries will only run after you call ->execute(), (*22)

License

Free for commercial and non-commercial use under the Apache 2.0 or GPL 2.0 licenses., (*23)

The Versions

23/07 2018

dev-2.0/unit-tests

dev-2.0/unit-tests https://github.com/envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

  Sources   Download

Apache-2.0 GPL-2.0+

The Development Requires

by envms

database query pdo dbal mysql db builder fluent oracle

27/04 2018

dev-legacy

dev-legacy https://github.com/envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

  Sources   Download

Apache-2.0 GPL-2.0+

by Marek Lichtner
by envms

database query pdo dbal mysql db builder fluent oracle

27/04 2018

v1.1.3

1.1.3.0 https://github.com/envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

  Sources   Download

Apache-2.0 GPL-2.0+

by envms

database query pdo dbal mysql db builder fluent oracle

05/12 2017

dev-master

9999999-dev https://github.com/envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

  Sources   Download

Apache-2.0 GPL-2.0+

The Development Requires

by Marek Lichtner
by envms

database query pdo dbal mysql db builder fluent oracle

22/11 2017

v2.0.0-alpha1

2.0.0.0-alpha1 https://github.com/envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

  Sources   Download

Apache-2.0 GPL-2.0+

The Development Requires

by envms

database query pdo dbal mysql db builder fluent oracle

22/11 2017

dev-2.0/lib-structure

dev-2.0/lib-structure https://github.com/envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

  Sources   Download

Apache-2.0 GPL-2.0+

The Development Requires

by envms

database query pdo dbal mysql db builder fluent oracle

13/10 2017

v1.1.2

1.1.2.0 https://github.com/envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

  Sources   Download

Apache-2.0 GPL-2.0+

by envms

database query pdo dbal mysql db builder fluent oracle

05/09 2017

v1.1.1

1.1.1.0 https://github.com/fpdo/fluentpdo

FluentPDO is small PHP library for rapid query building. Killer feature is smart join builder which generates joins automatically.

  Sources   Download

Apache-2.0 GPL-2.0+

by Marek Lichtner

database pdo dbal

01/07 2017

dev-feat/query-representation

dev-feat/query-representation https://github.com/fpdo/fluentpdo

FluentPDO is small PHP library for rapid query building. Killer feature is smart join builder which generates joins automatically.

  Sources   Download

Apache-2.0 GPL-2.0+

by Marek Lichtner

database pdo dbal

21/06 2017

dev-update/database-setup

dev-update/database-setup https://github.com/fpdo/fluentpdo

FluentPDO is small PHP library for rapid query building. Killer feature is smart join builder which generates joins automatically.

  Sources   Download

Apache-2.0 GPL-2.0+

by Marek Lichtner

database pdo dbal

11/07 2016

dev-fluent

dev-fluent https://github.com/fpdo/fluentpdo

FluentPDO is small PHP library for rapid query building. Killer feature is smart join builder which generates joins automatically.

  Sources   Download

Apache-2.0 GPL-2.0+

by Marek Lichtner

database pdo dbal

08/07 2016

v1.1.0

1.1.0.0 https://github.com/fpdo/fluentpdo

FluentPDO is small PHP library for rapid query building. Killer feature is smart join builder which generates joins automatically.

  Sources   Download

Apache-2.0 GPL-2.0+

by Marek Lichtner

database pdo dbal

24/02 2015

1.0.0

1.0.0.0 http://fluentpdo.com/

FluentPDO is small PHP library for rapid query building. Killer feature is smart join builder which generates joins automatically.

  Sources   Download

Apache-2.0 GPL-2.0+

by Marek Lichtner

database pdo dbal