AutoEcole/suppression_theme.php at main · baaaaadr/AutoEcole · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title></title>
    <link rel="stylesheet" href="style.css" type="text/css">
  </head>
  <body>
    <?php
        date_default_timezone_set('Europe/Paris');
        $date = date("Y-m-d");
        $dbhost = 'tuxa.sme.utc';
        $dbuser = 'nf92p003';
        $dbpass = 'gK41aEr1RFds';
        $dbname = 'nf92p003';
        $connect = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or die ('Error connecting to mysql');
        //la ligne suivante permet d'éviter les problèmes d'accent entre la page ouèbe et le serveur mysql
        mysqli_set_charset($connect, 'utf8');

                    $query="SELECT * FROM themes WHERE supprime=0"; //récupère les thèmes actifs
                    $result = mysqli_query($connect, $query);

                    echo "<form method='POST' action='supprimer_theme.php'>";
                    echo "<h1 align='center'>Thème à supprimer: </h1>";
                    echo "<select name='menuChoixTheme' size='4' required>";
                    while($row=mysqli_fetch_array($result, MYSQLI_NUM)){
                        echo "<option value='$row[0]'>";
                        echo $row[1];
                        echo "</option>";
                    }
                    echo "</select></br>";
                    echo "<input type='submit' value='Supprimer thème'>";
                    echo"</form>";


      mysqli_close($connect);
      ?>
  </body>
</html>