-
Notifications
You must be signed in to change notification settings - Fork 2
/
createreview.php
41 lines (40 loc) · 1.2 KB
/
createreview.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
<?php
include('header.php');
include ('includes/dbconn.php');
$conn = oci_connect($dbUserName, $dbPassword, $db);
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
?>
<?php
$username=$_SESSION['username'];
$vote = $_POST['vote'];
$type = $_POST['type'];
$summary = $_POST['summary'];
$review = $_POST['review'];
if($type=="movie") {
$movieid=$_POST['movieid'];
$insert_moviereview = oci_execute(oci_parse($conn, "BEGIN INSERTMOVIEREVIEW(".$vote.",'".$summary."','".$review."','".$username."',".$movieid."); END;"));
if($insert_moviereview) {
echo "<span style='color:green'>Review Created</span>";
}
else {
echo "<span style='color:red'>Review Creation failed</span>";
}
}
else {
$theatreid=$_POST['theatreid'];
$insert_theatrereview = oci_execute(oci_parse($conn, "BEGIN INSERTTHEATREREVIEW(".$vote.",'".$summary."','".$review."','".$username."',".$theatreid."); END;"));
if($insert_theatrereview) {
echo "<span style='color:green'>Review Created</span>";
}
else {
echo "<span style='color:red'>Review Creation failed</span>";
}
}
?>
<?php
include('footer.php');
oci_close($conn);
?>