Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
369
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.05 KB | None | 0 0
  1. SELECT * FROM vinyl_tracks vt
  2. INNER JOIN vinyl_keys vk ON vt.mKeyID = vk.mKeyID
  3. INNER JOIN vinyl_tracks_styles vts ON vt.trackID = vts.trackID
  4. INNER JOIN vinyl_styles vs ON vts.styleID = vs.styleID
  5. WHERE vinylID = :vinylID
  6.  
  7. SELECT * FROM vinyl_tracks vt
  8. INNER JOIN vinyl_keys vk ON vt.mKeyID = vk.mKeyID
  9. WHERE vinylID = :vinylID
  10.  
  11. SELECT * FROM vinyl_tracks_styles vts
  12. RIGHT JOIN vinyl_styles vs ON vts.styleID = vs.styleID
  13. WHERE vts.trackID = :trackID
  14.  
  15. array (size=2)
  16. 0 =>
  17. array (size=3)
  18. 'trackID' => string '868' (length=3)
  19. 'styleID' => string '8' (length=1)
  20. 'styleName' => string 'progressive house' (length=17)
  21. 1 =>
  22. array (size=3)
  23. 'trackID' => string '868' (length=3)
  24. 'styleID' => string '17' (length=2)
  25. 'styleName' => string 'progressive trance' (length=18)
  26.  
  27. SELECT * FROM vinyl_styles ORDER BY styleID ASC
  28.  
  29. $trackStylesQuery = $db->prepare("SELECT * FROM vinyl_tracks_styles vts
  30. RIGHT JOIN vinyl_styles vs ON vts.styleID = vs.styleID
  31. WHERE vts.trackID = :trackID");
  32. $trackStylesQuery->bindParam(':trackID', $trow['trackID'], PDO::PARAM_INT);
  33. $trackStylesQuery->execute();
  34. $trackStyles = $trackStylesQuery->fetchAll(PDO::FETCH_ASSOC);
  35. //var_dump($trackStyles);
  36.  
  37. $allStylesQuery = $db->prepare("SELECT * FROM vinyl_styles ORDER BY styleID ASC");
  38. $allStylesQuery->execute();
  39. $styles = $allStylesQuery->fetchAll(PDO::FETCH_ASSOC);
  40. $stylesSelector = "<select multiple="multiple" class="form-control form-control-sm stylesSelector" name="styleID[".$trow['trackID']."][]"><option> &ndash; </option>";
  41. foreach($styles as $style) {
  42. foreach($trackStyles as $trackStyle) {
  43. if(isset($trackStyle['styleID']) && ($trackStyle['styleID'] == $style['styleID'])) {
  44. $stylesSelector .= "<option selected="selected" value="".$style['styleID']."">".$style['styleName']."</option>";
  45. }
  46. else {
  47. $stylesSelector .= "<option value="".$style['styleID']."">".$style['styleName']."</option>";
  48. }
  49. }
  50. }
  51. $stylesSelector .= "</select>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement