1. <!DOCTYPE html>
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta charset="utf-8" />
  5. <title></title>
  6. </head>
  7. <body>
  8. <form name="audio_form" id="audio_form" action="" method="post" enctype="multipart/form-data">
  9. <fieldset>
  10. <label>Audio File:</label>
  11. <input name="audio_file" id="audio_file" type="file"/>
  12. <input type="submit" name="Submit" id="Submit" value="Submit" />
  13. </fieldset>
  14. </form>
  15. <!--Checking from Database and Insert to render content-->
  16. <?php
  17. $servername = "..de";
  18. $username = "";
  19. $password = ".-";
  20. $dbname = "";
  21. // Create connection
  22. $conn = new mysqli($servername, $username, $password, $dbname);
  23. // Check connection
  24. if ($conn->connect_error) {
  25. die("Connection failed: " . $conn->connect_error);
  26. }
  27. $sql = "SELECT MusikName, MusikURL,Number FROM MusikDatein";
  28. $result = $conn->query($sql);
  29. if ($result->num_rows > 0) {
  30. echo "<table>
  31. <tr><th>ID</th><th>Name</th></tr>";
  32. // output data of each row
  33. $i=0;
  34. while($row = $result->fetch_assoc()) {
  35. echo "
  36. <tr><td>".$row["Number"]."</td><td>".$row["MusikName"]." ".$row["MusikURL"]."</td></tr>";
  37. $urlarray[$i]=$row["MusikURL"];
  38. $jsarray= json_encode($urlarray[$i]);
  39. echo stripslashes($jsarray);
  40. $i++;
  41. } echo "<input type='button' onclick='playAudio()' value='Playrandom'>";
  42. echo "
  43. </table>";
  44. } else {
  45. echo "0 results";
  46. }
  47. $conn->close();
  48. ?>
  49. <?php
  50. ini_set('post_max_size', '64M');
  51. ini_set('upload_max_filesize', '64M');
  52. if(isset($_POST['Submit']))
  53. {
  54. $file_name = $_FILES['audio_file']['name'];
  55. if($_FILES['audio_file']['type']=='audio/mpeg' || $_FILES['audio_file']['type']=='audio/mpeg3' || $_FILES['audio_file']['type']=='audio/x-mpeg3' || $_FILES['audio_file']['type']=='audio/mp3' || $_FILES['audio_file']['type']=='audio/x-wav' || $_FILES['audio_file']['type']=='audio/wav')
  56. {
  57. $new_file_name=$_FILES['audio_file']['name'];
  58. // Where the file is going to be placed
  59. $target_path = "Audios/".$new_file_name;
  60. //target path where u want to store file.
  61. $musik_ur="http://ottoyilmaz.de/";
  62. $musik_url=$musik_ur."$target_path";
  63. //following function will move uploaded file to audios folder.
  64. if(move_uploaded_file($_FILES['audio_file']['tmp_name'], $target_path)) {
  65. echo $new_file_name;
  66. echo $target_path;
  67. $servername = "..de";
  68. $username = "";
  69. $password = "";
  70. $dbname = "";
  71. try {
  72. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  73. // set the PDO error mode to exception
  74. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  75. $sql = "INSERT INTO MusikDatein (MusikName, MusikURL)
  76. VALUES ('$new_file_name', ' $musik_url')";
  77. // use exec() because no results are returned
  78. $conn->exec($sql);
  79. echo " New record created successfully";
  80. }
  81. catch(PDOException $e)
  82. {
  83. echo $sql . "<br>" . $e->getMessage();
  84. }
  85. $conn = null;
  86. }
  87. }
  88. }
  89. ?>
  90. <script>
  91. var min = 0;
  92. var max = 10;
  93. function playAudio() {
  94. var url = new Array();
  95. var url2 = new Array();
  96. var random = Math.floor(Math.random() * (max - min + 1) + min);
  97. url2 = '<?php echo $urlarray; ?>';
  98. for (var i = 0; i < url2.length; i++)
  99. {
  100. url = ' <?php echo json_encode(stripslashes($jsarray)); ?>;';
  101. alert(url);
  102. }
  103. var audio = new Audio(url[random]);
  104. audio.addEventListener('ended', function () {
  105. this.currentTime = 0;
  106. this.play();
  107. }, false);
  108. audio.play();
  109. }
  110. </script>
  111. </body>
  112. </html>

PHP gibt durch echo "www.xxx2.mp3" "http://xxx.mp3" "http://xxx2.mp3" aus ... JS gibt in alert nur die letze URL von diesen echo aus :/ stripslahes wird benötigt um http:/\/\xxx.mp3" zu umgehen