trAvis Anonymous - MANAGER

Edit File: finale.php

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

<body>
	<?php
$servername = "placmanfdrjoomla.mysql.db";
$database = "placmanfdrjoomla";
$username = "placmanfdrjoomla";
$password = "Da13Go12";
	  $number = $_POST['number'];
 
// Create connection
 
$conn = mysqli_connect($servername, $username, $password, $database);
	echo $_SESSION['number'];
	$mysqli = new mysqli($servername, $username, $password, $database);
 $mysqli->set_charset("utf8");
// Check connection
 
$requete = "SELECT DISTINCT result2 FROM resultats2 ORDER BY rand() LIMIT 5";
		$resultat = $mysqli->execute_query($requete);
		while ($ligne = $resultat->fetch_assoc()) {
			echo $ligne['result2'] . '<br>';
		}
		// vider les tables
$servname = "placmanfdrjoomla.mysql.db"; $dbname = "placmanfdrjoomla"; $user = "placmanfdrjoomla"; $pass = "Da13Go12";
            
            try{
                $dbco = new PDO("mysql:host=$servname;dbname=$dbname", $user, $pass);
                $dbco->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                
                $sql = "DELETE FROM resultats";
                $sth = $dbco->prepare($sql);
                $sth->execute();
                
                $count = $sth->rowCount();
                print('Effacement de ' .$count. ' entrées.');
            }
                  
            catch(PDOException $e){
                echo "Erreur : " . $e->getMessage();
            }
 
	    try{
                $dbco = new PDO("mysql:host=$servname;dbname=$dbname", $user, $pass);
                $dbco->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                
                $sql = "DELETE FROM nbr";
                $sth = $dbco->prepare($sql);
                $sth->execute();
                
                $count = $sth->rowCount();
                print('Effacement de ' .$count. ' entrées.');
            }
                  
            catch(PDOException $e){
                echo "Erreur : " . $e->getMessage();
            }
	try{
                $dbco = new PDO("mysql:host=$servname;dbname=$dbname", $user, $pass);
                $dbco->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                
                $sql = "DELETE FROM resultats2";
                $sth = $dbco->prepare($sql);
                $sth->execute();
                
                $count = $sth->rowCount();
                print('Effacement de ' .$count. ' entrées.');
            }
                  
            catch(PDOException $e){
                echo "Erreur : " . $e->getMessage();
            }
	
		try{
                $dbco = new PDO("mysql:host=$servname;dbname=$dbname", $user, $pass);
                $dbco->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                
                $sql = "DELETE FROM final";
                $sth = $dbco->prepare($sql);
                $sth->execute();
                
                $count = $sth->rowCount();
                print('Effacement de ' .$count. ' entrées.');
            }
                  
            catch(PDOException $e){
                echo "Erreur : " . $e->getMessage();
            }

</body>
</html>