Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM vinyl_tracks vt
- INNER JOIN vinyl_keys vk ON vt.mKeyID = vk.mKeyID
- INNER JOIN vinyl_tracks_styles vts ON vt.trackID = vts.trackID
- INNER JOIN vinyl_styles vs ON vts.styleID = vs.styleID
- WHERE vinylID = :vinylID
- SELECT * FROM vinyl_tracks vt
- INNER JOIN vinyl_keys vk ON vt.mKeyID = vk.mKeyID
- WHERE vinylID = :vinylID
- SELECT * FROM vinyl_tracks_styles vts
- RIGHT JOIN vinyl_styles vs ON vts.styleID = vs.styleID
- WHERE vts.trackID = :trackID
- array (size=2)
- 0 =>
- array (size=3)
- 'trackID' => string '868' (length=3)
- 'styleID' => string '8' (length=1)
- 'styleName' => string 'progressive house' (length=17)
- 1 =>
- array (size=3)
- 'trackID' => string '868' (length=3)
- 'styleID' => string '17' (length=2)
- 'styleName' => string 'progressive trance' (length=18)
- SELECT * FROM vinyl_styles ORDER BY styleID ASC
- $trackStylesQuery = $db->prepare("SELECT * FROM vinyl_tracks_styles vts
- RIGHT JOIN vinyl_styles vs ON vts.styleID = vs.styleID
- WHERE vts.trackID = :trackID");
- $trackStylesQuery->bindParam(':trackID', $trow['trackID'], PDO::PARAM_INT);
- $trackStylesQuery->execute();
- $trackStyles = $trackStylesQuery->fetchAll(PDO::FETCH_ASSOC);
- //var_dump($trackStyles);
- $allStylesQuery = $db->prepare("SELECT * FROM vinyl_styles ORDER BY styleID ASC");
- $allStylesQuery->execute();
- $styles = $allStylesQuery->fetchAll(PDO::FETCH_ASSOC);
- $stylesSelector = "<select multiple="multiple" class="form-control form-control-sm stylesSelector" name="styleID[".$trow['trackID']."][]"><option> – </option>";
- foreach($styles as $style) {
- foreach($trackStyles as $trackStyle) {
- if(isset($trackStyle['styleID']) && ($trackStyle['styleID'] == $style['styleID'])) {
- $stylesSelector .= "<option selected="selected" value="".$style['styleID']."">".$style['styleName']."</option>";
- }
- else {
- $stylesSelector .= "<option value="".$style['styleID']."">".$style['styleName']."</option>";
- }
- }
- }
- $stylesSelector .= "</select>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement