PHP-PDO-MySQL-Class

PHP-PDO-MySQL-Class copied to clipboard

Integrity constraint violation: 1048 Column parentId cannot be null

citadelind2

1. buffered mode is used to read/write huge data. 2. Insert `schema.table` will show error exception.

jjasoncool

Hello

1

Please change this if ($statement === 'select' || $statement === 'show' || $statement === 'call' || $statement === 'describe') { $fetchReturn = $this->sQuery->fetchAll($fetchMode); $this->sQuery->closeCursor(); return $fetchReturn; } elseif ($statement ===...

tolgaakardeniz

I would suggest you add binding paramters in a more readable way. e.g ``` $db->bind('par1', 'xyz' ); $db->bind('par2', 'abc' ); $db->query('SELECT * FROM table1 WHERE table1.a = :par1 AND table1.b...

waakobrian

ORDER BY ASC DESC

1

How to do sorting ? ORDER BY ASC DESC

ghost

These small changes would be nice to add to the repo, so that the log path can be changed. PDO.class.php public function __construct($Host, $DBPort, $DBName, $DBUser, $DBPassword, $LogPath = '')...

bavamont

gabrielw18

How to turn off logs?

1

I want to turn off logs, as I don't really want to be accessing this from the front end of my website. How do I do this?

seojake

Statement Success Or Not

3

how can i determine query are success or not ? some like if ($execute = DB->query(blablabla)){} ?

dimaslanjaka

Using define to input database credentials and also making them public

2

``` ``` Why can't use ini file that puts credentials to main db function and link with main db php class, which won't require parameters to be required everytime. Just...

sachya