eftec / pdoone Goto Github PK

Hello, i just started to use this library, and i have a problem.
I need to add prefix to every table in QueryBuilder.
I editing $prefixBase, but it's not working.
in your documentation $prefixBase defined as non-static var, but it's not it.
How i can add prefix to every table?

First off, what a great and I argue under-utilized PDO class. I love the simplicity and chaining of the functions for very clean to write and read statements.

However, I'm running into a wall. I see it defaults to PDO::FETCH_ASSOC, but is there a way to expand this to all available PDO modes? I cannot pass a string because it's cast as an integer, which likewise passes this value to rungen().

I wouldn't say this is a bug, but more of a feature request, since PDO::FETCH_ASSOC seems to be the only method I can pull from. I enjoy using PDO::FETCH_OBJ, PDO::FETCH_KEY_PAIR, etc.

Lastly, I notice some issues with some of my statements when I assign my query a value, but when it ends with toList(), the query won't run and says there is syntax error, even without passing a specified $pdoMode, to the method.

Also, is there any why when assigning the result for it to not include all extraneous elements of the entire $pdoOne object (just the resultant query: array, obj, key_pair, etc.)?

Anyways, great work and I appreciate all the work you've put into this class. Simple, optimized, effective and much less code to ultimately write.

Code:
$db->from('users')->where('created_at > ?', date('Y-m-d'))->count();
Always shows 1
Although in the database the user's created_at value is 2024-12-03 00:00:00
var_dump($db->lastQuery); and var_dump($db->lastParam); shows:

string(48) "select count(*)  from users where created_at > ?"
NULL

I checked and where really doesn't work with dates

Hey there! Nice work with your library ;) I was wondering if you could elaborate a bit on the encryption options and / or usage modes available (if there is already a documentation on it available, I would appreciate it as I could not find it on my own)

Hi, trying to install manually, and getting error missing MessageContainer class, which couldn't find in the repository.

https://github.com/EFTEC/PdoOne/blob/master/lib/PdoOne.php#L216

Thank you!