fluentpdo
fluentpdo copied to clipboard
envms
A PHP SQL query builder using PDO
Hi! If i try get count() for my query with offset, i get wrong result 0. i can fix bug: `$tx->select('COUNT(*)', true)->offset(0)->fetchColumn()` If this solution fine - can you add...
hello all, i want to get the complete data between two (three) tables. but I get a flawed statement. I do not know where the problem lies. Database structure: TBL_User...
Hi is it possible to do a laravel style with? `$query->from("table1")->with("table2");` which would result in: `array( "table1.name"=> "some value", "table1.table2"=> array( array( "table2.stock"=>20, "table2.price"=>100.00, ), array( "table2.stock"=>20, "table2.price"=>100.00, ) )`
I have array with 5,000 new lines to insert into table. Can i insert them all in one query? I know how to do it on mysql query, there is...
Try something like this: ` $query->leftJoin('order_geo ON (order_geo.order_id = order_visit.id AND order_geo.order_type = :order_type)', [':order_type'=>'visit']); ` and you will get error: `PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined...
I am getting a 404 on this link: http://envms.github.io/fluentpdo/ Is it temporarily down, or permanently deleted? This link was found in the main readme doc for fluentpdo.
Hey there, I have the following code: ``` $regions = []; $query = $query->where('fs.bezirk_id', $regions); ``` which is effectively a noop whereby I would expect the query to always return...
http://envms.github.io/fluentpdo/ Returns 404. 
The column loop try to access nonexistent column, other driver like MySQL return false, but SQLite driver has a different behavior and throws a ```PDOException``` when ```$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);``` is set....
when i bulk insert instead of returning the affected rows it returns 0. which kinds of confusing.
