-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert.php
116 lines (102 loc) · 3.69 KB
/
insert.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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<!Doctype html>
<html>
<head>
<title>Insert New Songs</title>
</head>
<body>
<?php
include('config/dbConfig.php');
$tableName = "songs";
// parse post data & submit to database
if(isset($_POST['add_user']))
{
$sql = "INSERT INTO $tableName (title, length1, length2, songkey, jamkey, song_quality, jam_quality, splittable) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("siissssi", $_POST['title'], $_POST['length1'], $_POST['length2'],
$_POST['songkey'], $_POST['jamkey'], $_POST['song_quality'], $_POST['jam_quality'], $_POST['splittable']);
$stmt->execute();
echo "Song entered successfully";
$stmt->close();
$conn->close();
}
?>
<form method="post">
<tr>
<td>Title: </td>
<td><input type="text" name="title"></td>
</tr>
<br>
<tr>
<td>Length 1 (approx mins before jam): </td>
<td><input type="number" min=0 name="length1"> </td>
</tr><br>
<tr>
<td>Length 2 (approx mins before jam): </td>
<td><input type="number" min=0 name="length2"> </td>
</tr>
<br>
<tr>
<td>Song Key: </td>
<td><select name="songkey">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
<option value="E">E</option>
<option value="F">F</option>
<option value="G">G</option>
<option value="Ab">Ab</option>
<option value="Bb">Bb</option>
<option value="Db">Db</option>
<option value="Eb">Eb</option>
<option value="Gb">Gb</option>
</select></td>
</tr>
<tr>
<td>Major / Minor: </td>
<td><select name="song_quality">
<option value="major">Major</option>
<option value="minor">Minor</option>
</select></td>
</tr>
<br>
<tr>
<td>Jam Key: </td>
<td><select name="jamkey">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
<option value="E">E</option>
<option value="F">F</option>
<option value="G">G</option>
<option value="Ab">Ab</option>
<option value="Bb">Bb</option>
<option value="Db">Db</option>
<option value="Eb">Eb</option>
<option value="Gb">Gb</option>
</select></td>
</tr>
<tr>
<td>Major / Minor: </td>
<td><select name="jam_quality">
<option value="major">Major</option>
<option value="minor">Minor</option>
</select></td>
</tr> <br>
<tr>
<td>Splittable? </td>
<td><select name = "splittable">
<option value=1>Yes</option>
<option value=0>No</option>
</select>
</td>
</tr>
<br>
<tr>
<td></td>
<td><input type="submit" name="add_user"></td>
</tr>
</form>
</body>
</html>