Requêtes dysfonctionnelles
Posté : 07 nov. 2021, 18:08
Bonjour,
durant l'exécution de la page, ce code n'apparait pas :
Enfin, le bouton "submit" chargé envoyer les requêtes fonctionne ainsi correctement :
Comment organiser le chapeau de mon code ?
durant l'exécution de la page, ce code n'apparait pas :
<div class="row">
<div class="col-md-12">
<?php if(@$_GET['q']==1)
{
$result = mysqli_query($con,"SELECT * FROM quiz ORDER BY date DESC") or die('Error');
echo '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">
<tr><td><center><b>Nb.</b></center></td><td><center><b>Sujets</b></center></td><td><center><b>total des questions</b></center></td><td><center><b>Notes</center></b></td><td><center><b>Action</b></center></td></tr>';
$c=1;
while($row = mysqli_fetch_array($result)) {
$title = $row['title'];
$total = $row['total'];
$sahi = $row['sahi'];
$eid = $row['eid'];
$q12=mysqli_query($con,"SELECT score FROM history WHERE eid='$eid' AND email='$email'" )or die('Error98');
$rowcount=mysqli_num_rows($q12);
if($rowcount == 0){
echo '<tr><td><center>'.$c++.'</center></td><td><center>'.$title.'</center></td><td><center>'.$total.'</center></td><td><center>'.$sahi*$total.'</center></td><td><center><b><a href="welcome.php?q=quiz&step=2&eid='.$eid.'&n=1&t='.$total.'" class="btn sub1" style="color:black;margin:0px;background:#1de9b6"><span class="glyphicon glyphicon-new-window" aria-hidden="true"></span> <span class="title1"><b>Start</b></span></a></b></center></td></tr>';
}
else
{
echo '<tr style="color:#99cc32"><td><center>'.$c++.'</center></td><td><center>'.$title.' <span title="Vous avez déjà répondu à ce questionnaire" class="glyphicon glyphicon-ok" aria-hidden="true"></span></center></td><td><center>'.$total.'</center></td><td><center>'.$sahi*$total.'</center></td><td><center><b><a href="update.php?q=quizre&step=25&eid='.$eid.'&n=1&t='.$total.'" class="pull-right btn sub1" style="color:black;margin:0px;background:red"><span class="glyphicon glyphicon-repeat" aria-hidden="true"></span> <span class="title1"><b>Refaire</b></span></a></b></center></td></tr>';
}
}
$c=0;
echo '</table></div></div>';
}?><?php
include_once 'database.php';
session_start();
if(!(isset($_SESSION['email'])))
{
header("location:login.php");
}
else
{
$name = $_SESSION['name'];
$email = $_SESSION['email'];
include_once 'database.php';
}
?><?php
require('database.php');
session_start();
if(isset($_SESSION["email"]))
{
session_destroy();
}
$ref=@$_GET['q'];
$email = $_POST['email'];
$pass = md5($_POST['password']);
$email = stripslashes($email);
$email = addslashes($email);
$pass = stripslashes($pass);
$pass = addslashes($pass);
$email = mysqli_real_escape_string($con,$email);
$pass = mysqli_real_escape_string($con,$pass);
$str = "SELECT * FROM users WHERE email='$email' and password='$pass'";
$result = mysqli_query($con,$str);
$_SESSION['logged']=$email;
$row=mysqli_fetch_array($result);
$_SESSION['name']=$row[1];
$_SESSION['id']=$row[0];
$_SESSION['email']=$row[2];
$_SESSION['password']=$row[3];
header('location: welcome.php?q=1');
?>Enfin, le bouton "submit" chargé envoyer les requêtes fonctionne ainsi correctement :
<?php
require('database.php');
session_start();
if(isset($_SESSION["email"]))
{
session_destroy();
}
$ref=@$_GET['q'];
if(isset($_POST['submit']))
{
$email = $_POST['email'];
$pass = md5($_POST['password']);
$email = stripslashes($email);
$email = addslashes($email);
$pass = stripslashes($pass);
$pass = addslashes($pass);
$email = mysqli_real_escape_string($con,$email);
$pass = mysqli_real_escape_string($con,$pass);
$str = "SELECT * FROM users WHERE email='$email' and password='$pass'";
$result = mysqli_query($con,$str);
if((mysqli_num_rows($result))!=1)
{
echo "<center><h3><script>alert('Votre mot de passe ou votre identifiant n'est pas correct);</script></h3></center>";
header("refresh:0;url=login.php");
}
else
{
$_SESSION['logged']=$email;
$row=mysqli_fetch_array($result);
$_SESSION['name']=$row[1];
$_SESSION['id']=$row[0];
$_SESSION['email']=$row[2];
$_SESSION['password']=$row[3];
header('location: welcome.php?q=1');
}
}
?>Comment organiser le chapeau de mon code ?
