- <!DOCTYPE html>
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta charset="utf-8" />
- <title></title>
- </head>
- <body>
- <form name="audio_form" id="audio_form" action="" method="post" enctype="multipart/form-data">
- <fieldset>
- <label>Audio File:</label>
- <input name="audio_file" id="audio_file" type="file"/>
- <input type="submit" name="Submit" id="Submit" value="Submit" />
- </fieldset>
- </form>
- <!--Checking from Database and Insert to render content-->
- <?php
- $servername = "..de";
- $username = "";
- $password = ".-";
- $dbname = "";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT MusikName, MusikURL,Number FROM MusikDatein";
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- echo "<table>
- <tr><th>ID</th><th>Name</th></tr>";
- // output data of each row
- $i=0;
- while($row = $result->fetch_assoc()) {
- echo "
- <tr><td>".$row["Number"]."</td><td>".$row["MusikName"]." ".$row["MusikURL"]."</td></tr>";
- $urlarray[$i]=$row["MusikURL"];
- $jsarray= json_encode($urlarray[$i]);
- echo stripslashes($jsarray);
- $i++;
- } echo "<input type='button' onclick='playAudio()' value='Playrandom'>";
- echo "
- </table>";
- } else {
- echo "0 results";
- }
- $conn->close();
- ?>
- <?php
- ini_set('post_max_size', '64M');
- ini_set('upload_max_filesize', '64M');
- if(isset($_POST['Submit']))
- {
- $file_name = $_FILES['audio_file']['name'];
- 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')
- {
- $new_file_name=$_FILES['audio_file']['name'];
- // Where the file is going to be placed
- $target_path = "Audios/".$new_file_name;
- //target path where u want to store file.
- $musik_ur="http://ottoyilmaz.de/";
- $musik_url=$musik_ur."$target_path";
- //following function will move uploaded file to audios folder.
- if(move_uploaded_file($_FILES['audio_file']['tmp_name'], $target_path)) {
- echo $new_file_name;
- echo $target_path;
- $servername = "..de";
- $username = "";
- $password = "";
- $dbname = "";
- try {
- $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
- // set the PDO error mode to exception
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $sql = "INSERT INTO MusikDatein (MusikName, MusikURL)
- VALUES ('$new_file_name', ' $musik_url')";
- // use exec() because no results are returned
- $conn->exec($sql);
- echo " New record created successfully";
- }
- catch(PDOException $e)
- {
- echo $sql . "<br>" . $e->getMessage();
- }
- $conn = null;
- }
- }
- }
- ?>
- <script>
- var min = 0;
- var max = 10;
- function playAudio() {
- var url = new Array();
- var url2 = new Array();
- var random = Math.floor(Math.random() * (max - min + 1) + min);
- url2 = '<?php echo $urlarray; ?>';
- for (var i = 0; i < url2.length; i++)
- {
- url = ' <?php echo json_encode(stripslashes($jsarray)); ?>;';
- alert(url);
- }
- var audio = new Audio(url[random]);
- audio.addEventListener('ended', function () {
- this.currentTime = 0;
- this.play();
- }, false);
- audio.play();
- }
- </script>
- </body>
- </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