Relearn/deleteTeacherAccount.php at main · Ahmad495/Relearn · 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
56
57
58
59
60
61
62
63
64
65
<?php
require_once 'dbh.inc.php';
if (isset($_GET['userUid'])) {
    $userUid = $_GET['userUid'];
    $findVideosQuery = "SELECT * FROM videos WHERE teacherUid='$userUid'";
    $videosResult = mysqli_query($conn, $findVideosQuery);
    $findServicesQuery = "SELECT * FROM services WHERE teacherUid='$userUid'";
    $servicesResult = mysqli_query($conn, $findServicesQuery);
    if (mysqli_num_rows($videosResult) > 0) {
        while ($row = mysqli_fetch_array($videosResult)) {
            $createDeletePathVideos = "../../upload/" . $row['videoFile'];
            if (unlink($createDeletePathVideos)) {
                $delVideosQuery =  "DELETE FROM videos WHERE teacherUid='$userUid'";
                $result = mysqli_query($conn, $delVideosQuery) or die("Query Unsuccessful.");
            }
        }
        if (mysqli_num_rows($servicesResult) > 0) {
            while ($row = mysqli_fetch_array($servicesResult)) {
                $createDeletePathImages = "../../upload_img/" . $row['servicesImg'];
                if (unlink($createDeletePathImages)) {
                    $delServicesQuery = "DELETE FROM services WHERE teacherUid = '$userUid'";
                    $result = mysqli_query($conn, $delServicesQuery) or die("Query Unsuccessful.");
                }
            }
            $delTeacherAccountQuery = "DELETE FROM teacher WHERE teacherUid='$userUid'";
            $delUserAccountQuery = "DELETE FROM users WHERE userUid='$userUid'";
            $run = mysqli_query($conn, $delTeacherAccountQuery);
            $run = mysqli_query($conn, $delUserAccountQuery);
            session_start();
            session_unset();
            session_destroy();
            header("location: ../../index.php?error=none");
            exit();
        }
    } elseif (mysqli_num_rows($servicesResult) > 0) {
        while ($row = mysqli_fetch_array($servicesResult)) {
            $createDeletePathImages = "../../upload_img/" . $row['servicesImg'];
            if (unlink($createDeletePathImages)) {
                $delServicesQuery = "DELETE FROM services WHERE teacherUid = '$userUid'";
                $result = mysqli_query($conn, $delServicesQuery) or die("Query Unsuccessful.");
            }
        }
        $delTeacherAccountQuery = "DELETE FROM teacher WHERE teacherUid='$userUid'";
        $delUserAccountQuery = "DELETE FROM users WHERE userUid='$userUid'";
        $run = mysqli_query($conn, $delTeacherAccountQuery);
        $run = mysqli_query($conn, $delUserAccountQuery);
        session_start();
        session_unset();
        session_destroy();
        header("location: ../../index.php?error=none");
        exit();
    }else {
        $delTeacherAccountQuery = "DELETE FROM teacher WHERE teacherUid='$userUid'";
        $delUserAccountQuery = "DELETE FROM users WHERE userUid='$userUid'";
        $run = mysqli_query($conn, $delTeacherAccountQuery);
        $run = mysqli_query($conn, $delUserAccountQuery);
        session_start();
        session_unset();
        session_destroy();
        header("location: ../../index.php?error=none");
        exit();
    }
} else {
    header("location: ../profile.php");
}