<?php include '../MicroCMS/src/model.php'; $connexion = new BDD('gestinv1'); $message = ""; $requete = "select nomClient, nomSite, numeroImmo, nomTypeequipement, numserie " . "from client, site, immobilisation, typeequipement"; $tab_inv = $connexion->select($requete); ?> <!DOCTYPE html> <html> <head> <?php /** Inclusion des différents paramètres présent dans l'élément head commum aux pages */ //include("struct/param_headAccueil.php"); ?> <link rel="stylesheet" type="text/css" href="css/connexion.css"> <title>Gestion d'inventaire LMS Informatique</title> </head> <body> <div id='cadre'> <header><h1>Inventaire</h1></header> <section> <h1> Inventaire </h1> <table cellspacing='10'><tr><th> Client </th> <th> Site </th><th> n° Immo </th><th> Type d'équipement</th><th> n° Serie </th></tr> <?php foreach ($tab_inv as $ligne) { //on crée un lien sur le numero de dt qui permet d'aller sur la page affichant le détail de cette dt echo "<tr><td>" . $ligne['nomClient'] . "</td>\n";
public static function logUser($userId, $userFirstName, $userLastName, $userPicSrc) { $newStaticBdd = new BDD(); if (!empty($_SERVER['HTTP_CLIENT_IP'])) { $ip = $_SERVER['HTTP_CLIENT_IP']; } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip = $_SERVER['HTTP_X_FORWARDED_FOR']; } else { $ip = $_SERVER['REMOTE_ADDR']; } $userId = $newStaticBdd->real_escape_string(htmlspecialchars($userId)); $userPicSrc = $newStaticBdd->real_escape_string(htmlspecialchars($userPicSrc)); $userLink = $newStaticBdd->real_escape_string(htmlspecialchars(preg_replace("/[\\s\\W]+/", '', strtolower($userFirstName)) . "." . preg_replace("/[\\s\\W]+/", '', strtolower($userLastName)))); $userFirstName = $newStaticBdd->real_escape_string(htmlspecialchars($userFirstName)); $userLastName = $newStaticBdd->real_escape_string(htmlspecialchars($userLastName)); $userInfos = $newStaticBdd->select("fb_id, userlink, fb_firstname, fb_lastname, fb_picture, time_update", "users", "WHERE fb_id LIKE '" . $userId . "'"); $getUserInfos = $newStaticBdd->fetch_array($userInfos); $getUserId = $newStaticBdd->num_rows($userInfos); setcookie("username", $userFirstName . ' ' . $userLastName, time() + 7200, "/"); $_SESSION['SID_ID'] = session_id(); if (self::setToken($userId)) { if ($getUserId != 1) { $regUser = $newStaticBdd->insert("users", "fb_id, userlink, fb_firstname, fb_lastname, fb_picture, user_ip, isLoggedFB", "'" . $userId . "', '" . $userLink . "', '" . $userFirstName . "', '" . $userLastName . "', '" . $userPicSrc . "', '" . $ip . "', 1"); $dataArray['result'] = true; $dataArray['error'] = null; $dataArray['reply'] = "User " . $userFirstName . " " . $userLastName . " registred !"; } else { $regUser = $newStaticBdd->update("users", "fb_id = '" . $userId . "', userlink = '" . $userLink . "', fb_firstname = '" . $userFirstName . "', fb_lastname = '" . $userLastName . "', fb_picture = '" . $userPicSrc . "', user_ip = '" . $ip . "', isLoggedFB = 1", "WHERE fb_id LIKE '" . $userId . "'"); $dataArray['result'] = true; $dataArray['error'] = null; $dataArray['reply'] = "User " . $userFirstName . " " . $userLastName . " updated and logged !"; } } else { $dataArray['result'] = false; $dataArray['error'] = "Token not set !"; $dataArray['reply'] = "User not logged !"; } return $dataArray; }
public static function getUserInfos() { $dataArray = array(); if (User::isAdmin()) { $newStaticBdd = new BDD(); $UserInfos = $newStaticBdd->select("id, fb_firstname, fb_lastname, fb_picture, email, user_ip", "users", "ORDER BY id ASC"); while ($getUserInfos = $newStaticBdd->fetch_array($UserInfos)) { ob_start(); include '../models/users-infos-container.php'; $dataArray['reply'] .= ob_get_contents(); ob_end_clean(); } return $dataArray; } }