Posted By

Florian on 08/23/09


Tagged


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

helloworlder
umang_nine


page


 / Published in: PHP
 

  1. <?php
  2. require_once("connect.php");
  3. ?>
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head>
  7. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  8. <link href="style.css" rel="stylesheet" type="text/css" />
  9. <script type="text/javascript" src="jquery-1.3.1.min.js"></script>
  10. <script type="text/javascript" src="jquery.tablesorter.min.js"></script>
  11. <script type="text/javascript" src="script.js"></script>
  12. <title>1DEV3 - Florian Vanthuyne - myTunes - DWD</title>
  13. </head>
  14. <body>
  15. <div id="container">
  16. <h1><span><a name="top" id="top"></a>myTunes</span></h1>
  17. <div id="login">
  18. <form action="login.php" method="post" title="login_form">
  19. <input type="text" maxlength="30" title="user_name" tabindex="1" value="username" />
  20. <input type="password" maxlength="30" title="password" tabindex="2" value="password" />
  21. <input type="button" title="login_btn" tabindex="3" value="Go!" />
  22. <input type="button" title="register_btn" tabindex="3" value="Sign me up dawg!" />
  23. </form>
  24. </div>
  25. <div id="order">
  26.  
  27. </div>
  28. <div id="songs">
  29. <table width="750" title="song_list" id="songList">
  30. <thead><tr><th>ADD</th><th>TITEL</th><th>DUUR</th><th>GENRE</th><th>GROEP</th></tr></thead>
  31. <tbody>
  32. <?php
  33. $db = getConnection();
  34. $query = "SELECT tblsongs.titel AS s_titel, tblsongs.duur, tblgenres.titel AS ge_titel, tblgroepen.titel AS gr_titel FROM tblsongs INNER JOIN tblgroepen ON tblgroepen.id = tblsongs.groep_id INNER JOIN tblgenres ON tblgenres.id = tblgroepen.genre_id ORDER BY tblsongs.titel ASC";
  35. $songs = mysql_query($query) or die(mysql_error());//$db -> query("SELECT * FROM tblsongs ORDER BY id ASC");
  36. //$songs = array();
  37. while( $row = mysql_fetch_array($songs))
  38. {
  39. echo "<tr><td></td><td>".$row['s_titel']."</td><td>".$row['duur']."</td><td>".$row['ge_titel']."</td><td>".$row['gr_titel']."</td></tr>";
  40. }
  41. ?>
  42. </tbody>
  43. </table>
  44. </div>
  45. <div id="footer">
  46. <span><a href="#top">back to top</a></span>
  47. </div>
  48. </div>
  49. </body>
  50. </html>

Report this snippet  

You need to login to post a comment.