Delete specific row in database table

PHP
1

This is my delete page :

<?php 
//database connection $db
require('includes/config.php'); 

    $id = $_GET['ID'];
    $
    $query='DELETE * FROM studentraspored WHERE ID = "' . $id . '" ';
    $pdoResult = $db->prepare($query);

    $pdoExec = $pdoResult->execute($query);

    header('location:index.php');
    exit();
?>

This is generated table in my “memberpage.php”:

if (count($rows)){
    foreach ($rows as $row) {       
       
        $id = $row['ID'];
        echo "<tr>" .
            '<form action="delete_raspored.php" method="post">'.
            "<td>" . $row["ID"] . "</td>" .
            "<td>" . $row["den"] . "</td>" .
            "<td>" . $row["chas"] . "</td>" .
            "<td>" . $row["predmet"] . "</td>" .
            "<td>" . $row["profesor"] . "</td>" .               
            "<td>" . $row["prostorija"] . "</td>" .
            "<td>" . $row["tip"] . "</td>" .
            '<td><input type="hidden" name="id" value="' . $id . '"/><input type="submit" value="Delete" ></td>'.
            "</form>".
            "</tr>"

This not working properly. I don’t understand why maybe something i missed. I still learning php, pdo…

1 Like