includes/class/dbal_mysqli.php

   1 <?php
   2
   3 if (!defined('ROOT_PATH'))
   4 {
   5         exit;
   6 }
   7
   8 require(ROOT_PATH . 'includes/class/dbal.' . PHP_EXT);
   9
  10 class dbal_mysqli extends dbal
  11 {
  12         public function sql_connect($dbhost, $dbport, $dbname, $dbuser, $dbpass)
  13         {
  14                 if (!$this->db_conn = mysqli_connect($dbhost . (!empty($dbport) ? ":$dbport" : ''), $dbuser, $dbpass))
  15                 {
  16                         throw new ErrorException('dbal: failed to connect to database');
  17                 }
  18
  19                 mysqli_query($this->db_conn, "SET NAMES 'utf8'");
  20
  21                 if (!mysqli_select_db($this->db_conn, $dbname))
  22                 {
  23                         throw new ErrorException('dbal: failed to select db');
  24                 }
  25         }
  26
  27         public function sql_query($sql)
  28         {
  29                 $result = mysqli_query($this->conn_id, $sql);
  30
  31                 if (!$result)
  32                 {
  33                         throw new ErrorException("dbal: query failed\n\n" . mysqli_error($this->conn_id));
  34                 }
  35
  36                 return $result;
  37         }
  38
  39         public function sql_fetchrow($result)
  40         {
  41                 return mysqli_fetch_assoc($this->conn_id, $result);
  42         }
  43
  44         public function sql_freeresult($result)
  45         {
  46                 return mysqli_free_result($result);
  47         }
  48
  49         public function sql_close()
  50         {
  51                 return mysqli_close($this->conn_id);
  52         }
  53 }