fluentpdo
fluentpdo copied to clipboard
envms
A PHP SQL query builder using PDO
Hi, I am taking over an old code base that needs updating. They were still using FluentPDO v.1.0.0. After updating to latest (2.2.1) I notice that all the aliases on...
Hi This code worked in version 1 of fluentpdo - however after upgrading to vs 2.x it now seems I cannot add params to select methods - is there a...
Hi, I'm using FluentPDO, and I haven't found anywhere how to sum a value in an update query Like: ```sql UPDATE `users` SET `balance` = `balance` + 100 WHERE `id`...
Because SelectQuery::fetch() and its brethren call PDO::fetch() this way ``` $this->execute()->fetch(); ``` any time execute() fails and returns false instead of an object, the PHP script terminates with a fatal...
Is it possible to create a paging function in a query with FluentPDO today? For example: 
> PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens `INSERT INTO track (filename, artist, title, track_length, filesize, status, owner_user_id, play_vote, con_vote, date_added, date_last_played,...
I'm not able to use PDO::FETCH_COLUMN like fetchAll in PDO. It's used to return results in a single dimensional array instead of bi-dimensional array. It's possible to use this? ```...
Hello everyone, it is possible to get the query string from > ->getQuery() > SELECT tbl.* FROM tbl WHERE email = ? AND password = ? and parameters in the...
When i use this line: `$this->_db->from($this->getTable(), $id)->fetch()` $id is the value of "primaryKey" column, the default is 'id', by: lichtner\fluentpdo\src\Structure.php line 22 (Structure constructor). This constructor activate when i set...
Hi How do I get errors? errorInfo() `$query = $fluent->insertInto('article')->values($values)->execute();`
