Sélectionner une révision Git
Bifurcation depuis
Nassim YAICI / projet_web
Le projet source a une visibilité limitée.
-
Nassim YAICI a rédigéNassim YAICI a rédigé
topiclist.php 3,70 Kio
<?php
session_start();
require_once"fonction.php";
$bdd = bdd();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Com-Ensiie</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="./bootstrap/css/bootstrap.css">
<link rel="stylesheet" href="./bootstrap/css/mystyle.css">
<script src="./script.js"></script>
</head>
<body>
<div class="container-fluid">
<div class="jumbotron">
<h1><span style="color: white">Com-Ensiie</span></h1>
</div>
<?php
if(isset($_SESSION['pseudo'])){
$pseudo=$_SESSION['pseudo'];
?>
<button type="button" class="btn btn-success btn-right" onclick="location.href='./deconnexion.php'" >Deconnexion</button>
<button type="button" class="btn btn-success btn-right" onclick="location.href='./edit.php'" >Edit</button>
<button type="button" class="btn btn-success btn-right" onclick="location.href='./newtopics.php'" >Nouveau sujet</button>
<label for="hello"><?php echo "Vous êtes connectés entant que : $pseudo";?></label>
<?php
}
else
{
?>
<button type="button" class="btn btn-success btn-right" onclick="location.href='./login.php'" >Se connecter</button>
<button type="button" class="btn btn-success btn-right" onclick="location.href='./register.php'">S'enregistrer</button>
<?php
}
?>
</div>
<div>
<nav class="navbar navbar-inverse">
<div class="navbar-header">
<a class="navbar-brand" href="accueil.php">Com-Ensiie</a>
</div>
<?php
$dn2 = pg_query("SELECT * FROM keys ORDER BY name asc");
while($reponse=pg_fetch_assoc($dn2))
{
?>
<div class="navbar-header">
<ul class="nav navbar-nav">
<li class="dropdown active"><a href="./topiclist.php?category=<?php echo $reponse['name']; ?>"><?php echo $reponse['name']; ?></a></li>
</ul>
</div>
<?php
}
?>
</nav>
</div>
<div class="container-fluid text-center">
<div class="row content">
<div class="col-sm-2 sidenav">
<?php
if(isset($_SESSION['su'])){
if ($_SESSION['su']=='t') {
?>
<div>
<button type="button" class="btn btn-info btn-right" onclick="location.href='./adminEdit.php'" >Edit users</button><br><br>
</div>
<div>
<button type="button" class="btn btn-info btn-right" onclick="location.href='./adminEditTopics.php'" >Edit toppics</button>
</div>
<?php
}}
?>
</div>
<?php
if(isset($_GET['category'])){
$name=htmlspecialchars($_GET['category']);
$sql=pg_query("SELECT name, namet, date FROM toppics JOIN keys ON(id_key=keys.id) WHERE name='$name' ORDER BY (date,name)");
}
else
{
$sql=pg_query("SELECT name, namet, date FROM toppics JOIN keys ON(id_key=keys.id) ORDER BY (date,name)");
}
?>
<div class="col-lg-8 lg-8 text-left">
<table class="table">
<col width="20%">
<col width="60%">
<col width="20%">
<thead>
<tr>
<th class="lead">Catégorie</th>
<th class="lead">Sujet</th>
<th class="lead">Date</th>
</tr>
</thead>
<?php
while($reponse=pg_fetch_assoc($sql))
{
?>
<tr>
<td><a href="topiclist.php?category=<?php echo $reponse['name'];?>"><?php echo $reponse['name'];?></a></td>
<td><a href="affichetoppic.php?toppic=<?php echo $reponse['namet'];?>"><?php echo $reponse['namet'];?></td>
<td><?php echo $reponse['date'];?></td>
</tr>
<?php
}
?>
</table>
</div>
</div>
</div>
</div>
</body>
</html>