echo '<tr>'; echo "<th>Year:</th>"; echo '<td>' . $year . '</td>'; echo '</tr>'; echo '<tr>'; echo "<th>Type:</th>"; echo '<td>' . $type . '</td>'; echo '</tr>'; echo '<tr>'; echo '<th valign="top">Genre:</th>'; echo '<td>'; $query2 = 'SELECT genre_id FROM video_genre_tb WHERE video_id="' . $id . '"'; $result2 = mysql_query($query2, $db) or die(mysql_error($db)); while ($row2 = mysql_fetch_assoc($result2)) { extract($row2); $genre = get_genre($genre_id); echo $genre; echo '<br>'; } echo '</td>'; echo '</tr>'; echo '<tr>'; echo "<th>Language:</th>"; echo '<td>' . $lang . '</td>'; echo '</tr>'; } mysql_close($db); ?> </table> </body>
} elseif ($_GET['page'] == '2') { //ADD BOOK PAGE echo $PAGE_BASE; echo '<Center>'; echo '<h3>ADD BOOKS</h3>'; echo '<br>'; echo ' <form method="post"> <b>BOOK NAME: </b><input type="text" name="INPUT_BNAME"><br> <br> <b>BOOK AUTHOR: </b><input type="text" name="INPUT_BAUTHOR"><br> <br> <select name="INPUT_BGENRE">'; $OPT = 1; while ($OPT <= 16) { echo '<option value=' . $OPT . '>' . $OPT . ': ' . get_genre($OPT) . '</option>'; $OPT++; } unset($OPT); echo '</select><br> <br> <b>BOOK ISBN: </b><input type="text" name="INPUT_BISBN"><br> <br> <input type="submit" name="BOOK_ADDBTN" value="ADD BOOK"><br> </form> '; //ARRAY OF ALLOWED GENRES $ALLOWED_GENRES = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18); //IF BUTTON PRESSED if (isset($_POST['BOOK_ADDBTN'])) { //CHECK FIELDS
echo '</Center>'; } elseif ($_GET['page'] == '3') { //CHECK IF GET PARAMETERS ARE SET if (!empty($_GET['bookisbn']) or !empty($_GET['bookuniq'])) { //PREPARE QUERY, AND IF GOES WELL, CONTINUE WITH THE QUERY if ($BOOK_INFOQ = $CONN->prepare("SELECT `name`,`author`,`genre`,`uniq`,`isbn` FROM `books` WHERE `uniq`=? OR `isbn`=?;")) { //BIND QUERY PARAMETERS $BOOK_INFOQ->bind_param("si", $_GET['bookuniq'], $_GET['bookisbn']); //EXECUTE QUERY $BOOK_INFOQ->execute(); //BIND QUERY RESULT $BOOK_INFOQ->bind_result($BOOK_NAME, $BOOK_AUTHOR, $BOOK_GENREINT, $BOOK_UNIQ, $BOOK_ISBN); //FETCH RESULTS $BOOK_INFOQ->fetch(); //ENCODE JSON $JSONARRAY = array('book_name' => $BOOK_NAME, 'book_author' => $BOOK_AUTHOR, 'book_genre_num' => $BOOK_GENREINT, 'book_genre' => get_genre($BOOK_GENREINT), 'book_isbn' => $BOOK_ISBN, 'book_uniq' => $BOOK_UNIQ); //ECHO JSON echo json_encode($JSONARRAY); //CLOSE CONNECTION $BOOK_INFOQ->close(); } else { //QUERY ELSE $JSONARRAY = array('book_name' => null, 'book_author' => null, 'book_genre_num' => null, 'book_genre' => null, 'book_isbn' => null, 'book_uniq' => null); echo json_encode($JSONARRAY); } } else { //GET PARAMS ELSE $JSONARRAY = array('book_name' => null, 'book_author' => null, 'book_genre_num' => null, 'book_genre' => null, 'book_isbn' => null, 'book_uniq' => null); echo json_encode($JSONARRAY); } } else {