rrcfesc / codeignitercoredatabase

src/Mysql/CI_DB_mysqli_driver.php

Indentation +101 added lines, -101 removed lines

@@ -54,67 +54,67 @@ 
  * @link		https://codeigniter.com/user_guide/database/
  */
 class CI_DB_mysqli_driver extends CI_DB_driver {
-    /**
-     * Database driver
-     *
-     * @var string
-     */
-    public $dbdriver = 'mysqli';
-    /**
-     * Compression flag
-     *
-     * @var bool
-     */
-    public $compress = FALSE;
-    /**
-     * DELETE hack flag
-     *
-     * Whether to use the MySQL "delete hack" which allows the number
-     * of affected rows to be shown. Uses a preg_replace when enabled,
-     * adding a bit more processing to all queries.
-     *
-     * @var bool
-     */
-    public $delete_hack = TRUE;
-    /**
-     * Strict ON flag
-     *
-     * Whether we're running in strict SQL mode.
-     *
-     * @var bool
-     */
-    public $stricton;
-    /**
-     * Identifier escape character
-     *
-     * @var string
-     */
-    protected $_escape_char = '`';
-    /**
-     * MySQLi object
-     *
-     * Has to be preserved without being assigned to $conn_id.
-     *
-     * @var MySQLi
-     */
-    protected $_mysqli;
-    /**
-     * 
-     * @param array $params
-     */
-    public function __construct(array $params)
-    {
-        parent::__construct($params);
-    }
-
-    /**
-     * Database connection
-     *
-     * @param	bool	$persistent
-     * @return	object
-     **/
-    public function db_connect($persistent = FALSE)
-    {
+	/**
+	 * Database driver
+	 *
+	 * @var string
+	 */
+	public $dbdriver = 'mysqli';
+	/**
+	 * Compression flag
+	 *
+	 * @var bool
+	 */
+	public $compress = FALSE;
+	/**
+	 * DELETE hack flag
+	 *
+	 * Whether to use the MySQL "delete hack" which allows the number
+	 * of affected rows to be shown. Uses a preg_replace when enabled,
+	 * adding a bit more processing to all queries.
+	 *
+	 * @var bool
+	 */
+	public $delete_hack = TRUE;
+	/**
+	 * Strict ON flag
+	 *
+	 * Whether we're running in strict SQL mode.
+	 *
+	 * @var bool
+	 */
+	public $stricton;
+	/**
+	 * Identifier escape character
+	 *
+	 * @var string
+	 */
+	protected $_escape_char = '`';
+	/**
+	 * MySQLi object
+	 *
+	 * Has to be preserved without being assigned to $conn_id.
+	 *
+	 * @var MySQLi
+	 */
+	protected $_mysqli;
+	/**
+	 * 
+	 * @param array $params
+	 */
+	public function __construct(array $params)
+	{
+		parent::__construct($params);
+	}
+
+	/**
+	 * Database connection
+	 *
+	 * @param	bool	$persistent
+	 * @return	object
+	 **/
+	public function db_connect($persistent = FALSE)
+	{
 		// Do we have a socket path?
 		if ($this->hostname[0] === '/')
 		{
@@ -215,22 +215,22 @@ 
 		}
 
 		return FALSE;
-    }
+	}
 
 	// --------------------------------------------------------------------
 
-    /**
-     * Reconnect
-     * Keep / reestablish the db connection if no queries have been
-     * sent for a length of time exceeding the server's idle timeout
-     * @return void
-     */
-    public function reconnect()
-    {
-        if ($this->conn_id !== FALSE && $this->conn_id->ping() === FALSE) {
-            $this->conn_id = FALSE;
-        }
-    }
+	/**
+	 * Reconnect
+	 * Keep / reestablish the db connection if no queries have been
+	 * sent for a length of time exceeding the server's idle timeout
+	 * @return void
+	 */
+	public function reconnect()
+	{
+		if ($this->conn_id !== FALSE && $this->conn_id->ping() === FALSE) {
+			$this->conn_id = FALSE;
+		}
+	}
 	/**
 	 * Select the database
 	 *
@@ -299,33 +299,33 @@ 
 
 	// --------------------------------------------------------------------
 
-    /**
-     * Prep the query
-     *
-     * If needed, each database adapter can prep the query string
-     *
-     * @param   string $sql an SQL query
-     * @return  string
-     */
-    protected function _prep_query($sql)
-    {
-        // mysqli_affected_rows() returns 0 for "DELETE FROM TABLE" queries. This hack
-        // modifies the query so that it a proper number of affected rows is returned.
-        if ($this->delete_hack === TRUE && preg_match('/^\s*DELETE\s+FROM\s+(\S+)\s*$/i', $sql)) {
-                return trim($sql).' WHERE 1=1';
-        }
-        return $sql;
-    }
-    /**
-     * Begin Transaction
-     *
-     * @return bool
-     */
-    protected function _trans_begin()
-    {
-        $this->conn_id->autocommit(FALSE);
-        return  $this->simple_query('START TRANSACTION'); // can also be BEGIN or BEGIN WORK
-    }
+	/**
+	 * Prep the query
+	 *
+	 * If needed, each database adapter can prep the query string
+	 *
+	 * @param   string $sql an SQL query
+	 * @return  string
+	 */
+	protected function _prep_query($sql)
+	{
+		// mysqli_affected_rows() returns 0 for "DELETE FROM TABLE" queries. This hack
+		// modifies the query so that it a proper number of affected rows is returned.
+		if ($this->delete_hack === TRUE && preg_match('/^\s*DELETE\s+FROM\s+(\S+)\s*$/i', $sql)) {
+				return trim($sql).' WHERE 1=1';
+		}
+		return $sql;
+	}
+	/**
+	 * Begin Transaction
+	 *
+	 * @return bool
+	 */
+	protected function _trans_begin()
+	{
+		$this->conn_id->autocommit(FALSE);
+		return  $this->simple_query('START TRANSACTION'); // can also be BEGIN or BEGIN WORK
+	}
 
 	// --------------------------------------------------------------------