public function getUpdateData($sql)
{
$resu = null;
try {
$pdo = new \PDO('mysql:host=' . \fbx\Config::getInstance()->getHost() . ';port=' . \fbx\Config::getInstance()->getPort() . ';dbname=' . \fbx\Config::getInstance()->getDbName(), \fbx\Config::getInstance()->getUser(), \fbx\Config::getInstance()->getPwd());
$resu = $pdo->exec($sql);
} catch (PDOException $e) {
echo $e->getMessage();
}
unset($pdo);
return $resu;
}
$pnidUser = $_GET['IDUser'];
$config = simplexml_load_file("../lib/config.ini");
$host = $config->dev->host;
$user = $config->dev->username;
$pwd = $config->dev->password;
$port = $config->dev->port;
$dbname = $config->dev->dbname;
$ip = $config->dev->ip;
$public = $config->path->public;
$q = "SELECT Login,Pwd FROM TBL_MEMBRE WHERE IDMembre = '{$pnidUser}' AND EstActif = '1' AND EstSupp = 0";
try {
$pdo = new \PDO('mysql:host=' . $host . ';port=' . $port . ';dbname=' . $dbname, $user, $pwd);
$query = $pdo->prepare($q);
$query->execute();
} catch (\PDOException $e) {
var_dump(\fbx\Config::getInstance());
var_dump($e->getMessage());
echo "l'erreur " . $e->getMessage() . "<br />";
echo "le numero de l'erreur est " . $e->getCode() . "<br />";
echo "l'erreur est à la ligne " . $e->getLine() . "<br />";
echo "l'erreur est à la ligne " . $e->getTrace() . "<br />";
die;
}
$ind = 0;
while ($row = $query->fetchObject()) {
$data[$ind] = $row;
$ind++;
}
unset($pdo);
unset($query);
// $_SESSION['conn'] = "http://$ip/$public"."index.php?login=$login&password=$pwd&languages=fr_FR";
