public function dbW() { Doo::loadCore('db/DooSqlMagic'); $dbW = new DooSqlMagic(); $dbW->setDb(Doo::conf()->db_write, Doo::conf()->APP_MODE); $dbW->connect(); return $dbW; }
public function dbAAA2() { Doo::loadCore('db/DooSqlMagic'); $dbAAA = new DooSqlMagic(); $dbAAA->setDb(Doo::conf()->db_aaa2, Doo::conf()->APP_MODE); $dbAAA->connect(); return $dbAAA; }
/** * Execute a query to the connected database. Auto toggle between master & slave. * * @param string $query SQL query prepared statement * @param array $param Values used in the prepared SQL * @return PDOStatement */ public function query($query, $param = null) { if ($this->autoToggle === True) { $isSelect = strtoupper(substr($query, 0, 6)) == 'SELECT'; //change to master if update, insert, delete, create connection if not exist if (!isset($this->pdoList[$isSelect])) { #echo '<h1>Master connected</h1>'; $this->connectMaster(); } else { $rr = $isSelect ? 'Slave' : 'Master'; #echo '<h1>'. $rr .' used</h1>'; $this->pdo = $this->pdoList[$isSelect]; } } return parent::query($query, $param); }