Show sourcecode

The following files exists in this folder. Click to view.

public_html/exercises/databas/ovn_db1/

createtable.php
deletepost.php
index.html
insertpost.php
selectposts.php
showtable.php
updatepost.php

`deletepost.php`

77 lines ASCII Windows (CRLF)

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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77


<!-- deletepost.php -->

<!doctype html>

<html>



<head>

    <meta charset="utf-8">

    <title>Delete</title>

</head>



<body>

    <form action="index.html" method="get"><button type="submit">Tillbaka till meny</button></form>

    <?php

    include('../dbconnection.php');

    if (!$dbconn) {

        die("Connection failed: Can't connect to database.");

    }

    $message = null;

    $id = null;



    if (isset($_POST['id']) && !empty($_POST['id'])) {

        $id = $_POST['id'];



        try {

            # prepare

            $sql = "DELETE FROM kompisar WHERE id=?";

            $stmt = $dbconn->prepare($sql);

            # the data we want to insert

            $data = array($id);

            # execute width array-parameter

            $stmt->execute($data);



            $message .= "<br />Record deleted successfully.<br />";

        } catch (PDOException $e) {

            $message .= $sql . "<br>" . $e->getMessage();

        }

    } else {

        $message .= "<br />";

    }



    echo $message;



    

// Ouput table with all posts

    /*** The SQL SELECT statement ***/

    $sql = "SELECT * FROM kompisar";

    $stmt = $dbconn->prepare($sql);

    // fetch width column names, create a table

    $data = array();

    $stmt->execute($data);

    $output = "<table><caption>Kompisar i table:</caption>";

    while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {

        $idx = htmlentities($res['id']);

        $first = htmlentities($res['firstname']);

        $last = htmlentities($res['lastname']);

        $mobilex = htmlentities($res['mobilenumber']);

        $email = htmlentities($res['email']);



        $output .= "<tr>" .

            "<td>$idx</td>" .

            "<td>$first</td>" .

            "<td>$last</td>" .

            "<td>$mobilex</td>" .

            "<td>$email</td>" .

            "<td><form method='post' action=''>" .

            "<input type='hidden' name='id' value='$idx'>" .

            "<button type='submit'>Ta bort</button></form></td>" .

            "</tr>";

    }

    $output .= "</table>";

    echo "$output";



    $dbconn = null;

    ?>



</body>



</html>