FoodTP/rate.php at main · MokuMoki/FoodTP · 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
<?php
include("session_check.php");
include 'conn.php';

$type = $_POST['type'];
$rated = $_POST['rated'];
$rating = $_POST['rating'];
$userID = $_SESSION['userid'];

switch ($type) {
    case 1:
        $orderID = $_POST['val'];
        break;
    case 2:
        $RuserID = $_POST['val'];
        break;
    case 3:
        $DuserID = $_POST['val'];
        break;
}

switch ($rated) {
    case 1:
        switch ($type) {
            case 1:
                $rateSQL = "UPDATE COrderDetails SET ORating = $rating WHERE OrderID = '$orderID'";
                break;
            case 2:
                $rateSQL = "UPDATE CRateR SET CRRating = $rating WHERE CUserID = '$userID' AND RUserID = '$RuserID'";
                break;
            case 3:
                $rateSQL = "UPDATE CRateD SET CDRating = $rating WHERE CUserID = '$userID' AND DUserID = '$DuserID'";
                break;
        }
        break;
    case 0:
        switch ($type) {
            case 1:
                $rateSQL = "UPDATE COrderDetails SET ORating = $rating WHERE OrderID = '$orderID'";
                break;
            case 2:
                $rateSQL = "INSERT INTO CRateR (CUserID, RUserID, CRRating) VALUES ('$userID', '$RuserID', $rating)";
                break;
            case 3:
                $rateSQL = "INSERT INTO CRateD (CUserID, DUserID, CDRating) VALUES ('$userID', '$DuserID', $rating)";
                break;
        }
        break;
}

if(mysqli_query($con, $rateSQL)){
    if($rating == 1){
        echo 'Rated 1 star.';
    } else {
        echo 'Rated '.$rating.' stars.';
    }
} else {
    echo 'Error in giving rating.';
}
mysqli_close($con);