pixie

pixie copied to clipboard

How to close connection?

3

Can pixie close a connection? It's not in the documentation..

catchem99

pass array to where

6

instead of `$query->where("post_id" , 1)->where("category_id" , 2);` i would like to ``` $query->where([ "post_id" => 1, "category_id" => 2 ]); ``` Edit: i extendet the code by myself: src/Pixie/QueryBuilder/QueryBuilderHandler.php between...

jonasfrey

Prefix added to join aliases

1

When using a table prefix and join aliases, the prefix gets added to the aliases. I think this is a bug. This example code: ``` $dbConfig = array( 'driver' =>...

m-mohr

issue in count()

3

when i run this query every thing is ok : $stmt = $db->table('call_history') ->select('id') ->where('caller_id', $operator_id) ->groupBy('user_id') ->get(); // result is 5 record but run this query : $stmt =...

mromid

``` Fatal error: Uncaught PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'data' at row 1 in /home/***/public_html/app/app/vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/QueryBuilderHandler.php:152 Stack trace: #0 /home/***/public_html/app/app/vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/QueryBuilderHandler.php(152): PDOStatement->execute() #1 /home/***/public_html/app/app/vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/QueryBuilderHandler.php(325): Pixie\QueryBuilder\QueryBuilderHandler->statement('INSERT...

aboly

Select with special characters

2

Select query not working with special characters like( &,(), etc) in where clause.

Deepak-nb

Make it possible to send the query or extra data to the thrown event so it can be mutated. For example by adding a select column in all cases.

eL-Prova

-- wrong thread

jonasfrey

Postgres: Update has syntax error

1

Hi, I'm using postgresql and I just tried to use the pixie's update method like so: ``` QB::table('persons')->where('id', $id)->update(['name' => 'Jack']); ``` It is giving me a syntax error by...

James-A1

insertedid is not working

5

Inside readme in Insert section :- `$data = array( 'name' => 'Sana', 'description' => 'Blah' );` `$insertId = QB::table('my_table')->insert($data); echo $insertId ; ` Output: ""

billionri