There are a few major differences in the new code:

1) The API has changed – for example instead of (while $obj = $db->Fetch()) from the old code, EasyPDO uses foreach ($db->Fetch() as $idx => $obj).
2) The new code does not support PHP’s MySQLi drivers – mainly because PDO/MySQL is quicker
3) EasyPDO supports more database engines, currently MySQL, PostGres and SQLite

If the old code is working for you, then there’s no need to change!

Please check out http://easypdo.robpoyntz.com – latest version which should have ironed out most of those issues.

Cheers,
RRP

It looks like there could well be a few problems in that code. If you can please bear with me for another day or so, I’m about to release a new version (and a new site to go with it). The current version is really just a private project, and that parts of the code I don’t use myself aren’t well tested. The new version will be fully tested, supported, and released under a sensible license.

Table `users`:

users_ID | Username | Created | LastModified

There are a few lines in the source code of your class that might be causing the problem. Namely, these lines of FetchRowAssoc:

if ($query = $this->MySQLi->prepare($sql))
throw new EDatabaseException($this->MySQLi->error);

Appear to be related to these lines in FetchRow:

if (!$query = $this->MySQLi->prepare($sql))
throw new EDatabaseException($this->MySQLi->error);

However, there is no not operator in the FetchRowAssoc implementation. Should there be? Also, in FetchRow:

if ($this->MySQLi->errno != 0) throw new EDatabaseException($this->MySQLi->error);

That line appears related to this line in FetchRowAssoc:

if ($this->errno != 0) throw new EDatabaseException($this->error);

But in the FetchRowAssoc version, $this->[property] is used instead of $this->MySQLi->[property].

I changed those two things in FetchRowAssoc and everything worked up to these lines where it failed:

if (!call_user_func_array(array($this->Query, ‘bind_result’), $bindparams))
throw new EDatabaseException(‘Bind parameters failed’);

It was either those lines, or the other two lines that binded parameters.

This seems to be failing on the MySQLi->prepare($sql) line – prepare sends your query to the database engine for compilation, so if an error is occurring here it’s likely that your SQL statement is invalid. What is the error code that’s being reported?

If you can send me the SQL, table definition and parameters you’re using, I might be able to spot the problem.

Fatal error: Uncaught exception ‘EDatabaseException’ in Path\to\dbconnect.php:383 Stack trace: #0 Path\to\file.php(line#): DF_MySQLi->FetchRowAssoc(‘SELECT * FROM u…’) #1 {main} thrown in Path\to\dbconnect.php on line 383

New version coming soon that addresses this issue and others. Will keep you posted.