douwei8911
douwei8911
2016-03-22 02:14

如何使用php和mysql上传图像文件夹

已采纳

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 don't 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 coding:

<!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>

This is what my php coding looks like

This is my image folder which i wish to create a path to so that all the album art can come up in the albumcover column

How do I create this path with php and mysql

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • douzi2785 douzi2785 5年前
    <style>
    .preview
    {
        width:400px;
        border:solid 1px #dedede;
        padding:10px;
        color:#cc0000;
    
    }
    </style>
    <?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 class='preview' src='jukebox/img/" . $row["Albumcover"] ."' alt=".$row["Albumcover"]."></td>
         <td>" . $row["Play"] . "</td>
    
         </tr>";
     }
    
    点赞 评论 复制链接分享
  • doushang1964 doushang1964 5年前

    No need to do anything special. You are working from a base directory of /jukebox/, your images reside in /jukebox/img/. Let's make it work:

    <img src=\"/jukebox/img/".$row['Albumcover']."\"/>
    

    Within your loop. Now the album cover will appear as an image in that row.

    点赞 评论 复制链接分享