I'm currently testing your class and it looks good however.
Immediately after starting using it two errors showed up:
<b>Warning</b>: The magic method __call() must have public visibility and cannot be static in <b>C:\xampp\htdocs\energyroms\admin\classes\mysql.class.php</b> on line <b>81</b><br />
<b>Warning</b>: The magic method __get() must have public visibility and cannot be static in <b>C:\xampp\htdocs\energyroms\admin\classes\mysql.class.php</b> on line <b>119</b><br />
Also whenever I try parameters in a query, it fails.
For example I have a query that goes like this:
$Username = $_POST['UserName'];
$EncryptedPassword = doubleSalt($Password, $Username);
$aRes = $dbLink->query('SELECT UserID,UserGroup FROM users WHERE UserName = ? AND UserPassword = ?',$Username,$EncryptedPassword);
I always get the error:
[query_number] => 1
[query] => SELECT UserID,UserGroup FROM users WHERE UserName = ? AND UserPassword = ?
[errno] => 0
[type] => fatal
[error] => [ERROR] Failed to bind. Do you have equal parameters for all the '?'?
Now, I made sure that $Username and $EncryptedPassword both actually contain something so...
Is this class broken on my version of php? (PHP Version 5.3.1, using Xampp)
Camilo Sperberg - 2010-04-06 15:58:11 - In reply to message 2 from Camilo Sperberg
Some news: just installed PHP 5.3.2 on a linux box and no errors showed up with the queries, so this is a Windows specific bug. I remember I tried messing up with the configuration, with the class itself and with Apache / MySQL configuration, but nothing helped except not parametrizing the queries.
If you have found the solution, please post it so it can be included in the next version, I don't develop on Windows and the only time I worked on Windows I couldn't get used to it and changed back to Linux after 5 days.