<header class="headline col-xs-12">
<h2>Add a range of issues</h2>
</header>
<div class="col-xs-12">
<form id="input_select" class="add-form" method="post" action="">
<p>Use the form below to add several issues of one series in consecutive order. To add details like <strong>quantity</strong>, <strong>custom story name</strong>, <strong>custom plot</strong>, and <strong>variant cover</strong> please edit the individual issues after submitting.</p>
<div class="row">
<div class="col-xs-12 col-md-6">
<div class="form-group">
<label for="series_name">Series</label>
<select class="form-control" name="series_id" required>
<option value="" disabled selected>Choose a series</option>
<?php
$listAllSeries = 1;
$comic = new comicSearch();
$comic->seriesList($listAllSeries, NULL, $userID);
while ($row = $comic->series_list_result->fetch_assoc()) {
$list_series_name = $row['series_name'];
$list_series_vol = $row['series_vol'];
$list_series_id = $row['series_id'];
echo '<option value="' . $list_series_id . '">' . $list_series_name . ' (' . $list_series_vol . ')</option>';
}
?>
</select>
</div>
</div>
<div class="col-xs-12 col-md-6">
<div class="form-inline">
<div class="form-group">
<label for="first_issue">First Issue</label>
<input name="first_issue" type="number" pattern="[0-9]*" inputmode="numeric" autocomplete="off" class="form-control" maxlength="3" size="3" />
<?php
require_once 'views/head.php';
$listAllSeries = 1;
$comics = new comicSearch();
$comics->seriesList($listAllSeries);
$dropdown = '<select class="form-control" name="series_name">';
$dropdown .= '<option value="default" selected>Choose a series</option>';
while ($row = $comics->series_list_result->fetch_assoc()) {
$series_id = $row['series_id'];
$series_name = $row['series_name'];
$series_vol = $row['series_vol'];
$dropdown .= '<option value="' . $series_name . '">' . $series_name . ' Vol ' . $series_vol . '</option>';
}
$dropdown .= "</select>";
$last_series_id_query = "select series_id from series ORDER BY series_id DESC LIMIT 1";
// $writer_query = "SELECT writer_name FROM writer_link LEFT JOIN writers ON (writers.writer_id = writer_link.writer_id) WHERE writer_link.comic_id = $_GET[comic_id]";
$last_series_id = mysqli_query($connection, $last_series_id_query);
// $writer = mysqli_query($connection,$writer_query);
if (mysqli_num_rows($last_series_id) > 0) {
while ($row = mysqli_fetch_assoc($last_series_id)) {
$new_series_id = ++$row['series_id'];
}
} else {
echo "0 results.";
}
mysqli_close($connection);
?>
<title>Comic Search :: POW! Comic Book Manager</title>
</head>
<body>
