<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>