I can not do delete with PHP, MySQL

Question

I can not do delete with PHP, MySQL

Navigation

#1 by (0 votes)

-1

So I'm a beginner in PHP and I have a question in the following code ... when I click on the remove button it does not remove just the id from the while loop, it removes all, could anyone help me?

<?php
    include 'conexao.php';
    session_start();
?>
<html>
    <head>
    </head>
    <body>
        <h1>CRUD - ALUNOS</h1>
        <form action="FrmCadastro.php" method="POST">
            <input type="submit" value="+"/>
        </form>
        <table border="2px">
        <th>Aluno</th>
        <th>Nota</th>
        <th>Turma</th>
        <tr></tr>
        <?php
            $sql = "SELECT * from tbAluno";
            $listarAlunos = mysqli_query($conexao, $sql);

            while($row = mysqli_fetch_assoc($listarAlunos)){
                $id = $row['id'];
                $nome = $row['aluno'];
                $nota = $row['nota'];
                $turma = $row['turma'];
        ?>
            <td>
                <?php echo"$nome"?>
            </td>
            <td>
                <?php echo"$nota"?>
            </td>
            <td>
                <?php echo"$turma"?>
            </td>
            <td>
                <form>
                <input type="submit" value="remover"/>
                    <?php
                        $sql = "DELETE from tbAluno WHERE id = $id";
                        $removerAluno = mysqli_query($conexao, $sql);
                        echo $id;
                    ?>
                </form>
            </td>
            <tr></tr>
        <?php 
            }
        ?>
        </table>
    </body>
</html>

php

asked by anonymous 05.12.2018 / 00:03

1 answer

Image upload rotates vertical image [duplicate] Magento admin layout error

score 0 · Accepted Answer

Manage.php

  $result = mysqli_query($conn, "SELECT * FROM table ORDER BY id DESC");
            while($row = mysqli_fetch_assoc($result)){ ?>
            <tr>
              <td><?php echo $row['id']; ?></td>
              <td><?php echo $row['title']; ?></td>
              <td><?php echo $row['date']; ?></td>
              <td>
                <a href="delet.php?id=<?php echo $row['id']; ?>" class="btn btn-info btn-xs">
                <i class="fa fa-pencil"></i> Edit
                </a>
              </td>
            </tr>
          <?php } ?>

Delet.php

$id = $_GET['id'];

$sql = mysqli_query($conn, "DELETE FROM table WHERE id='$id'");
$result  = mysqli_fetch_assoc($sql);

header("Location: manage.php");
exit();

Just replicate the code according to your information and purpose, I just did a demo.