117 lines
2.3 KiB
PHP
117 lines
2.3 KiB
PHP
<?php
|
|
class mysql
|
|
{
|
|
var $connection;
|
|
var $data;
|
|
|
|
function mysql($host, $user, $pwd, $database, $charset)
|
|
{
|
|
$this->connection = NULL;
|
|
$this->data = NULL;
|
|
|
|
$this->connection = mysql_connect($host, $user, $pwd) or $this->error("mysql_connect error");
|
|
mysql_select_db($database, $this->connection) or $this->error("mysql_select_db error");
|
|
mysql_set_charset($charset, $this->connection);
|
|
}
|
|
|
|
function restart($host, $user, $pwd, $database)
|
|
{
|
|
if ($this->data != NULL && $this->data != 1)
|
|
mysql_free_result($this->data);
|
|
|
|
if ($this->connection != NULL)
|
|
mysql_close($this->connection);
|
|
|
|
$this->connection = mysql_connect($host, $user, $pwd) or $this->error("mysql_connect error");
|
|
mysql_select_db($database, $this->connection) or $this->error("mysql_select_db error");
|
|
}
|
|
|
|
function fetch_row()
|
|
{
|
|
return mysql_fetch_row($this->data);
|
|
}
|
|
|
|
function fetch_array()
|
|
{
|
|
return mysql_fetch_array($this->data);
|
|
}
|
|
|
|
function result($row_num, $value_name)
|
|
{
|
|
return mysql_result($this->data, $row_num, $value_name);
|
|
}
|
|
|
|
function disconnect()
|
|
{
|
|
if ($this->connection != NULL)
|
|
{
|
|
mysql_close($this->connection);
|
|
$this->connection = NULL;
|
|
}
|
|
}
|
|
|
|
function num_rows()
|
|
{
|
|
return (mysql_num_rows($this->data));
|
|
}
|
|
|
|
function destroy()
|
|
{
|
|
if ($this->data != NULL && $this->data != 1)
|
|
mysql_free_result($this->data);
|
|
|
|
$this->disconnect();
|
|
}
|
|
|
|
function query($query_string)
|
|
{
|
|
if ($this->data != NULL)
|
|
{
|
|
if ($this->data != 1)
|
|
mysql_free_result($this->data);
|
|
|
|
$this->data = NULL;
|
|
}
|
|
|
|
$this->data = mysql_query($query_string, $this->connection) or $this->error("mysql_query error");
|
|
|
|
if ($this->data)
|
|
return TRUE;
|
|
else
|
|
return FALSE;
|
|
}
|
|
|
|
function query_nodie($query_string)
|
|
{
|
|
if ($this->data != NULL && $this->data != 1)
|
|
{
|
|
if ($this->data != 1)
|
|
mysql_free_result($this->data);
|
|
|
|
$this->data = NULL;
|
|
}
|
|
|
|
$this->data = mysql_query($query_string, $this->connection);
|
|
|
|
if ($this->data)
|
|
return TRUE;
|
|
else
|
|
return FALSE;
|
|
}
|
|
|
|
function error($header)
|
|
{
|
|
die($header.": ".mysql_error($this->connection));
|
|
}
|
|
|
|
function lock($rule)
|
|
{
|
|
$this->query("LOCK TABLES $rule") or $this->error("mysql LOCK TABLES error");
|
|
}
|
|
|
|
function unlock()
|
|
{
|
|
$this->query("UNLOCK TABLES") or $this->error("mysql UNLOCK TABLES error");
|
|
}
|
|
};
|