<?php if (LoginCheck($pdo) and $_SESSION['level'] == 2) { //init fields $Voornaam = $Achternaam = $Adres = $Postcode = $Woonplaats = $Telefoon = $Email = $Gebruikersnaam = $oudWachtwoord = $nieuwWachtwoord = $herhaalWachtwoord = $Level = $Leeftijd = $Groep = NULL; //init error fields $FnameErr = $LnameErr = $ZipErr = $CityErr = $TelErr = $MailErr = $UserErr = $PassErr = $RePassErr = $LeefErr = NULL; if (isset($_POST['Wijzig'])) { $Voornaam = $_POST['Voornaam']; $Achternaam = $_POST['Achternaam']; $Adres = $_POST['Adres']; $Postcode = $_POST['Postcode']; $Woonplaats = $_POST['Woonplaats']; $Telefoon = $_POST['Telefoon']; $Email = $_POST['Email']; $Gebruikersnaam = $_POST['Gebruikersnaam']; $parameters = array(':PersoonsID' => $_SESSION['user_id'], ':Voornaam' => $Voornaam, ':Achternaam' => $Achternaam, ':Adres' => $Adres, ':Postcode' => $Postcode, ':Woonplaats' => $Woonplaats, ':Telefoon' => $Telefoon, ':Email' => $Email); $sth = $pdo->prepare('UPDATE persoonsgegevens SET Achternaam = :Achternaam, Voornaam = :Voornaam, Adres = :Adres, Postcode = :Postcode, Woonplaats = :Woonplaats, Telefoon = :Telefoon, Email = :Email WHERE PersoonsID = :PersoonsID'); $sth->execute($parameters); require './Forms/EditProfielForm.php'; } elseif (isset($_POST['wijzigprofiel'])) { $sth = $pdo->prepare("SELECT * FROM persoonsgegevens p, groepsleiders gl, inloggegevens i WHERE p.PersoonsID = gl.PersoonsID AND p.PersoonsID = i.PersoonsID"); $sth->execute(); $row = $sth->fetch(); $Voornaam = $row['Voornaam']; $Achternaam = $row['Achternaam']; $Adres = $row['Adres']; $Postcode = $row['Postcode']; $Woonplaats = $row['Woonplaats']; $Telefoon = $row['Telefoon']; $Email = $row['Email'];
<?php } else { ?> <a href="?Page=0"> <div class="inloggen"> <h1>Inloggen</h1> </div> </a> <?php } ?> </div> <div id="secondmenu"> <?php if (LoginCheck($pdo)) { $parameters = array(':level' => $_SESSION['level']); $sth = $pdo->prepare("SELECT * FROM menu WHERE Level = :level"); $sth->execute($parameters); while ($row = $sth->fetch()) { echo '<a class ="a_menu" href="?Page=' . $row["MenuID"] . '">'; echo '<div class="2ndmenu">'; echo '<h1>' . $row["Naam"] . '</h1>'; echo '</div>'; echo '</a>'; } } ?> </div>
$langfile = $langpath . $language_interface . '/trad4all.inc.php'; if (file_exists($langfile)) { include $langfile; } } // include the local (contextual) parameters of this course or section require $includePath . '/local.inc.php'; // The global variable $text_dir has been defined in the language file trad4all.inc.php. // For determining text direction correspondent to the current language // we use now information from the internationalization library. $text_dir = api_get_text_direction(); // ===== "who is logged in?" module section ===== // check and modify the date of user in the track.e.online table if (!($x = strpos($_SERVER['PHP_SELF'], 'whoisonline.php'))) { preventMultipleLogin($_user["user_id"]); LoginCheck(isset($_user['user_id']) ? $_user['user_id'] : ''); } // ===== end "who is logged in?" module section ===== //Update of the logout_date field in the table track_e_login // (needed for the calculation of the total connection time) if (!isset($_SESSION['login_as']) && isset($_user)) { // if $_SESSION['login_as'] is set, then the user is an admin logged as the user $tbl_track_login = Database::get_main_table(TABLE_STATISTIC_TRACK_E_LOGIN); $sql = "SELECT login_id, login_date\n FROM {$tbl_track_login}\n WHERE\n login_user_id='" . $_user["user_id"] . "'\n ORDER BY login_date DESC\n LIMIT 0,1"; $q_last_connection = Database::query($sql); if (Database::num_rows($q_last_connection) > 0) { $i_id_last_connection = Database::result($q_last_connection, 0, 'login_id'); // is the latest logout_date still relevant? $sql = "SELECT logout_date FROM {$tbl_track_login}\n WHERE login_id = {$i_id_last_connection}"; $q_logout_date = Database::query($sql); $res_logout_date = convert_sql_date(Database::result($q_logout_date, 0, 'logout_date'));
<?php //****************************// // // // LMの選択/表示ページ // // // //****************************// require_once "ConfSmarty.class.php"; require_once "util.php"; require_once "connect.db.php"; Init(); LoginCheck(); //*************************// // POST前な らLM選択画面を表示 // //*************************// if ($_SERVER["REQUEST_METHOD"] != "POST") { // LMの存在する日付の取得 $query2 = "SELECT Date FROM {$lm_t}"; $sql2 = mysqli_query($link, $query2) or die("クエリ2失敗です" . mysql_error()); while ($data = mysqli_fetch_assoc($sql2)) { $date_exist[] = $data['Date']; } $date_exist = json_encode($date_exist); $title = "LM表示"; $login = "******"; $add_user = "******"; $lm = "learning_material.php"; $smarty = new ConfSmarty(); $smarty->assign("title", $title); $smarty->assign("login", $login); $smarty->assign("add_user", $add_user);