Since it's really not all that big, figured I'd post the code here:
<?php
class MySQL
{
var $mysql_query_result;
var $mysql_query_is_doing;
var $mysql_error_number;
var $mysql_error_desc;
var $mysql_get_sql_query;
var $linkID;
function DB_Connect()
{
if (!@$this->linkID = mysql_pconnect(_HOST, _USER, _PASS))
{
die('<center><strong><font color="#FF0000">Cannot connect to the MySQL server: ' .
mysql_error() . '</font></center></strong>');
} else
{
if (!mysql_select_db(_DBNAME))
{
die('<center><strong><font color="#FF0000">Cannot select the "' .
_DBNAME .
'" Databse. Please make sure that.</font></center></strong>');
}
}
if (strlen(_DB_SET_CHARS) >= 1)
{
$s1 = @mysql_query("SET character_set_client = " . _DB_CHARS_TYPE);
$s2 = @mysql_query("SET character_set_connection = " . _DB_CHARS_TYPE);
$s3 = @mysql_query("SET character_set_database = " . _DB_CHARS_TYPE);
$s4 = @mysql_query("SET character_set_results = " . _DB_CHARS_TYPE);
$s5 = @mysql_query("SET character_set_server = " . _DB_CHARS_TYPE);
}
}
// mysql_query()
function do_query($sql_query)
{
$this->mysql_get_sql_query = $sql_query;
$this->mysql_query_result = @mysql_query($sql_query);
$do_query = array('INSERT', 'UPDATE', 'DELETE');
if (mysql_affected_rows())
{
$this->mysql_query_is_doing = 1;
} else
{
$this->mysql_query_is_doing = 0;
}
$this->mysql_error_number = mysql_errno();
$this->mysql_error_desc = mysql_error();
}
// mysql_fetch_array()
function get_rows_array()
{
return @mysql_fetch_array($this->mysql_query_result);
}
// mysql_fetch_assoc()
function get_rows_names()
{
return @mysql_fetch_assoc($this->mysql_query_result);
}
// mysql_fetch_object()
function get_rows_object()
{
return @mysql_fetch_object($this->mysql_query_result);
}
// mysql_result()
function get_result($row, $field)
{
return @mysql_result($this->mysql_query_result, $row, $field);
}
// Table Optimization
function table_optimize($table_name)
{
$this->do_query('OPTIMIZE TABLE ' . $table_name);
}
function db_optimize()
{
$this->do_query('SHOW TABLES FROM ' . _DBNAME);
while ($table_no = $this->get_rows_array())
{
$this->do_query('OPTIMIZE TABLE ' . $table_no[0]);
while ($get_result = $this->get_rows_names())
{
if ($get_result['msg_type'] != 'error')
{
echo 'Table Name: ' . $get_result['Table'] . '<br />';
echo 'Stauts Is: <font color="green">' . $get_result['Op'] .
'</font><br />';
echo $get_result['Msg_text'] . '<br />';
echo '<hr />';
} else
{
echo 'Cannot optimize the ' . $get_result['Table'] .
' Table!<br />';
echo 'Error is: ' . $get_result['Msg_text'];
}
} // while
} // while
}
function get_num_rows()
{
if (@mysql_num_rows($this->mysql_query_result))
{
return @mysql_num_rows($this->mysql_query_result);
} else
{
//echo $this->mysql_get_sql_query;
//echo $this->sql_error();
}
}
function sql_error($header = 0)
{
global $style_full_path;
if ($header == 1)
{
echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="' . _LANG_HTML_DIR . '">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=' .
_LANG_ENCODING . '" />
<title>SQL Error!</title>
</head>
<style type="text/css">
body {
font-family: Tahoma;
font-size: 12px;
}
.sql_error {
width: 90%;
padding: 3px;
background-color: #fff3f3;
border: solid 1px #ff0001;
direction: ltr;
margin: 0 auto;
text-align: justify;
margin-top: 10px;
font-weight: bold;
color: Red;
font-family: Tahoma;
}
</style>
<body>';
}
$html = '<div align="center"><img src="' . $style_full_path .
'/images/error.gif" /><br /><br />' . _LNG_ERR_SQL_DO .
'</div><div class="sql_error">' . $this->mysql_error_desc .
'<br />SQL ERROR Number is: ' . $this->mysql_error_number . '</div>';
if ($header == 1)
$html .= '</body></html>';
return $html;
}
function getLangStatement($str)
{
global $default_lang;
return ' ' . $str . " (lang = '" . $default_lang . "' || lang = 'all') ";
}
function closeConnection()
{
@mysql_close($this->linkID);
}
}
$MySQL = new MySQL();
$MySQL->DB_Connect();
// If i want to created a new query i'll do the following:
$MySQL->do_query('SELECT ...');
// If i want to get the result of the query above I'll do the following:
$MySQL->get_rows_array(); //etc
//If i want to created another query I'll create the same query statment without any changes:
$MySQL->do_query('SELECT ...');
?>
