?> <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>