<th>Description</th> <td><textarea name="descr" cols="40" rows="5"><?php echo $row['book_descr']; ?> </textarea> </tr> <tr> <th>Price</th> <td><input type="text" name="price" value="<?php echo $row['book_price']; ?> " required></td> </tr> <tr> <th>Publisher</th> <td><input type="text" name="publisher" value="<?php echo getPubName($conn, $row['publisherid']); ?> " required></td> </tr> </table> <input type="submit" name="save_change" value="Change" class="btn btn-primary"> <input type="reset" value="cancel" class="btn btn-default"> </form> <br/> <a href="admin_book.php" class="btn btn-success">Confirm</a> <?php if (isset($conn)) { mysqli_close($conn); } require "./template/footer.php";
<?php session_start(); require_once "./functions/database_functions.php"; // get pubid if (isset($_GET['pubid'])) { $pubid = $_GET['pubid']; } else { echo "Wrong query! Check again!"; exit; } // connect database $conn = db_connect(); $pubName = getPubName($conn, $pubid); $query = "SELECT book_isbn, book_title, book_image FROM books WHERE publisherid = '{$pubid}'"; $result = mysqli_query($conn, $query); if (!$result) { echo "Can't retrieve data " . mysqli_error($conn); exit; } if (mysqli_num_rows($result) == 0) { echo "Empty books ! Please wait until new books coming!"; exit; } $title = "Books Per Publisher"; require "./template/header.php"; ?> <p class="lead"><a href="publisher_list.php">Publishers</a> > <?php echo $pubName; ?> </p>