?>
<h4><strong>Bands:</strong></h4>
<ul class="covers bands modal-list">
<!-- // Loop through list from db -->
<?php
for ($i = 0; $i < sizeof($bandList); $i++) {
?>
<li>
<a class="overlay" data-toggle="modal" data-dismiss="modal" href="view/band.php?id=<?php
echo $bandList[$i]['band_id'];
?>
" data-target="#bandModal">
<div class="cover">
<img src="<?php
echo WEB::_image($bandList[$i]['band_cover']);
?>
" alt="<?php
echo $bandList[$i]['band_cover'] === '' ? '' : $bandList[$i]['band_name'];
?>
" class="<?php
echo $bandList[$i]['band_cover'] === '' ? 'no-image' : '';
?>
" />
<div class="desc">
<p class="view_more">More Details</p>
<p class="big_name"><?php
echo $bandList[$i]['band_name'];
?>
</p>
</div>
echo $s->getQuery();
?>
</h3>
<ul class="covers">
<!-- // Loop through list from db -->
<?php
for ($i = 0; $i < sizeof($recordList); $i++) {
?>
<li>
<a class="overlay" data-toggle="modal" href="view/record.php?id=<?php
echo $recordList[$i]['record_id'];
?>
" data-target="#recordModal">
<div class="cover">
<img src="<?php
echo WEB::_image($recordList[$i]['record_artwork']);
?>
" alt="<?php
echo $recordList[$i]['record_name'];
?>
" />
<div class="desc">
<p class="view_more">More Details</p>
<p class="small_name"><?php
echo $recordList[$i]['band_name'];
?>
</p>
<p class="big_name"><?php
echo $recordList[$i]['record_name'];
?>
</p>
<div class="col-lg-9 col-md-11">
<h2>Your Performers:</h2>
<ul class="covers">
<!-- // Loop through list from db -->
<?php
for ($i = 0; $i < sizeof($performerList); $i++) {
?>
<li>
<a class="overlay" data-toggle="modal" href="view/performer.php?id=<?php
echo $performerList[$i]['performer_id'];
?>
" data-target="#performerModal">
<div class="cover">
<img src="<?php
echo WEB::_image($performerList[$i]['performer_cover']);
?>
" alt="<?php
echo $performerList[$i]['performer_cover'] === '' ? '' : $performerList[$i]['performer_name'];
?>
" class="<?php
echo $performerList[$i]['performer_cover'] === '' ? 'no-image' : '';
?>
" />
<div class="desc">
<p class="view_more">More Details</p>
<p class="big_name"><?php
echo $performerList[$i]['performer_name'];
?>
</p>
</div>
public function getRecordAsListWithApi()
{
$list = array();
$query = "SELECT *\n\t \t\t\tFROM record\n\t\t\t\tJOIN band\n\t\t\t\tJOIN genre\n\t\t\t\tON record.band_id=band.band_id AND record.genre_id = genre.genre_id\n\t\t\t\tORDER BY record.record_id DESC LIMIT " . NUM_OF_RESULTS;
$result = mysqli_query(parent::getDb(), $query);
if ($result) {
while ($data = $result->fetch_assoc()) {
$single_record = array();
$single_record["record_id"] = $data["record_id"];
$single_record["name"] = $data["record_name"];
$single_record["band"] = $data["band_name"];
// Comes from Band
$single_record["current_value"] = $data["record_current_value"];
$single_record["vinyl_size"] = $data["record_length"];
$single_record["original_price"] = $data["record_original_price"];
$single_record["release_date"] = $data["record_release_date"];
$single_record["description"] = $data["record_description"];
$single_record["album_condition"] = $data["record_condition"];
$single_record["genre"] = $data["genre_name"];
$single_record["artwork_image"] = WEB::_image($data["record_artwork"]);
$list[] = $single_record;
}
}
return $list;
}
<strong><?php
echo $r->getRecordName();
?>
</strong> by
<a data-toggle="modal" data-dismiss="modal" href="view/band.php?id=<?php
echo $r->getBandId();
?>
" data-target="#bandModal"><?php
echo $r->getBandName();
?>
</a>
</h4>
</div>
<div class="modal-record-artwork">
<img class="modal-artwork" src="<?php
echo WEB::_image($r->getRecordArtwork());
?>
" alt="<?php
echo $r->getRecordName();
?>
">
</div>
<div class="modal-body record-view">
<p><?php
echo $r->getRecordDescription();
?>
</p>
<table class="table">
<thead>
<tr>
