Example #1
0
    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 {