dongqingcheng2903 2015-06-18 05:21
浏览 43

如何使用表格数据添加图像

I have made a database using phpLiteAdmin, It has many entries however they are all text or number.

I was wondering if I could add an image section in this database or how else would I do it. The only other way I think I could do it would be by using the href tag and moving it into position. There must be a better way of doing this.

Here is my code of my php and html.

<head>
   <link type="text/css" rel="stylesheet" href="Car_Style.css"/>
</head>
<body>
    <header id="header" class="loading" style="opacity: 1";]>
    <!-- Logo -->
      <div id="logo"></div>
      <!-- Nav -->
        <nav id="nav">
            <ul>
                <li><a href="#intro">header</a></li>
                <li><a href="#one">Header</a></li>
                <li><a href="#two">header</a></li>
                <li><a href="#work">My Header</a></li>
                <li><a href="#contact">Header</a></li>
            </ul>
        </nav>
    </header>
    <!-- This is where all the images go from each of the entries -->
</body>

<?php

    try {
      # Connect to SQLite database
      $dbh = new PDO("sqlite:Car_Sales_Network");

      # Prepare SQL statement
      $sth = $dbh->prepare('SELECT * FROM Cars_On_Network' );

     # Set the Fetch Mode to Associative Array
     $sth->setFetchMode(PDO::FETCH_ASSOC);

     # Run the query on the database
     $sth->execute();

    //table printout
    echo "<table>";

    # Loop through returned records
    while($row = $sth->fetch()) {
      //print_r($row);spot
      //print_r($row);

    echo "<table>";
    echo "<th>Car Make:</th>";
    echo "<th>Car Model:</th>";
    echo "<th>Car Badge:</th>";
    echo "<th>Car Price:</th>";
    echo "<th>Car Transmission:</th>";
    echo "<th>Car P Plate Legality:</th>";
    echo "<div id='1'>";
    echo "<tr>";
    echo "<td>".  $row["car_make"] . "</td>";
    echo "<td>".  $row["car_model"] . "</td>";
    echo "<td>".  $row["car_badge"] . "</td>";
    echo "<td>".  $row["price"] . "</td>";
    echo "<td>".  $row["trans"] . "</td>";
    echo "<td>".  $row["P_Plate_Legal"] . "</td>";
    echo "</tr>";
    echo "</div>";

    //echo $row["Game_ID"];
    echo "<br>";
  }

  echo "</table>";

 } 
 catch(PDOException $e) {
    echo $e->getMessage();
}

?>

This is my css. 

* {
    font-family: Arial;
    color: black;
 }

table {
    padding: 20px;
}

th td {
   padding-right:  20px;
   padding-left: 20px;
   padding-top: 20px;
   padding-bottom: 20px;
}


/*********************************************************************************/
/* Header                                                                        */
/*********************************************************************************/
#header ul li {
    color:white;
    text-decoration: underline;
}

#header {
    position: fixed;
    z-index: 10000;
    left: 0;
    top: 0;
    width: 100%;
    background: #000000;
    background: rgba(0, 0, 0, 0.95);
    height: 3em;
    line-height: 3em;
    box-shadow: 0 0 0.15em 0 rgba(0,0,0,0.1);
}

body {
    padding-top: 3em;
}

#logo {
    position: absolute;
    left: 1em;
    top: 0;
    height: 3em;
    line-height: 3em;
    letter-spacing: -1px;
}

#logo a {
    font-size: 1.25em;
}

#nav {
    position: absolute;
    right: 0.5em;
    top: 0;
    height: 3em;
    line-height: 3em;
}

#nav ul {
    margin: 0;
}

#nav ul li {
    display: inline-block;
    margin-left: 0.5em;
    font-size: 0.9em;
}

#nav ul li a {
    display: block;
    color: inherit;
    text-decoration: none;
    height: 3em;
    line-height: 3em;
    padding: 0 0.5em 0 0.5em;
    outline: 0;
}

Obviously it's not finished but how can I have each car with a picture.

Cheers.

  • 写回答

1条回答 默认 最新

  • dongxun5349 2015-06-18 05:42
    关注

    1. First, you must find a way to store your image.

      We don't usually store the binary data of images in database. Instead we store the image files somewhere on your server (or 3rd party CDN).

    2. Then we create a new varchar(255) in the database and store the URL of those images (e.g. http://foobar.com/some/image.jpg). For explanation, let's say we will add a column car_image_url in the said table.

    3. Let's change the PHP code a bit to add the display column:

      <link type="text/css" rel="stylesheet" href="Car_Style.css"/>

</head>

<body>
    <header id="header" class="loading" style="opacity: 1";]>

                <!-- Logo -->
                    <div id="logo">

                    </div>

                <!-- Nav -->
                    <nav id="nav">
                        <ul>
                            <li><a href="#intro">header</a></li>
                            <li><a href="#one">Header</a></li>
                            <li><a href="#two">header</a></li>
                            <li><a href="#work">My Header</a></li>
                            <li><a href="#contact">Header</a></li>
                        </ul>
                    </nav>

            </header>

    <!-- This is where all the images go from each of the entries -->



</body>




<?php

try {
  # Connect to SQLite database
  $dbh = new PDO("sqlite:Car_Sales_Network");

  # Prepare SQL statement
  $sth = $dbh->prepare('SELECT * FROM Cars_On_Network' );

  # Set the Fetch Mode to Associative Array
  $sth->setFetchMode(PDO::FETCH_ASSOC);

  # Run the query on the database
  $sth->execute();

 //table printout
  echo "<table>";

  # Loop through returned records
  while($row = $sth->fetch()) {
    //print_r($row);spot
        //print_r($row);

    /* added these line */
    # If the image field is empty, change to dummy image
    if (empty($row['car_image_url'])) {
        $row['car_image_url'] = 'http://yourdomain.com/some/dummy.jpg';
    }
    /* // added these line */


 echo "<table>";
    echo "<th>Car Make:</th>";
    /* added this line */
    echo "<th>Car Image:</th>";
    /* // added this line */
    echo "<th>Car Model:</th>";
    echo "<th>Car Badge:</th>";
    echo "<th>Car Price:</th>";
    echo "<th>Car Transmission:</th>";
    echo "<th>Car P Plate Legality:</th>";


    echo "<div id='1'>";
    echo "<tr>";
    echo "<td>".  $row["car_make"] . "</td>";
    /* added this line */
    echo "<td><img src=\"".  $row["car_image_url"] . "\" /></td>";
    /* // added this line */
    echo "<td>".  $row["car_model"] . "</td>";
    echo "<td>".  $row["car_badge"] . "</td>";
    echo "<td>".  $row["price"] . "</td>";
    echo "<td>".  $row["trans"] . "</td>";
    echo "<td>".  $row["P_Plate_Legal"] . "</td>";


    echo "</tr>";
    echo "</div>";



      //echo $row["Game_ID"];
    echo "<br>";
  }

echo "</table>";


  } 
catch(PDOException $e) {
    echo $e->getMessage();

}

?>

    4. Style the CSS whatever you like.

    评论

报告相同问题？

悬赏问题

  • ¥15 想问一下树莓派接上显示屏后出现如图所示画面，是什么问题导致的
  • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
  • ¥15 cmd cl 0x000007b
  • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
  • ¥500 火焰左右视图、视差（基于双目相机）
  • ¥100 set_link_state
  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号