• Books Table
• Authors Table
• Author to Book Table
• Assign Author to Book

Author to Book TABLE

AUTHOR TO BOOK TABLE
Author ID	Book ID
17	3
17	12
17	26
17	32
25	23
25	24
25	25
25	26
2	7
1	3
1	4
1	5
30	33
30	34
24	18
12	12
31	35
31	36
31	37
32	38
32	39
36	46
36	47
36	48
37	49
37	50
37	51
38	35
38	37
38	43
20	3
39	52
39	53
39	54
40	55
40	56
40	57
41	58
41	59
41	60
42	61
42	62
42	63
43	64
43	65
43	66
44	67
44	68
44	69
45	70
45	71
45	72
46	73
46	74
46	75
47	76
47	77
47	78

---

CODE FOLLOWS

<?php

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

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

    session_name("fragelk");

    include('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('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('close-db.php');    //====== close dB
    include('includes/header.php');

    // Now show data
?>

    <ul>
        <li>
            <a href="relational-books.php">Books Table</a>
        </li>
        <li>
            <a href="relational-authors.php">Authors Table</a>
        </li>
        <li>
            <a href="author-book-table.php">Author to Book Table</a>
        </li>
        <li>
            <a href="assign-author.php">Assign Author to Book</a>
        </li>
    </ul>

    <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>
<?php
include('includes/footer.php');
?>

---