trAvis Anonymous - MANAGER

Edit File: tirage2.php

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Document sans titre</title>
</head>

<body>
<?

$servername = "placmanfdrjoomla.mysql.db";
$database = "placmanfdrjoomla";
$username = "placmanfdrjoomla";
$password = "Da13Go12";

session_start();
	$numero = $_SESSION['number'];
 
// Create connection
 
$conn = mysqli_connect($servername, $username, $password, $database);
	
	
// Check connection
 
if (!$conn) {
 
    die("Connection failed: " . mysqli_connect_error());
 
}
echo "Connected successfully<br>";
	echo $numero;

//$sql = "INSERT INTO nbr (num) VALUES ('$numero')";

// Nombre d'éléments à  extraire aléatoirement
     $a = 5;
       
    $requete = $conn->query(
"SELECT DISTINCT result FROM resultats ORDER BY rand() LIMIT $a");
    while ($row = mysqli_fetch_array($requete))
    {
      echo $row['result'].'<br />';
    }
	
	
	
// comptage

for( $i = 1 ; $i < $_SESSION['number'] +1 ; $i++ ) {
  try {
    $pdo = new PDO('mysql:host=placmanfdrjoomla.mysql.db;dbname=placmanfdrjoomla','placmanfdrjoomla','Da13Go12');

$sql = "SELECT COUNT(*) AS result FROM resultats WHERE result = '$i' ";
    $result = $pdo->query($sql);
    $columns = $result->fetch();
    $nb = $columns['result'];
    
    echo 'Il y a '.$nb.' enregistrements pour '.$i.'.<br>';
	  
	  $sql = "INSERT INTO final (num, cote)
VALUES ('$i', '$nb')";
$conn->query($sql);

} catch(PDOException $e) {
    echo 'Erreur PDO : '.$e->getMessage();
}

}

header("Location: finale.php");
	?>
</body>
</html>