Hydrahon
Hydrahon copied to clipboard
ClanCats
🐉 Fast & standalone PHP MySQL Query Builder library.
how would this consultation with the hydrahon be? SUM(+1) as matches, SUM(IF((matches.playerblue = '.$idPlayer.' AND matches.rtb > matches.rtr) OR (matches.playerred = '.$idPlayer.' AND matches.rtr > matches.rtb), 1, 0)) as victories,...
I would like to propose support for [the `having` clause](https://en.wikipedia.org/wiki/Having_(SQL)). I managed to pull out a working demo in [this fork of the repo](https://github.com/AeonFr/Hydrahon/commit/b5b6fc6bd6b354fc480d4d76b18f9a23c70df88f) but found some issues: 1. The...
This adds many validations for constructions that could generate invalid SQL. Empty table names are not accepted in mysql. This is also useful when using a name from a variable,...
Is there any possibility to build a query which uses a join with subselect, eg: ``` $t2 = $qb->table('table2')->select(array('t2.id')); $qb->table('table1 as t1')->select()->join(array('t2' =>$2)); ``` The code above would translate to:...
Hi, I belive there is a problem with the run() method implemented in Select.php. The function seems to be called from one-result helpers, and it should return the query result....
Just wanted to leave a note so you might either update your documentation or the method itself. When trying to return a count, if your `$statement->fetchAll` uses `PDO::FETCH_OBJ` instead of...
I recently have a issue with the first/last method of select, and i think that if these method was more explained i dont have problem and it will be clearer...
I was doing a charge system for my company. And i haved that verify if the client X already haved a charge created in the respectly YearMonth (YYYYMM). I did...