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";