class DataBase
{
public $message;
public $id;
public $username;
public $password;
public $coutry;
public $firstname;
public $lastname;
public $mail;
public $table;
public $column;
public $where_column;
public $where_data;
public $data_new;
public $db_host = "localhost";
public $db_name = "uscriptmaker";
public $db_user = "root";
public $db_pass = "";
public $users_columns = array('username','password','firstname','lastname','country','mail');
public $users_table = "users";
public $values;
function connect()
{
$connect = @mysql_connect($this->db_host,$this->db_user,$this->db_pass);
if($connect)
{
$select = @mysql_select_db($this->db_name);
if($select)
{
mysql_query("SET NAMES CP1251");
return true;
}
else return false;
}
else return false;
}
function trim($table,$column,$data_new,$where_column,$where_data)
{
$this->table = trim(stripslashes(htmlspecialchars($table)));
$this->data_new = trim(stripslashes(htmlspecialchars($data_new)));
$this->where_column = trim(stripslashes(htmlspecialchars($where_column)));
$this->column = trim(stripslashes(htmlspecialchars($column)));
$this->where_data = trim(stripslashes(htmlspecialchars($where_data)));
return true;
}
public function trimone($name)
{
if(is_array($name))
{
foreach($name as $value)
{
$name = implode(",",$name);
return $name;
}
}
else
{
return trim(stripslashes(htmlspecialchars($name)));
}
}
public function update($table,$column,$data_new,$where_column,$where_data)
{
$this->trim($table,$column,$data_new,$where_column,$where_data);
if($this->connect())
{
$sql = mysql_query("UPDATE $this->table SET $this->column = '".mysql_real_escape_string("$this->data_new")."' WHERE $this->where_column = '".mysql_real_escape_string("$this->where_data")."'");
if($sql)
{
$this->message = "Обновлено";
return true;
}
else
{
$this->message = "Ошибка";
return false;
}
}
}
public function valuestrim($name)
{
if(is_array($name))
{
foreach ($name as $val)
{
$name = implode(";",$name);
return $name;
}
}else print "Не массив";
}
public function insert($table,$column,$values)
{
$this->connect();
$table = $this->trimone($table);
$column = $this->trimone($column);
$values = $this->valuestrim($values);
print $values;
$sql = mysql_query("INSERT INTO $table($column) VALUES ('$values')");
if($sql)
{
$this->message = "Успех";
}
else
{
$this->message = "Нет";
}
}
}
Говнокласс, можно и так назвать.