Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- class DB
- {
- // MySQL DB Info
- private static $mysql_host = "localhost";
- private static $mysql_user = "root";
- private static $mysql_pass = "";
- private static $mysql_db = "galaxy";
- private static $mysql_charset = "cp1251";
- ////////////////////////////////// Private prop
- private static $query_num = 0;
- private static $connected = false;
- ////////////////////////////////// Interface
- public static function Query($query, $efile, $eline) {
- if (!$connected) DB::Connect();
- $sql = mysql_query($query) or DB::SQLError($efile,$eline);
- DB::$query_num++;
- return $sql;
- }
- public static function FAQuery($query, $efile, $eline) {
- if (!$connected) DB::Connect();
- $result = (@mysql_fetch_assoc(@mysql_query($query))) or DB::SQLError($efile,$eline);
- DB::$query_num++;
- return $result;
- }
- public static function FRQuery($query, $efile, $eline) {
- if (!$connected) DB::Connect();
- $result = (@mysql_fetch_row(@mysql_query($query))) or DB::SQLError($efile,$eline);
- DB::$query_num++;
- return $result;
- }
- public static function NQuery($query, $efile, $eline) {
- if (!$connected) DB::Connect();
- mysql_query($query) or DB::SQLError($efile,$eline);
- DB::$query_num++;
- return;
- }
- public static function QNum($reset = true) {
- $num = DB::$query_num;
- if ($reset) DB::$query_num=0;
- return $num;
- }
- ////////////////////////////////// Private methods
- private static function Connect() {
- if (!@mysql_connect(DB::$mysql_host, DB::$mysql_user, DB::$mysql_pass))
- die("[" . mysql_errno() . "] dbconn: mysql_connect: " . mysql_error());
- mysql_select_db(DB::$mysql_db) or die("dbconn: mysql_select_db: " . mysql_error());
- mysql_query("SET NAMES $mysql_charset");
- $connected=true;
- }
- private static function SQLError($efile, $eline) {
- echo "<h1>Error In SQL Query</h1>" . mysql_error() . "<br/> Error num: " . mysql_errno();
- echo "<br/> File: " . $efile . "<br/> Line: " . $eline;
- die;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement