Basically I have to create a jukebox type chart via mysql and php using xampp.
I've done the basics of setting up the table my referring to mysql database etc. I just dont get how to code the path to the image folder I have created.
My Image folder is in htdocs under my folder I created called Jukebox.
This is my code:
<!DOCTYPE html>
<html>
<head>
<style>
table, th, td {
border: 1px solid black;
}
</style>
</head>
<body>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "jukebox";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM Music";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "<table>
<tr>
<th>Artist</th>
<th>Title</th>
<th>Album</th>
<th>Albumcover</th>
<th>Play</th>
</tr>";
// output data of each row
while($row = $result->fetch_assoc()) {
echo
"<tr>
<td>" . $row["Artist"]. "</td>
<td>" . $row["Title"]. "</td>
<td>" . $row["Album"]. "</td>
<td>" . $row["Albumcover"]
. "</td>
<td>" . $row["Play"] . "</td>
</tr>";
}
echo "</table>";
} else {
echo "0 results";
}
?>
</body>
</html>
I'm assuming you want the image in the "Albumcover" part of your code. If so you can echo out a html line. You can name your images in the "jukebox" folder with the album name. The code will appear as
<td>" . $row["Artist"]. "</td>
<td>" . $row["Title"]. "</td>
<td>" . $row["Album"]. "</td>
<td>" <img src=\"jukebox/".$row["Album"].".png\" >"</td>
For that all images will need to be of file type png which is easy to do, just save them normally and add .png at the end. The same album name on your database will need to be the same name given to the file. There are other filetypes you can use such as .jpg.
I don't really see your problem. What do you store in "albumcover"? Let's say you save the relative path to your albumcover. So you can print out
<td><img src="' . $row["Albumcover"] . '"></td>
Use your mp3 as a tag and open that in a new tab.May be this is you needed.I assume jukebox/mp3/ as your mp3 folder
<?php
// output data of each row
while($row = $result->fetch_assoc()) {
echo
"<tr>
<td>" . $row["Artist"]. "</td>
<td>" . $row["Title"]. "</td>
<td>" . $row["Album"]. "</td>
<td><img src='jukebox/img/" . $row["Albumcover"] ."' alt=".$row["Albumcover"]."></td>
<td><a href='jukebox/mp3/" . $row["Play"] . "' target='blank'>" . $row["Play"] . "</a>
</td>
</tr>";
}