-
Notifications
You must be signed in to change notification settings - Fork 0
/
submit_process.php
65 lines (59 loc) · 1.37 KB
/
submit_process.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
53
54
55
56
57
58
59
60
61
62
63
64
65
<?php
/*
echo $_POST['flavor'];
echo $_POST['body'];
echo $_POST['acidity'];
echo $_POST['roastlevel'];
echo $_POST['aroma'];
echo $_POST['aftertaste'];
echo $_POST['balance'];
echo $_POST['uniformity'];
echo $_POST['sweetness'];
echo $_POST['cleanup'];
echo $_POST['defect'];
*/
session_start();
$flavor = htmlspecialchars( $_POST['flavor'] );
$body = htmlspecialchars( $_POST['body'] );
$acidity = htmlspecialchars($_POST['acidity']);
$roastlevel = htmlspecialchars($_POST['roastlevel']);
$aroma = htmlspecialchars($_POST['aroma']);
$aftertaste = htmlspecialchars($_POST['aftertaste']);
$balance = htmlspecialchars($_POST['balance']);
$uniformity = htmlspecialchars( $_POST['uniformity'] );
$sweetness = htmlspecialchars( $_POST['sweetness'] );
$cleanup = htmlspecialchars( $_POST['cleanup'] );
$defect = htmlspecialchars( $_POST['defect'] );
$conn = mysqli_connect("localhost", "root", "11182917", "cupping");
$url = 'http://127.0.0.1:8080/cupping/index.php';
mysqli_query($conn, "
INSERT INTO taste (
flavor,
body,
acidity,
roastlevel,
aroma,
aftertaste,
balance,
uniformity,
sweetness,
cleanup,
defect,
created
) VALUES (
$flavor,
$body,
$acidity,
$roastlevel,
$aroma,
$aftertaste,
$balance,
$uniformity,
$sweetness,
$cleanup,
$defect,
NOW()
)");
$_SESSION['saved'] = true;
header('Location: '.$url );
?>