loops - Is it possible to wrap looping PHP output in tags? -


everyone. i'm having bit of php conundrum here , couldn't find answer existed. see, i'm working on project have take classmate's discography website , revamp php, where, instead of having album covers , tracklists hard-coded in, query database them. problem have keep general style of site intact, , i'm having trouble doing that. styles depend on having album cover, name, , tracklists in div tags, , style he's got in place achieved through both bootstrap , own, custom css stylesheet.

before start ramble, question is: there way wrap looping output in html tags? need album cover, album name, , tracklists in div tag, tracklists loop. here code have in place query database:

<?php require ('mysqli_connect.php');  // connect database server  mysql_connect("localhost", "admin", "instructor") or die(mysql_error());  // select database  mysql_select_db("phprediscography") or die(mysql_error());  // sql query  $q = "select distinct albums.albumname, albums.albumid, albums.coverart     albums     join tracks     on albums.albumid=tracks.albumid"; //select unique results database $t = "select trackname tracks albumid = 1"; $b = "select trackname tracks albumid = 2"; $n = "select trackname tracks albumid = 3"; $r = "select trackname tracks albumid = 4"; $result = mysqli_query($dbcon, $q); $result1 = mysqli_query($dbcon, $t); $result2 = mysqli_query($dbcon, $b); $result3 = mysqli_query($dbcon, $n); $result4 = mysqli_query($dbcon, $r);  while ($row = mysqli_fetch_array($result, mysqli_assoc)) { //loop through database each album     echo '<img class="img-responsive" src=' . $row['coverart'] . '>' . '<br />';     echo '<h2>' . $row['albumname'] . "</h2><br />";     if ($row['albumid'] == 1) {         foreach($result1 $row1) { //loop through tracks , output page             echo '<p>' . $row1['trackname'] . '</p>';         }     }      if ($row['albumid'] == 2) {         foreach($result2 $row2) { //loop through tracks , output page             echo '<p>' . $row2['trackname'] . '</p>';         }     }      if ($row['albumid'] == 3) {         foreach($result3 $row3) { //loop through tracks , output page             echo '<p>' . $row3['trackname'] . '</p>';         }     }      if ($row['albumid'] == 4) {         foreach($result4 $row4) { //loop through tracks , output page             echo '<p>' . $row4['trackname'] . '</p>';         }     } }  // close database connection  mysql_close(); ?> 

if need post else, let me know, first-ever question i'm kind of feeling out.

by doing $t = "select trackname tracks albumid = #"; , if($row['albumid']==#) still hardcoding similar friend. 1 query, join tracks. when looping, group albumname -

<?php require('mysqli_connect.php');  // sql query $q = "select albums.albumname, albums.albumid, albums.coverart, tracks.trackname albums join tracks on albums.albumid=tracks.albumid"; $result = mysqli_query($dbcon, $q);  $current_albumid = ""; //create current albumid var used below.  while($row = mysqli_fetch_array($result, mysqli_assoc)){//loop through database each album     if($row['albumid'] != $current_albumid){        echo '<img class="img-responsive" src='.$row['coverart'] . '>' . '<br />';        echo '<h2>' . $row['albumname'] . "</h2><br />";        $current_albumid = $row['albumid']; // set current albumid albumid    }    echo '<p>' . $row['trackname'] . '</p>'; } ?> 

Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -