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
 

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

//==================================================================
//  relational_db_map_auth_book.php -- Author to Book Mapping Table
//  11/11/2024
//==================================================================

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

session_name("rdb_books");

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

// 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
//==================================================================

// ====== open dB
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'];
}

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

// Now display data
?>
<!-- Links to other tables pages -->
<ul>
    <li>
        <a href="relational_db_authors.php">Authors</a>
    </li>
    <li>
        <a href="relational_db_books.php">Books</a>
    </li>
    <li>
        <a href="relational_db_assign_auth_book.php">Assign Author to Books</a>
    </li>
</ul>

<br>

<!--Now display 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');
?>