static function execSQLFromFile($file, $bdd, $host, $user, $pass) { $sql = utf8_decode(file_get_contents($file)); $tabSQL = explode(';', $sql); $req = new XhamRequete($bdd, '', '', $host, $user, $pass); while (list($key, $val) = each($tabSQL)) { $rql = trim($val); if ($rql) { //print "REQUEEEEEEEEEEEEEEEETE".$rql."<br/><br/>" ; $res = $req->exec_requete($rql, 'resultquery'); } } return $res; }
public function truncate() { $requete = new XhamRequete($this->getBDD(), $this->nomTable, '', $this->getHost(), $this->getUser(), $this->getPass()); return $requete->exec_requete('TRUNCATE TABLE `' . $this->nomTable . '`'); }