Beste,
Ik heb een beetje een probleem. Ik heb de volgende class met een script. Maar wat is er fout. De login gegevens zijn goed. Waarom zegt hij dat. (Zie de documentatie > http://code.google.com/p/edb-php-class/)
De class + script:
De vervelende error:
Ik heb een beetje een probleem. Ik heb de volgende class met een script. Maar wat is er fout. De login gegevens zijn goed. Waarom zegt hij dat. (Zie de documentatie > http://code.google.com/p/edb-php-class/)
De class + script:
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/class"]class[/URL] Database [COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/private"]private[/URL] [COLOR= #0000BB]$connection[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$debug[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$line[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$one[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$queryAll[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]();[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$queryCount[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$queryTime[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$cacheDir[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]cache/database/[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #0000BB]$utf8Cache[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700];[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] __construct[COLOR= #007700]([/COLOR][COLOR= #0000BB]$host[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$user[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$pass[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$db[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$data[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$host[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700]))
{[/COLOR]
[COLOR= #0000BB]$host[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$user[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$pass[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$db[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]3[/COLOR][COLOR= #007700]];
}[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]connection [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$host[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$user[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$pass[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$db[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] q[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$t[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]30[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$cacheFile[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]cacheDir [COLOR= #007700].[/COLOR] [URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]) .[/COLOR][COLOR= #DD0000].cache[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/is_file"]is_file[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700]) && ([/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][URL="http://www.php.net/filemtime"]filemtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700]))<[/COLOR][COLOR= #0000BB]$t[/COLOR][COLOR= #007700]) {[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]res [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]getCache[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]);
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]res [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]();[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"$a"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]connection[COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700])){[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]res[COLOR= #007700][] =[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700];
}[/COLOR]
[COLOR= #0000BB]$end[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$c[/COLOR][COLOR= #007700]) {[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]setCache[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]res[COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]);
}[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]debugData[COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$end[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]res[COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] line[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$t[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]30[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$cacheFile[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]cacheDir [COLOR= #007700].[/COLOR] [URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]) .[/COLOR][COLOR= #DD0000].cache[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/is_file"]is_file[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700]) && ([/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][URL="http://www.php.net/filemtime"]filemtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700]))<[/COLOR][COLOR= #0000BB]$t[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]line [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]getCache[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]);
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"$a"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]connection[COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]line [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR] [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$end[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$c[/COLOR][COLOR= #007700]) {[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]setCache[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]line[COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]);
}[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]debugData[COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$end[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]line[COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] one[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$t[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]30[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$cacheFile[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]cacheDir [COLOR= #007700].[/COLOR] [URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]) .[/COLOR][COLOR= #DD0000].cache[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/is_file"]is_file[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700]) && ([/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][URL="http://www.php.net/filemtime"]filemtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700]))<[/COLOR][COLOR= #0000BB]$t[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]one [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]getCache[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR]false[COLOR= #007700]);
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"$a"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]connection[COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$r[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR] [COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$end[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]debugData[COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$end[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$i[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$b[/COLOR][COLOR= #007700])) {[/COLOR]
[COLOR= #0000BB]$i[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #0000BB]$b[/COLOR][COLOR= #007700];
}[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]one [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$r[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$c[/COLOR][COLOR= #007700]) {[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]setCache[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cacheFile[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]one[COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR]false[COLOR= #007700]);
}
}[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]one[COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] s[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"$a"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]connection[COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$end[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]debugData[COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$end[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$q[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/private"]private[/URL] [COLOR= #007700]function[/COLOR] setCache[COLOR= #007700]([/COLOR][COLOR= #0000BB]$file[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$q[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$o[/COLOR] [COLOR= #007700]=[/COLOR] true[COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$fh[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/fopen"]fopen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$file[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]w[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"cant open file"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$o[/COLOR][COLOR= #007700]) {[/COLOR]
[URL="http://www.php.net/fwrite"]fwrite[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fh[/COLOR][COLOR= #007700],[/COLOR] json_encode[COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]));
}[/COLOR] [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/fwrite"]fwrite[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fh[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$result[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/fclose"]fclose[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fh[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/private"]private[/URL] [COLOR= #007700]function[/COLOR] getCache[COLOR= #007700]([/COLOR][COLOR= #0000BB]$file[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$o[/COLOR] [COLOR= #007700]=[/COLOR] true[COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$fh[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/fopen"]fopen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$file[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]r[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$data[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/fread"]fread[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fh[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/filesize"]filesize[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$file[/COLOR][COLOR= #007700]));[/COLOR]
[URL="http://www.php.net/fclose"]fclose[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fh[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$o[/COLOR][COLOR= #007700]) {[/COLOR]
[COLOR= #0000BB]$data[/COLOR] [COLOR= #007700]= ([/COLOR][URL="http://www.php.net/array"]array[/URL][COLOR= #007700])[/COLOR]json_decode[COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700]);
}[/COLOR]
[COLOR= #0000BB]$end[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/microtime"]microtime[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]debugData[COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$end[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]cache[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/private"]private[/URL] [COLOR= #007700]function[/COLOR] debugData[COLOR= #007700]([/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$end[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$b[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]DB[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]queryCount[COLOR= #007700]++;[/COLOR]
[COLOR= #0000BB]$t[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/number_format"]number_format[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$end[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$start[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]8[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]queryTime [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]queryTime [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$t[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]queryAll[COLOR= #007700][[/COLOR] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]queryCount [COLOR= #007700]] =[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]query[/COLOR][COLOR= #007700]=>[/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]time[/COLOR][COLOR= #007700]=>[/COLOR][COLOR= #0000BB]$t[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]=>[/COLOR][COLOR= #0000BB]$b[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] selectAll[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$t[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]30[/COLOR][COLOR= #007700])[/COLOR] [COLOR= #FF8000]//select * from table[/COLOR]
[COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM `$a`"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]q[COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$c[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$t[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] insert[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$b[/COLOR][COLOR= #007700])[/COLOR] [COLOR= #FF8000]//insert data $db->insert($table,$data);[/COLOR]
[COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"INSERT INTO $a ("[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$b[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$c[/COLOR][COLOR= #007700]=>[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700]) {[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"`$c`,"[/COLOR][COLOR= #007700];
}[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]") values ("[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$b[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$c[/COLOR][COLOR= #007700]=>[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700]) {[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"$d,"[/COLOR][COLOR= #007700];
}[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]s[COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]);[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] update[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$b[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$c[/COLOR][COLOR= #007700])[/COLOR] [COLOR= #FF8000]//update row or rows, $db->update($tableName,$updateValues,$whereValues);[/COLOR]
[COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"UPDATE `$a` SET "[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$b[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$v[/COLOR][COLOR= #007700]=>[/COLOR][COLOR= #0000BB]$k[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]"`$v`=$k,"[/COLOR][COLOR= #007700];
}[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],-[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]" WHERE 1"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]as[/COLOR] [COLOR= #0000BB]$v[/COLOR][COLOR= #007700]=>[/COLOR][COLOR= #0000BB]$k[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]" AND `$v`=$k"[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]s[COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] countTable[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$t[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]30[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT COUNT(*) FROM `$a` LIMIT 1"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]one[COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$c[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$t[/COLOR][COLOR= #007700]);
}
function[/COLOR] countWhere[COLOR= #007700]([/COLOR][COLOR= #0000BB]$a[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$b[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$c[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$t[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]30[/COLOR][COLOR= #007700])
{[/COLOR]
[COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT COUNT(*) FROM `$a` WHERE $b LIMIT 1"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]one[COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$c[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$t[/COLOR][COLOR= #007700]);
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] lastID[COLOR= #007700]()[/COLOR] [COLOR= #FF8000]//get last inserted ID [/COLOR]
[COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_insert_id"]mysql_insert_id[/URL][COLOR= #007700]();
}[/COLOR]
[URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] __destruct[COLOR= #007700]()
{[/COLOR]
[URL="http://www.php.net/mysql_close"]mysql_close[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$this[/COLOR][COLOR= #007700]->[/COLOR]connection[COLOR= #007700]);
}
}[/COLOR]
[COLOR= #0000BB]$db_data[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]localhost[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]user[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]pass[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]database[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$db[/COLOR] [COLOR= #007700]= new[/COLOR] Database[COLOR= #007700]([/COLOR][COLOR= #0000BB]$db_data[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #FF8000]// This is the important part, here it connects to the database[/COLOR]
?> De vervelende error:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user db_name@localhost (using password: YES) in /home/allard/domains/---/public_html/api/includes/db.class.php on line 31
Access denied for user db_name@localhost (using password: YES)
Warning: mysql_close(): 10 is not a valid MySQL-Link resource in /home/allard/domains/---/public_html/api/includes/db.class.php on line 195
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/allard/domains/---/public_html/api/includes/db.class.php on line 195

