BigDataApplication/Search_back.php at main · ksy990628/BigDataApplication · 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
<?php
session_start();
$prevPage = $_SERVER['HTTP_REFERER'];   // prevPage 변수에 이전 페이지 변수를 저장함
$conn = mysqli_connect('localhost', 'team09', 'team09', 'team09');
mysqli_query($conn, "set session character_set_connection=utf8;");
mysqli_query($conn, "set session character_set_results=utf8;");
mysqli_query($conn, "set session character_set_client=utf8;");

$cafe_id = $_POST['cafe_id'];
$query="select * from rating where cafe_id = '$cafe_id'";
$result=mysqli_query($conn,$query);
$row=mysqli_fetch_array($result);
$rating_num = $row['rating_num'];
$rating_sum = $row['rating_sum'];
$rating_one = $row['rating_one'];
$rating_two = $row['rating_two'];
$rating_three = $row['rating_three'];
$rating_four = $row['rating_four'];
$rating_five = $row['rating_five'];

if($_POST['star_value'] == 1){
    $rating_num = $rating_num + 1;
    $rating_sum = $rating_sum + 1;
    $rating_one = $rating_one + 1;
}elseif($_POST['star_value'] == 2){
    $rating_num = $rating_num + 1;
    $rating_sum = $rating_sum + 2;
    $rating_two = $rating_two + 1;
}elseif($_POST['star_value'] == 3){
    $rating_num = $rating_num + 1;
    $rating_sum = $rating_sum + 3;
    $rating_three = $rating_three + 1;
}elseif($_POST['star_value'] == 4){
    $rating_num = $rating_num + 1;
    $rating_sum = $rating_sum + 4;
    $rating_four = $rating_four + 1;
}elseif($_POST['star_value'] == 5){
    $rating_num = $rating_num + 1;
    $rating_sum = $rating_sum + 5;
    $rating_five = $rating_five + 1;
}

$query2 = "UPDATE rating SET cafe_id = '$cafe_id', rating_num = '$rating_num',
rating_sum = '$rating_sum', rating_one = '$rating_one', rating_two = '$rating_two',
rating_three = '$rating_three', rating_four = '$rating_four', rating_five = '$rating_five'
WHERE cafe_id = '$cafe_id';";

mysqli_query($conn, $query2);
$conn->close();

header('location:'.$prevPage);

?>