PHP-DB

PHP-DB copied to clipboard

Parameter in SELECT or JOIN

1

I know this isn't ideal, but I have a query where it basically is joining up a lookup table and the `$child_pk` var could be any number of a few...

andrewteg

Example of IN statement

4

Hi, I have the following statement: ``` $result = $this->db->exec( " SELECT userImage FROM candid WHERE id = ? AND status IN ? ", [ $userid, $status ] ); ```...

aggarwaldev

Feature request, fetching as a class

2

It would be pretty helpful if the PDO Object is accessible or protected (instead of private) and/or your Class wouldn't overwrite PDO_DEFAULT_FETCH_MODE or expose the $stmt from the select functions,...

Stonebubble

Logging user activity in db

1

It would be nice if this lib provided a way to log user activity. I mean, this should be configured when install, and with every successful db actions it should...

vulantro

Provide access to underlying PDO

4

The $app->db() method provided by foundation-core is very convenient to create a db instance from a dotenv configuration file. However, when you need to do something with the db connection...

bfinlay

FETCH_KEY_PAIR / FETCH_UNIQUE / FETCH_GROUP fetch modes

2

In writing framework benchmark, one of the test cases required data that would have been more conveniently fetched using the FETCH_KEY_PAIR mode. I worked around it by using array_column. It...

bfinlay

how to keep connection Presistent?

8

I would like to keep connection Persistent is that possible using your library? ``` $opts = array( PDO::ATTR_PERSISTENT => true, // use existing connection if exists, otherwise try to connect...

AdamSEY

Adding increment and decrement methods

2

While working with NodeJS I found some super popular package called knex.js using increment and decrement methods and thought about adding them to this great library

AdamSEY

using "while" statement while "selecting"

4

I guess using "while" statement while "Selecting" is not possible right? Using "while" statement while "Selecting" much better for performance. Because storing the data in a variable then looping to...

AdamSEY