fluentpdo
fluentpdo copied to clipboard
envms
A PHP SQL query builder using PDO
In function getResult() we have phpdoc with this tag: "@return \PDOStatement", but if query executed with errors, getResult() will return false instead of expected PDOStatement instance.
If there was error during query execution for example select of non existing coloumn, then calling of method getExecutionTime() will throw a fatal error: "Base::getExecutionTime() must be of the type...
I found a bug with insert or update records. Library use PDO `execute()` statement which all values are treated as PDO::PARAM_STR. https://php.net/manual/en/pdostatement.execute.php But if u use PostgreSQL database booleans [must...
I suggest to add to composer: "require": { "php": ">=7.1", [...] because I use 7.0 and question marks on method arguments is not accepted... Alberto
Currently each part of a query is stored in arrays. While efficient, it makes it very difficult to track where each part of a clause should go where, and if...
Hi, I'd like to ask if this kind of query is possible with this lib: ```sql UPDATE partneri_settings_voucher SET last_vs=last_vs+1 WHERE id_partner='abc' RETURNING last_vs ``` What to do with int...
Hello, i was wondering if fluentpdo will support LIMIT for SQLSRV not MySQL i doubt you don't know this but i will explain using queries MySQL: `select * from _table...
## Idea [PDOStatement::fetchAll](http://php.net/manual/en/pdostatement.fetchall.php) supports some different fetch styles: - return an array consisting of all values of a single column - fetch only the unique values of a single column...
Hello to everyone, I have a request. It is possible to add additional method like this `$query->replaceInto();` I don't find this in documentations. Thank You in Advance Stefano
Hi everyone, I have a query similar to this one > $query = $fpdo->from('views'); > $query = $query->select(NULL); > $query = $query->select('SUM(views.views) AS views, 0 AS clicks, 0 AS leads,...