adambinnersley / pdo-dbal Goto Github PK

Since setLogLocation() is available only after initialization, connection error in constructor falls back to the default log location.

Unlike in other methods, writeQueryToLog() is not called.

Log location is not valid and allow ability to change log location

Hey,

Super cool package - I've enjoyed using it. After upgrading PHP to 7.4 (skipping 7.3) most of my requests now gives the following warning:

Notice: Trying to access array offset on value of type int in /usr/www/users/webinstance/cmp/vendor/adamb/database/src/Database.php on line 560

It does not seem that functionality is affected.

Best,
Albert

If an error happens and displayErrors is off - execution goes on.
It must stop independently from displayErrors setting.

I am trying to write a project using pdo-dbal, however when I make more than one query in a call using the MemcacheCache wrapper I am getting persistence in the values class variable.

See below. The first entry is the first query on the page, the second query is the next. The second query still contains the first query's values despite not being passed in. The second image shows the second query's dbal call.

I tried changing the first call's synonymous column of id to lobbyID thinking it was being cached that way, but this did not fix anything.

I can fix this by making values public, and setting it to [] just like what \DBAL\Database\executeQuery() tries to do, but somehow fails in doing so; I can also fix it by clearing values as the first action in \DBAL\Database\select(), see below.

I tried removing the unset() calls, and I tried moving values = [] to right after the bind, but neither of those solved the issue, only clearing values from outside the class.

If I could get xdebug working I could try to narrow it down further, but I guess that isn't happening.

Can you provide documentation for the following implementation:

1. SELECT * FROM table_name WHERE field_name1 = value1 AND/OR ( field_name2 = value2 AND/OR field_name3 = value3).
2. JOIN using in SELECT

Thank you in advance!

Look to support all of the operators avaliable or streamline current system in the where queries. e.g. BETWEEN, NOT BETWEEN, IN, NOT IN, LIKE, NOT LIKE, etc...

Short array syntax has been added in 5.4

Can you provide documentation for the following implementation:

SELECT * FROM table_name WHERE field_name IN (values)

I tried using the following but its not working:

$dbInstance->selectAll( 'table_name', [ 'field_name ' => [ 'IN' => [ 'value1', 'value2' ] ] ] );

The returned SQL is:

SELECT * FROM table_nameWHEREfield_name %s ?;

Which is using the format from the IN operator but not really what I'm looking for.

Should I be using a different call or $where array structure?