Untitled

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "tp1mysql"
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <link rel="stylesheet" type="text/css" href="style.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <meta charset="UTF-8">
    <title>CRUD</title>
</head>
<body>

    <section class="createSection">
        <h3 class="titreCreate">Create</h3>

            <form action="#" method="post">
                <div class="ligneInsertionTable">
                    <table>
                        <tr>
                            <th>Type</th>
                            <th>Adresse</th>
                            <th>Nom</th>
                            <th>Email</th>
                        </tr>
                        <tr>
                            <td>
                                <input type="text" class="input" id="type" name="type">
                            </td>
                            <td>
                                <input type="text" class="input" id="adresse" name="adresse">
                            </td>
                            <td>
                                <input type="text" class="input" id="nom" name="nom">
                            </td>
                            <td>
                                <input type="text" class="input" id="email" name="email">
                            </td>
                        </tr>
                    </table>
                    <input type="submit" value="INSERER" id="bInserer" name="bInserer">
                </div>
            </form>
    </section>

    <?php

    /*$conn = new mysqli($servername, $username, $password, $dbname);
    if($conn->connect_error){
        die("Connection echouée : " . $conn->connect_error);
    }
    for ($i = 0; $i < 50000; $i++){
        $sql = "INSERT INTO users (type, adresse, nom, supprime, email) VALUES (" . rand(0,9) . ", '". rand(0,9) . " rue IUT', 'Nom" . $i . "', '" . rand(0,1) . "', 'email" . $i . "@gmail.com')";
        if($conn->query($sql) === TRUE){
            echo  "Insertion réussie";
        }else{
            echo "Erreur : " . $sql . " " . $conn->error;
        }
    }

    $conn->close();*/


        if(!empty($_POST['type']) && !empty($_POST['adresse']) && !empty($_POST['nom']) && !empty($_POST['email'])){
            $conn = new mysqli($servername, $username, $password, $dbname);
            if($conn->connect_error){
                die("Connection echouée : " . $conn->connect_error);
            }
            $sql = "INSERT INTO users (type, adresse, nom, supprime, email) VALUES (" . $_POST['type'] . ", '" . $_POST['adresse'] . "', '" . $_POST['nom'] . "', 0, '" . $_POST['email'] . "')";
            if($conn->query($sql) === TRUE){
                echo  "Insertion réussie";
            }else{
                echo "Erreur : " . $sql . " " . $conn->error;
            }
            $conn->close();
        }
        ?>

    <section class="readSection">

        <?php

        ?>

        <?php

        $conn = new mysqli($servername, $username, $password, $dbname);
        if ($conn->connect_error) {
            die("Connection echouée : " . $conn->connect_error);
        }
        $nbPages = $conn->query("SELECT count(*) as nbLigne from users");
        $resultNbPage = $nbPages->fetch_assoc();
        echo "Page <form method='post' action='#' id='formTab' name='formTab'><input type='number' value='1' name='choixPage' id='choixPage'> sur " . ceil($resultNbPage['nbLigne']/10) . "<input type='submit' value='OK' id='boutonTab' name='boutonTab'></form> ";


        if(!empty($_POST['choixPage'])){
            $page = $_POST['choixPage'];
            if (($_POST['choixPage'])<0){
                $page = 1;
            }
            if (($_POST['choixPage'])>ceil($resultNbPage['nbLigne']/10)){
                $page = ceil($resultNbPage['nbLigne']/10);
            }
            $sql = "SELECT * FROM users LIMIT 10 OFFSET " . ($page-1)*10;
            $result = $conn->query($sql);

            if(mysqli_num_rows($result) > 0){
                echo "<table id=\"example\" class=\"display\" style=\"width:100%\"><thead><tr><th>ID</th><th>TYPE</th><th>ADRESSE</th><th>NOM</th><th>SUPPRIME</th><th>EMAIL</th><th>ACTION</th></tr></thead><tbody>";
                while($row = mysqli_fetch_assoc($result)){
                    echo "<tr><td class='test'>" . $row['id_users'] . "</td><td>" . $row['type'] . "</td><td>" . $row['adresse'] ."</td><td>" . $row['nom'] . "</td><td>" . $row['supprime'] . "</td><td>" . $row['email'] . "</td><td><img src='modif.png' class='imgModif'><img src='cross.png' class='imgCross'></td></tr>";
                }
                echo "</tbody></table>";
            }
            else{
                echo "Aucun resultat";
            }
        }else{
            $sql = "SELECT * FROM users LIMIT 10";
            $result = $conn->query($sql);

            if(mysqli_num_rows($result) > 0){
                echo "<table id=\"example\" class=\"display\" style=\"width:100%\"><thead><tr><th>ID</th><th>TYPE</th><th>ADRESSE</th><th>NOM</th><th>SUPPRIME</th><th>EMAIL</th><th>ACTION</th></tr></thead><tbody>";
                while($row = mysqli_fetch_assoc($result)){
                    echo "<tr><td class='test'>" . $row['id_users'] . "</td><td>" . $row['type'] . "</td><td>" . $row['adresse'] ."</td><td>" . $row['nom'] . "</td><td>" . $row['supprime'] . "</td><td>" . $row['email'] . "</td><td><img src='modif.png' class='imgModif'><img src='cross.png' class='imgCross'></td></tr>";
                }
                echo "</tbody></table>";
            }
            else{
                echo "Aucun resultat";
            }
        }

        mysqli_close($conn);


        ?>
    </section>

    <script>
            </script>


</body>
</html>