WebAssignment/content.php at main · Thamashwerago/WebAssignment · 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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
<?php
session_start();

include 'dbconn.php';

if (isset($_SESSION["placeid"])) {
    $placeid = $_SESSION["placeid"];
} else {
    $placeid = 0;
}

if (isset($_SESSION["userid"])) {
    $userid = $_SESSION["userid"];
} else {
    $userid = 0;
}

if (isset($_POST['place'])) {

    $sql = "SELECT placename,description,thumbnail FROM places WHERE placeId='$placeid'";

    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        $places = mysqli_fetch_all($result, MYSQLI_ASSOC);
        echo json_encode($places);
    } else {
        echo false;
    }
}

if (isset($_POST['images'])) {

    $sql = "SELECT imgName FROM placeimg WHERE placeId='$placeid'";

    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        $places = mysqli_fetch_all($result, MYSQLI_ASSOC);
        echo json_encode($places);
    } else {
        echo false;
    }
}

if (isset($_POST['record'])) {
    $sql = "SELECT views FROM places WHERE placeId='$placeid'";
    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        $row = mysqli_fetch_assoc($result);
        $views = $row["views"] + 1;
        $query = "UPDATE places SET views='$views' WHERE placeId='$placeid'";
        if (mysqli_query($conn, $query)) {
            echo true;
        } else {
            echo false;
        }
    } else {
        echo false;
    }
}
if (isset($_POST['comment'])) {
    $sql = "SELECT comment FROM comments WHERE placeId='$placeid' LIMIT 20";

    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        $places = mysqli_fetch_all($result, MYSQLI_ASSOC);
        echo json_encode($places);
    } else {
        echo false;
    }
}

if (isset($_POST['addcomment'])) {
    $comment = $_POST['addcomment'];

    $sql = "INSERT INTO comments (userId,placeId,comment) VALUES('$userid','$placeid','$comment')";
    if (mysqli_query($conn, $sql)) {
        echo true;
    } else {
        echo false;
    }
}

if (isset($_POST['favourite'])) {

    $sql = "SELECT * FROM favplace WHERE userId='$userid' AND placeId='$placeid'";

    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        echo true;
    } else {
        echo false;
    }
}

if (isset($_POST['like'])) {

    $sql = "SELECT * FROM likeplace WHERE userId='$userid' AND placeId='$placeid'";

    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        echo true;
    } else {
        echo false;
    }
}

if (isset($_POST['setfavourite'])) {
    $sql = "SELECT * FROM favplace WHERE userId='$userid' AND placeId='$placeid'";
    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        $query = "DELETE FROM favplace WHERE userId='$userid' AND placeId='$placeid'";
        if (mysqli_query($conn, $query)) {
            echo false;
        } else {
            echo true;
        }
    } else {
        $query = "INSERT INTO favplace (userId,placeId) VALUES('$userid','$placeid')";
        if (mysqli_query($conn, $query)) {
            echo true;
        } else {
            echo false;
        }
    }
}

if (isset($_POST['setlike'])) {
    $sql = "SELECT * FROM likeplace WHERE userId='$userid' AND placeId='$placeid'";
    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) > 0) {
        $sql = "SELECT likes FROM places WHERE placeId='$placeid'";
        $result = mysqli_query($conn, $sql);
        $row = mysqli_fetch_assoc($result);
        $likes=$row["likes"]-1;
        $sql="UPDATE places SET likes='$likes' WHERE placeId='$placeid";
        mysqli_query($conn, $sql);
        $query = "DELETE FROM likeplace WHERE userId='$userid' AND placeId='$placeid'";
        if (mysqli_query($conn, $query)) {
            echo false;
        } else {
            echo true;
        }
    } else {
        $sql = "SELECT likes FROM places WHERE placeId='$placeid'";
        $result = mysqli_query($conn, $sql);
        $row = mysqli_fetch_assoc($result);
        $likes=$row["likes"]+1;
        $sql="UPDATE places SET likes='$likes' WHERE placeId='$placeid";
        mysqli_query($conn, $sql);
        $query = "INSERT INTO likeplace (userId,placeId) VALUES('$userid','$placeid')";
        if (mysqli_query($conn, $query)) {
            echo true;
        } else {
            echo false;
        }
    }
}
mysqli_close($conn);