-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert_rate.php
52 lines (42 loc) · 1.75 KB
/
insert_rate.php
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
<?php
ob_start();
session_start();
$oid = $_GET['oid'];
// echo $oid;
$rate = $_POST['rating'];
// echo $rate;
// connectinon of db
include_once('db_connect.php');
//db connected
$get_rid = "SELECT `r_id` FROM `order_table` WHERE o_id='$oid'";
$queryfire_get_rid = mysqli_query($con, $get_rid);
$get_rid_array = mysqli_fetch_array($queryfire_get_rid);
$rid = $get_rid_array['r_id'];
$get_prev_detail="SELECT * FROM `rating` WHERE r_id='$rid'";
$queryfire_get_prev_detail = mysqli_query($con, $get_prev_detail);
$get_prev_detail_array = mysqli_fetch_array($queryfire_get_prev_detail);
$prev_num = $get_prev_detail_array['rate_num'];
$prev_total = $get_prev_detail_array['total_points'];
// echo $prev_num." ".$prev_total." ";
$new_num = $prev_num+1;
$new_total = $prev_total+$rate;
$new_av = $new_total/$new_num ;
// echo $new_num." ".$new_total." ";
$update_rating = "UPDATE `rating` SET `rate_num`='$new_num',`total_points`='$new_total',`av_rate`='$new_av' WHERE r_id='$rid'";
if($queryfire_update_rating = mysqli_query($con, $update_rating))
{
$update_status = "UPDATE `order_table` SET `stetus`='rated' WHERE o_id='$oid'";
if($queryfire_update_status = mysqli_query($con, $update_status))
{
echo "<script>alert('thanks, for the rating !!!')</script>";
echo "<script>window.open('rate_us.php','_self')</script>";
}else{
echo "<script>alert('some technical error occuring please visit after some time !!')</script>";
echo "<script>window.open('rate_us.php','_self')</script>";
}
}
else{
echo "<script>alert('some technical error occuring please visit after some time !!')</script>";
echo "<script>window.open('rate_us.php','_self')</script>";
}
?>