<h2 class="panel-title">Producers</h2> </div> </a> <div class="panel-body panel-collapse collapse" id="producer-panel"> <table class="table"> <tbody> <?php foreach ($query_result as $row) { ?> <tr> <td><a href="/Database_Website/php/person.php?q=<?php echo $row['id']; ?> "> <?php echo format_person_name($row); ?> </a></td> </tr> <?php } ?> </tbody> </table> </div> </div> <?php } ?>
function display_results() { $search = $_GET['q']; $results = get_person_results($search); //<div class="well"> //<?php echo $querystr; ? > //</div> // display person results ?> <div class="container"> <h3 style="display:inline-block">People</h3> <table class="table table-striped adv-table-results" cellspacing="0" width="100%"> <thead> <tr> <th>Person</th> <th>Country</th> <th>DOB</th> </tr> </thead> <tbody> <?php foreach ($results as $row) { ?> <tr> <td style="vertical-align:middle;"> <?php echo '<a href="/Database_Website/php/person.php?q=' . $row['id'] . '">'; if (!$row['image']) { echo '<img class="center-block" src="/Database_Website/images/nullicon.png" style="display:inline; margin-right: 4px;">'; } else { echo '<img class="center-block" src="data:image/jpeg;base64,' . base64_encode($row['image']) . '" height="40" width="30" style="display:inline; margin-right: 7px;">'; } echo format_person_name($row); echo '</a>'; ?> </td> <td style="vertical-align:middle;"><?php echo $row['Country_Of_Origin']; ?> </td> <td style="vertical-align:middle;"><?php echo $row['DOB']; ?> </td> </tr> <?php } ?> </tbody> </table> </div> <?php $results = get_movie_results($search); // display movie results ?> <div class="container"> <h3 style="display:inline-block">Movies</h3> <table class="table table-striped adv-table-results" cellspacing="0" width="100%"> <thead> <tr> <th>Movie</th> <th>Country</th> <th>Genre</th> <th>Year</th> <th>Parental Rating</th> <th>Runtime</th> </tr> </thead> <tbody> <?php foreach ($results as $row) { ?> <tr> <td style="vertical-align:middle;"> <?php echo '<a href="/Database_Website/php/movie.php?q=' . $row['id'] . '">'; if (!$row['image']) { echo '<img class="center-block" src="/Database_Website/images/nullicon.png" style="display:inline; margin-right: 4px;">'; } else { echo '<img class="center-block" src="data:image/jpeg;base64,' . base64_encode($row['image']) . '" height="40" width="30" style="display:inline; margin-right: 7px;">'; } echo $row['Title']; echo '</a>'; ?> </td> <td style="vertical-align:middle;"><?php echo $row['Country']; ?> </td> <td style="vertical-align:middle;"><?php echo $row['Genre']; ?> </td> <td style="vertical-align:middle;"><?php echo substr($row['Date'], 0, 4); ?> </td> <td style="vertical-align:middle;"> <?php echo '<img class="center-block" src=' . rating_logo($row['Parental Rating']) . ' height="15">'; echo '<span hidden>' . $row['Parental Rating'] . '</span>'; ?> </td> <td style="vertical-align:middle;"><?php echo $row['Runtime'] . ' minutes'; ?> </td> </tr> <?php } ?> </tbody> </table> </div> <?php }
<?php } ?> </p> </div> </div> </div> </div> <?php if ($favupdate) { ?> <div class="alert alert-warning alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button> <strong><?php echo format_person_name($person); ?> </strong><?php echo ' ' . $favmsg; ?> </div> <?php } ?> <?php if (is_admin()) { ?> <div class="panel panel-default"> <div class="panel-body">