Advertisement
Guest User

Untitled

a guest
Jul 10th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.95 KB | None | 0 0
  1. <?
  2. class DB
  3. {
  4.     // MySQL DB Info
  5.     private static $mysql_host = "localhost";
  6.     private static $mysql_user = "root";
  7.     private static $mysql_pass = "";
  8.     private static $mysql_db = "galaxy";
  9.     private static $mysql_charset = "cp1251";
  10.     ////////////////////////////////// Private prop
  11.     private static $query_num = 0;
  12.     private static $connected = false;
  13.     ////////////////////////////////// Interface
  14.     public static function Query($query, $efile, $eline) {
  15.         if (!$connected) DB::Connect();
  16.         $sql = mysql_query($query) or DB::SQLError($efile,$eline);
  17.         DB::$query_num++;
  18.         return $sql;
  19.     }
  20.     public static function FAQuery($query, $efile, $eline) {
  21.         if (!$connected) DB::Connect();
  22.         $result = (@mysql_fetch_assoc(@mysql_query($query))) or DB::SQLError($efile,$eline);
  23.         DB::$query_num++;
  24.         return $result;
  25.     }
  26.     public static function FRQuery($query, $efile, $eline) {
  27.         if (!$connected) DB::Connect();
  28.         $result = (@mysql_fetch_row(@mysql_query($query))) or DB::SQLError($efile,$eline);
  29.         DB::$query_num++;
  30.         return $result;
  31.     }
  32.     public static function NQuery($query, $efile, $eline) {
  33.         if (!$connected) DB::Connect();
  34.         mysql_query($query) or DB::SQLError($efile,$eline);
  35.         DB::$query_num++;
  36.         return;
  37.     }
  38.     public static function QNum($reset = true) {
  39.         $num = DB::$query_num;
  40.         if ($reset) DB::$query_num=0;
  41.         return $num;
  42.     }
  43.     ////////////////////////////////// Private methods
  44.     private static function Connect() {
  45.         if (!@mysql_connect(DB::$mysql_host, DB::$mysql_user, DB::$mysql_pass))
  46.             die("[" . mysql_errno() . "] dbconn: mysql_connect: " . mysql_error());
  47.         mysql_select_db(DB::$mysql_db) or die("dbconn: mysql_select_db: " . mysql_error());
  48.         mysql_query("SET NAMES $mysql_charset");
  49.         $connected=true;
  50.     }
  51.     private static function SQLError($efile, $eline) {
  52.         echo "<h1>Error In SQL Query</h1>" . mysql_error() . "<br/> Error num: " . mysql_errno();
  53.         echo "<br/> File: " . $efile . "<br/> Line: " . $eline;
  54.         die;
  55.     }
  56. }
  57. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement