public function exec($assoc = false) { //echo $this->_sql; die(); try { $this->_pdo->exec('SET NAMES utf8'); switch ($this->_sql) { case stripos($this->_sql, 'select'): if (count($this->bindVal) > 0) { $result = $this->bind("select", $assoc); } else { $q = $this->_pdo->query($this->_sql); !$assoc ? $result = $q->fetchall() : ($result = $q->fetchall(PDO::FETCH_ASSOC)); } break; case stripos($this->_sql, 'delete'): $this->_pdo->exec($this->_sql) ? $result = 1 : ($result = 0); break; case stripos($this->_sql, 'insert'): if (count($this->bindVal) > 0) { $result = $this->bind("insert"); } else { $this->_pdo->exec($this->_sql) ? $result = 1 : ($result = 0); } break; case stripos($this->_sql, 'update'): $this->_pdo->exec($this->_sql) ? $result = 1 : ($result = 0); break; default: return "Cann't exec()"; } return $result; } catch (Exception $e) { throw Exeption::ThrowDb($e); } }
public function __construct($conn = "mysql") { try { $param_ini = new Config(); switch ($conn) { case "mysql": $this->_pdo = new PDO($param_ini->getVar('db.conn'), $param_ini->getVar('db.user'), $param_ini->getVar('db.pass')); break; case "mssql": $this->_pdo = new PDO($param_ini->getVar('db.conn_mssql'), $param_ini->getVar('db.user_mssql'), $param_ini->getVar('db.pass_mssql')); break; default: $this->_pdo = new PDO($param_ini->getVar('db.conn_' . $conn), $param_ini->getVar('db.user_' . $conn), $param_ini->getVar('db.pass_' . $conn)); } //if ($conn == "mysql") $this->_pdo = new PDO($param_ini->getVar('db.conn'),$param_ini->getVar('db.user'),$param_ini->getVar('db.pass')); //if ($conn == "mssql") $this->_pdo = new PDO($param_ini->getVar('db.conn_mssql'),$param_ini->getVar('db.user_mssql'),$param_ini->getVar('db.pass_mssql')); } catch (\PDOException $e) { throw Exeption::ThrowDb($e); } }