Relearn/editservicesfunction.inc.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
<?php

function emptyEditInput($servicesTitle, $courseTitle, $servicesDiscription, $servicesStatus)
{
    $result = false;
    if (empty($servicesTitle) || empty($courseTitle) || empty($servicesDiscription) || empty($servicesStatus)) {
        $result = true;
    } else {
        $result = false;
    }
    return $result;
}

function editService($conn, $servicesId, $newImageName, $servicesTitle,  $courseTitle, $servicesDiscription, $servicesStatus, $oldservicesTitle)
{
    $findCourse = "SELECT * FROM services WHERE servicesId = '$servicesId'";
    $result = mysqli_query($conn, $findCourse) or die("Query Unsuccessful.");
    $row = mysqli_fetch_assoc($result);
    $createDeletePath = "../../upload_img/" . $row['servicesImg'];
    if (mysqli_num_rows($result) > 0) {
        if (unlink($createDeletePath)) {
            $editServices = "UPDATE services SET servicesTitle='$servicesTitle', servicesDiscription='$servicesDiscription', courseTitle='$courseTitle', servicesImg='$newImageName', servicesStatus='$servicesStatus' WHERE servicesId= '$servicesId'";
            $result = mysqli_query($conn, $editServices) or die("Query Unsuccessful.");
            $editServices = "UPDATE videos SET servicesTitle='$servicesTitle' WHERE servicesTitle='$oldservicesTitle'";
            $result = mysqli_query($conn, $editServices) or die("Query Unsuccessful.");
            header("location: ../service.php?error=none");
            mysqli_close($conn);
        }
    }
}
function updateService($conn, $servicesId, $servicesTitle,  $courseTitle, $servicesDiscription, $servicesStatus, $oldservicesTitle)
{
    $findCourse = "SELECT * FROM services WHERE servicesId = '$servicesId'";
    $result = mysqli_query($conn, $findCourse) or die("Query Unsuccessful.");
    if (mysqli_num_rows($result) > 0) {
        $editServices = "UPDATE services SET servicesTitle='$servicesTitle', servicesDiscription='$servicesDiscription', courseTitle='$courseTitle', servicesStatus='$servicesStatus' WHERE servicesId= '$servicesId'";
        $result = mysqli_query($conn, $editServices) or die("Query Unsuccessful.");
        $editServices = "UPDATE videos SET servicesTitle='$servicesTitle' WHERE servicesTitle='$oldservicesTitle'";
        $result = mysqli_query($conn, $editServices) or die("Query Unsuccessful.");
        header("location: ../service.php?error=none");
        mysqli_close($conn);
    }
}