Example #1
0
 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;
 }
Example #2
0
 public function truncate()
 {
     $requete = new XhamRequete($this->getBDD(), $this->nomTable, '', $this->getHost(), $this->getUser(), $this->getPass());
     return $requete->exec_requete('TRUNCATE TABLE `' . $this->nomTable . '`');
 }