Author to Book TABLE

AUTHOR TO BOOK TABLE
Author ID	Book ID
2	7
1	3
1	4
1	5
49	79
49	80
49	81
49	82
50	83
50	84
50	85
51	86
51	87
51	88
52	89
52	90
52	91
53	92
53	93
53	94
54	95
54	96
54	97
55	98
55	99
55	100
56	101
56	102
56	103
57	104
57	105
57	106

Note: Only the ID's of the Authors and ID's of the Books are in this table. This is a simple method to track the assignments of authors to books and vise-versa. This allows the Author and Book tables to be used by way of their specific ID's but does not require each table to show their relationships.

---

CODE FOLLOWS

<?php
    //==================================================================
    //  author-book-table.php -- Show Author to Book Table
    //==================================================================

    // code
    if (session_id() == '')
        {
        session_start();
        }

    session_name("sperlt");

    include('includes/functions.php');    // standard functions

    // init vars and arrays
    $self = basename($_SERVER['SCRIPT_NAME']);
    $author_book_table = 'author_book';

    // author_book arrays
    $authorID = array();
    $bookID = array();

    $con = '';

    //==================================================================
    // Pull in all author to book records
    //==================================================================

    include('includes/open-db.php');

    $query = "SELECT * FROM $author_book_table ";
    $comment = "Could not get $author_book_table records: $query";
    $result = mysqli_query($con, $query) or die(report($comment, mysqli_error($con), __LINE__, __FILE__));

    while ($row = mysqli_fetch_array($result))
        {
        $authorID[] = $row['author_id'];
        $bookID[] = $row['book_id'];
        }

    include('includes/close-db.php');    //====== close dB
    include('includes/header.php');

    // Now show data
?>

    <h2 class="center">Author to Book TABLE</h2>

    <table class="full">
        <tr>
            <th colspan=4 class="header1">
                AUTHOR TO BOOK TABLE
            </th>
        </tr>
        <tr class="header2 center">
            <th>Author ID</th>
            <th>Book ID</th>
        </tr>

        <?php

            $i = 0;
            // go through either of the author arrays (i.e., $author_first or $author_last)
            foreach ($authorID as $key => $value)
                {
                ?>

                    <tr class="row<?php echo(++$i & 1); ?>">
                        <td class="w30 center">
                            <?php echo($authorID[$key]); ?>
                        </td>
                        <td class="w30 center">
                            <?php echo($bookID[$key]); ?>
                        </td>
                    </tr>

                    <?php
                }
        ?>

    </table>

    <div class="clear">
        &nbsp;
    </div>

    <p>
        Note: Only the ID's of the Authors and ID's of the Books are in this table. This is a simple method to track
        the assignments of authors to books and vise-versa. This allows the Author and Book tables to be used by way of
        their specific ID's but does not require each table to show their relationships.
    </p>

<?php
    include('includes/footer.php');
?>

---