session_start();
define('INCLUDE_CHECK',true);
require 'login/connect.php';
if(!defined('INCLUDE_CHECK')) die('You are not allowed to execute this file directly');
/* Database config */
$db_host = 'localhost';
$db_user = 'gmap-users';
$db_pass = 'Globe-expert-01';
$db_database1 = 'fiuc2019';
/* End config */
$link = mysql_connect($db_host,$db_user,$db_pass) or die('Unable to establish a DB connection');
mysql_query("SET names UTF8");
require 'login/functions.php';
#
if ($_GET['id'] != "")
{
$_SESSION['dashboard'] = $_GET['id'];
}
if ($_SESSION['usr'] == "")
{
header("Location: accueil.php");
}
if ($_SESSION['dashboard'] == "")
{
header("Location: accueil.php");
exit;
}
mysql_select_db($db_database1,$link);
$dash_req = $_SESSION['dashboard'];
$sql = "SELECT dash_id, dash_name, dash_desc, dash_freq, dash_ref, dash_quest, dash_maj, dash_req, dash_datedeb, dash_datefin, dash_status FROM Dashboard where dash_req = '".$dash_req."'";
$result = mysql_query($sql);
if (!$result) {
echo "Impossible d'exÈcuter la requÍte ($sql) dans la base : " . mysql_error();
exit;
}
#if ($row['dash_status'] <> "2")
#{
# header("Location: Choice.php");
# exit;
#}
#if (mysql_num_rows($result) == 0) {
# echo "Aucune ligne trouvÈe, rien ‡ afficher.";
# exit;
#}
$row = mysql_fetch_assoc($result);
if($row['dash_name'])
{
$_SESSION['dash_id']=$row["dash_id"];
$_SESSION['ref']=$row["dash_ref"];
$_SESSION['name']=$row["dash_name"];
$_SESSION['desc']=$row["dash_desc"];
$_SESSION['req']=$row["dash_quest"];
$_SESSION['plage']="beetween ".$row["dash_dashdeb"]." and ".$row["dash_datefin"];
$sql1 = "SELECT Issue_id, Issue_value FROM Issue where Issue_id = '".$_SESSION['req']."'";
$result = mysql_query($sql1);
if (!$result) {
echo "Impossible d'exÈcuter la requÍte ($sql1) dans la base : " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
# echo "Aucune ligne trouvÈe, rien ‡ afficher.";
# echo $sql1;
# exit;
}
$row1 = mysql_fetch_assoc($result);
if($row1['Issue_value'])
{
$_SESSION['req']=$row1['Issue_value'];
}
}
$ref = $row["dash_ref"];
$req = $row["dash_quest"];
$name = $row["dash_name"];
$reqid = $row["dash_req"];
?>
Users ()
User Id
User
Password
Email
IP
Date
Admin ?
Status
Edit
Delete
$sql = "SELECT id, usr, pass, email, regIP, dt, admin, status FROM tz_members";
$result = mysql_query($sql);
if (!$result) {
echo "Impossible d'exécuter la requête ($sql) dans la base : " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "Aucune ligne trouvée, rien à afficher.";
exit;
}
while ($row = mysql_fetch_assoc($result))
{
if ($row["id"] != 1)
{
echo "".$row["id"]." ";#non éditable
echo "".$row["usr"]." ";#éditable
echo "".$row["pass"]." ";#éditable ==> voir algo de creation login
echo "".$row["email"]." ";#éditable
echo "".$row["regIP"]." ";#à maj avec IP
echo "".$row["dt"]." ";#à maj avec date
echo "".$row["admin"]." ";#flag 0 ou 1. Contrôler la valeur saisie
echo "".$row["status"]." ";#flag 0 ou 1. Contrôler la valeur saisie
echo "Edit ";
echo "Delete ";
}
}
?>
include("glossaire.inc")?>