function initialisation()
{
// On parse le fichier .ini
self::$ini = array();
$iniFilePath = 'conf/config.ini';
self::$ini = parse_ini_file($iniFilePath);
// On ouvre la connexion à la BDD
DbLink::getLink()->init(self::$ini['BDD_TYPE'], self::$ini['BDD_HOTE'], self::$ini['BDD_PORT'], self::$ini['BDD_BASENAME'], self::$ini['BDD_LOGIN'], self::$ini['BDD_PASSWORD']);
// On récupère la liste des plugins et des tables
$this->pluginsIndex = array();
self::$tables = array();
try {
$q0 = get_link()->prepare("SELECT id AS ID,name AS NAME FROM " . get_ini('BDD_PREFIX') . "core_plugins WHERE activated=1 AND deleted_date=0");
$q0->execute(array());
while ($r0 = $q0->fetch(PDO::FETCH_OBJ)) {
self::$plugins[$r0->NAME] = $r0->ID;
array_push($this->pluginsIndex, $r0->NAME);
}
$q0 = get_link()->prepare("SELECT id AS ID,name AS NAME FROM " . get_ini('BDD_PREFIX') . "core_tables WHERE deleted_date=0");
$q0->execute(array());
while ($r0 = $q0->fetch(PDO::FETCH_OBJ)) {
self::$tables[$r0->NAME] = $r0->ID;
}
// Load the accessManager class for security function
self::$accessM = new accessManager();
} catch (Exception $e) {
echo 'Erreur : ' . $e->getMessage() . '<br />';
echo 'N° : ' . $e->getCode();
}
$userAccessArray = array();
// Load local
if (!isset($_SESSION['LANG'])) {
if (get_ini('DEFAULT_LANGUAGE') != '') {
$_SESSION['LANG'] = get_ini('DEFAULT_LANGUAGE');
} else {
$_SESSION['LANG'] = 'en_US';
}
}
if (isset($_GET['lang'])) {
$lang = $_GET['lang'];
$_SESSION['LANG'] = $lang;
self::$ini['DEFAULT_LANGUAGE'] = $lang;
} elseif (isset($_SESSION['LANG'])) {
$lang = $_SESSION['LANG'];
} else {
$lang = "en_US";
}
if (function_exists('bindtextdomain')) {
putenv("LANG={$lang}");
setlocale(LC_ALL, $lang);
bindtextdomain('lang', 'locale');
// Le nom de nos fichiers .mo et le folder qui contient les folders de langue
bind_textdomain_codeset("lang", 'UTF-8');
textdomain('lang');
}
//$domain2 = "example2";
//bindtextdomain($domain2, "Locale");
//bind_textdomain_codeset($domain2, 'UTF-8');
//$user = "******";
}
}
function findUserByIdSecure($id)
{
$sql = 'SELECT * FROM users where id = ' . $id;
$result = $this->conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
print_r($row);
echo '<br/>';
}
} else {
echo "Nothing to display";
}
}
}
if (isset($_REQUEST['userid']) && $_REQUEST['userid'] != null) {
$link = new DbLink();
$link->findUserByIdSecure($_REQUEST['userid']);
$link->disconnect();
} else {
echo 'nothing to select!<br/>';
}
?>
<form>
User id: <input type="text" name="userid"/>
<br/>
<input type="submit"/>
</form>
</body>
</html>
die("Connection failed: " . $conn->connect_error);
}
}
function disconnect()
{
$this->conn->close();
}
function DbLink()
{
echo 'Constructor called<br/>';
$this->connect();
}
function findUsers()
{
$sql = 'SELECT * FROM users';
$result = $this->conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "id: " . $row["id"] . " - Name: " . $row["username"] . " " . $row["password"] . "<br/>";
}
} else {
echo "Nothing to display";
}
}
}
$link = new DbLink();
$link->findUsers();
$link->disconnect();
?>
</body>
</html>
