public function ex_sqlx($sql, $close = TRUE) { $sql = mysql_class::arabicToPersian($sql); $conf = new conf(); $host = $conf->host; $db = $conf->db; $user = $conf->user; $pass = $conf->pass; if (isset($this) && get_class($this) == __CLASS__) { if (isset($this->ex_db) && $this->ex_db) { $host = $this->host; $user = $this->user; $pass = $this->pass; $db = $this->db; } } $table = $this->tableFromQuery($sql); if (!in_array($table, $this->hotTable) && $this->enableCache) { $cache = new cache_class($table, ''); $cache->delete(); } $out = "ok"; $q = NULL; $conn = mysql_connect($host, $user, $pass); if (!($conn == FALSE)) { if (!(mysql_select_db($db, $conn) == FALSE)) { mysql_query("SET NAMES 'utf8'"); mysql_query($sql, $conn); if ($close) { mysql_close($conn); } else { $out = $conn; } } else { $out = "Select DB Error."; } } else { $out = "Connect MySql Error."; } return $out; }
public function directQueryx($sql) { /* $conf= new conf; $host = $conf->host; $db =$conf->db; $user = $conf->user; $pass = $conf->pass; if(isset($this) && get_class($this) == __CLASS__) { if(isset($this->ex_db) && $this->ex_db) { $host = $this->host; $user = $this->user; $pass = $this->pass; $db = $this->db; } } // $db = $this->convertDB($sql); $out = "ok"; $q = NULL; $db = $this->convertDB($sql,$db); $sql = $this->convertQuery(mysql_class::arabicToPersian($sql)); $conn = mysql_connect($host,$user,$pass); if(!($conn==FALSE)){ if(!(mysql_select_db($db,$conn)==FALSE)){ mysql_query("SET NAMES 'utf8'"); mysql_query($sql,$conn); mysql_close($conn); }else $out = "Select DB Error."; }else $out = "Connect MySql Error."; * */ $this->load->database(); $sql = $this->convertQuery(mysql_class::arabicToPersian($sql)); $this->db->query($sql); return $this->db->insert_id(); }