lib/adodb/drivers/adodb-mysqlt.inc.php

   1 <?php
   2 /**
   3  * MySQL driver in transactional mode
   4  *
   5  * @deprecated
   6  *
   7  * This driver only supports the original MySQL driver in transactional mode. It
   8  * is deprecated in PHP version 5.5 and removed in PHP version 7. It is deprecated
   9  * as of ADOdb version 5.20.0. Use the mysqli driver instead, which supports both
  10  * transactional and non-transactional updates
  11  *
  12  * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
  13  *
  14  * @package ADOdb
  15  * @link https://adodb.org Project's web site and documentation
  16  * @link https://github.com/ADOdb/ADOdb Source code and issue tracker
  17  *
  18  * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
  19  * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
  20  * any later version. This means you can use it in proprietary products.
  21  * See the LICENSE.md file distributed with this source code for details.
  22  * @license BSD-3-Clause
  23  * @license LGPL-2.1-or-later
  24  *
  25  * @copyright 2000-2013 John Lim
  26  * @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
  27  */
  28
  29 // security - hide paths
  30 if (!defined('ADODB_DIR')) die();
  31
  32 include_once(ADODB_DIR."/drivers/adodb-mysql.inc.php");
  33
  34
  35 class ADODB_mysqlt extends ADODB_mysql {
  36         var $databaseType = 'mysqlt';
  37         var $ansiOuter = true; // for Version 3.23.17 or later
  38         var $hasTransactions = true;
  39         var $autoRollback = true; // apparently mysql does not autorollback properly
  40
  41         /* set transaction mode
  42
  43         SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL
  44 { READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE }
  45
  46         */
  47         function SetTransactionMode( $transaction_mode )
  48         {
  49                 $this->_transmode  = $transaction_mode;
  50                 if (empty($transaction_mode)) {
  51                         $this->Execute('SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ');
  52                         return;
  53                 }
  54                 if (!stristr($transaction_mode,'isolation')) $transaction_mode = 'ISOLATION LEVEL '.$transaction_mode;
  55                 $this->Execute("SET SESSION TRANSACTION ".$transaction_mode);
  56         }
  57
  58         function BeginTrans()
  59         {
  60                 if ($this->transOff) return true;
  61                 $this->transCnt += 1;
  62                 $this->Execute('SET AUTOCOMMIT=0');
  63                 $this->Execute('BEGIN');
  64                 return true;
  65         }
  66
  67         function CommitTrans($ok=true)
  68         {
  69                 if ($this->transOff) return true;
  70                 if (!$ok) return $this->RollbackTrans();
  71
  72                 if ($this->transCnt) $this->transCnt -= 1;
  73                 $ok = $this->Execute('COMMIT');
  74                 $this->Execute('SET AUTOCOMMIT=1');
  75                 return $ok ? true : false;
  76         }
  77
  78         function RollbackTrans()
  79         {
  80                 if ($this->transOff) return true;
  81                 if ($this->transCnt) $this->transCnt -= 1;
  82                 $ok = $this->Execute('ROLLBACK');
  83                 $this->Execute('SET AUTOCOMMIT=1');
  84                 return $ok ? true : false;
  85         }
  86
  87         function RowLock($tables,$where='',$col='1 as adodbignore')
  88         {
  89                 if ($this->transCnt==0) $this->BeginTrans();
  90                 if ($where) $where = ' where '.$where;
  91                 $rs = $this->Execute("select $col from $tables $where for update");
  92                 return !empty($rs);
  93         }
  94
  95 }
  96
  97 class ADORecordSet_mysqlt extends ADORecordSet_mysql{
  98         var $databaseType = "mysqlt";
  99
 100         function __construct($queryID,$mode=false)
 101         {
 102                 if ($mode === false) {
 103                         global $ADODB_FETCH_MODE;
 104                         $mode = $ADODB_FETCH_MODE;
 105                 }
 106
 107                 switch ($mode)
 108                 {
 109                 case ADODB_FETCH_NUM: $this->fetchMode = MYSQL_NUM; break;
 110                 case ADODB_FETCH_ASSOC:$this->fetchMode = MYSQL_ASSOC; break;
 111
 112                 case ADODB_FETCH_DEFAULT:
 113                 case ADODB_FETCH_BOTH:
 114                 default: $this->fetchMode = MYSQL_BOTH; break;
 115                 }
 116
 117                 $this->adodbFetchMode = $mode;
 118                 parent::__construct($queryID);
 119         }
 120
 121         function MoveNext()
 122         {
 123                 if (@$this->fields = mysql_fetch_array($this->_queryID,$this->fetchMode)) {
 124                         $this->_currentRow += 1;
 125                         return true;
 126                 }
 127                 if (!$this->EOF) {
 128                         $this->_currentRow += 1;
 129                         $this->EOF = true;
 130                 }
 131                 return false;
 132         }
 133 }
 134
 135 class ADORecordSet_ext_mysqlt extends ADORecordSet_mysqlt {
 136
 137         function MoveNext()
 138         {
 139                 return adodb_movenext($this);
 140         }
 141 }