<?php
$db[host] = "**********"; //This is the MySQL server paFileDB will connect to
$db[user] = "**********"; //This is the MySQL user name
$db[pass] = "**********"; //This is the MySQL password
$db[name] = "**********"; //This is the MySQL database paFileDB will put it's information in
$db[prefix] = "pafiledb"; //Table name prefix-explained above.
class pafiledb_sql {
function query($db,$query,$type) {
$result = mysql_query($query);
$error = mysql_error();
global $query_count;
global $queries_used;
$query_count++;
$queries_used .= "<tr><td width=\"100%\" align=\"left\" class=\"datacell\">$query</td></tr>";
if (!empty($error)) {
$errno = mysql_errno();
$this->error("paFileDB was unable to successfully run a MySQL query.<br>MySQL Returned this error: <b>$error</b> Error number: <b>$errno</b><br>The query that caused this error was: <b>$query</b>");
}
if ($type == 0) {
return $result;
}
if ($type == 1) {
$array = mysql_fetch_array($result);
return $array;
}
if ($type == 2) {
$array = mysql_num_rows($result);
return $array;
}
if ($type == 3) {
$array = mysql_insert_id();
return $array;
}
@mysql_free_result($result);
}
function error($error) {
die($error);
}
function connect($db) {
if(!($dbc = mysql_connect($db[host],$db[user],$db[pass]))) $this->error("paFileDB was unable to successfully connect to the MySQL database. Check your settings including the MySQL server, username, and password and try again.");
if(!(mysql_select_db($db[name],$dbc))) $this->error("paFileDB was able to connect to the MySQL database, but was unable to select the database <b>$db[name]</b> to use.");
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET 'latin5'");
mysql_query("SET COLLATION_CONNECTION = 'latin5_bin'");
}
}
$pafiledb_sql = new pafiledb_sql;
?>bu şimdiki verdigi hata :
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=3' at line 26
</div>