first_php_project/details.php at main · Phensteve/first_php_project · 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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?php
    include('config/databaseConn.php');
    if (isset($_POST['delete'])) {

        $id_delete = mysqli_real_escape_string($connect, $_POST['id_delete']);

        $sql = "DELETE FROM data WHERE id = $id_delete";

        if (mysqli_query($connect, $sql)) {
            header('Location: index.php');
        }{
            echo "Query error: " . mysqli_error($connect);
        }
        // $result = mysqli_query($connect, $sql);
    }
    if (isset($_GET['id'])) {

        $id = mysqli_real_escape_string($connect, $_GET['id']);

        $sql = " SELECT * FROM data WHERE id = $id ";

        $result = mysqli_query($connect, $sql);

        $app = mysqli_fetch_assoc($result);

        mysqli_free_result($result);

        mysqli_close($connect);

        // print_r($app);
    }
?>
<!DOCTYPE html>
<html lang="en">
    <?php include('templates/header.php'); ?>
    <div class="container center">
        <?php if ($app) {?>
            <h4><?php echo htmlspecialchars($app['app']);?></h4>
            <p><?php echo htmlspecialchars($app['email']);?></p>
            <div><?php echo  htmlspecialchars($app['datejoined']);?></div>
            <h5>Languages:</h5>
            <p><?php echo htmlspecialchars($app['lang']);?></p>
            <p><?php echo 'Created by : ' . htmlspecialchars($app['name']);?></p>

        <?php } else{?>
            <h1 class="grey-text">Soryy but your app has not been registered with us!</h1>
        <?php } ?>
        <form action="details.php" method="POST">
            <input type="hidden" name="id_delete" value=<?php echo $app['id'];?>>
            <input type="submit" name="delete" value="Delete" class="btn brand z-depth-0">
        </form>

    </div>
    <?php include('templates/footer.php'); ?>
</html>