-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathsleeve_empty.php
More file actions
41 lines (34 loc) · 1.17 KB
/
sleeve_empty.php
File metadata and controls
41 lines (34 loc) · 1.17 KB
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_once("login_session.php");
include_once('directory.php');
// Blank rows for form
if(session_status() != PHP_SESSION_NONE && $_SESSION["loggedIn"] && isset($_POST['sleeve_list'])) {
sleeve_list_dropdown();
}
function sleeve_list($selected_id = NULL) {
$db = new PDO('sqlite:' . dir_path() . '/data/games_db.sqlite');
$sleeves = $db->query("SELECT Sleeve.Id, Sleeve.CompanyID, Sleeve.SleeveName, SleeveCompany.Name
FROM Sleeve
INNER JOIN SleeveCompany ON Sleeve.CompanyID = SleeveCompany.Id" );
?>
<select name="sleeve[]">
<?php
foreach($sleeves as $sleeve) {
?>
<option value="<?php echo $sleeve['Id']; ?>" <?php if($sleeve['Id'] === $selected_id) echo 'selected="selected"'; ?>><?php echo $sleeve['Name'] . ' - ' . $sleeve['SleeveName'] ?></option>
<?php
}
?>
</select>
<?php
}
function sleeve_list_dropdown() {
?>
<div class="row">
<div class="table-cell"><input type="number" name="nb[]" value="0" step="1"></div>
<div class="table-cell"><input type="number" name="quantity[]" value="0" step="1"></div>
<div class="table-cell"><?php sleeve_list(); ?></div>
<div class="table-cell"><span class="add">+</span></div>
</div>
<?php
}