Miletone

Rp0 / Rp1.000.000

Sunday, September 29, 2019

PHP : Show database on Table

<html>

   <head>
      <title>SHOP</title>
  <link rel="stylesheet" href="css/default.css">
  <p style="color:red">
   </head>

   <body style="background-color:#0B173B;">
   <table border = "1" align="left" bgcolor = "#0B173B">
  <tr>
            <td><a href = "index.php" ><img src="img/home.png" alt="Home" style="width:200;height:100px;" align="center"></a></td>
  </tr>
 
   <br/>
   </table>
   <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
   <form class="example" action="index.php" align="right">
  <input type="text" placeholder="Search.." name="search">
  <button type="submit"><i class="fa fa-search"></i></button>
</form>
   <table border = "1" align="center" bgcolor = "yellow" width = "100%">
         <tr>
            <td><a href = "index.php" >Home</a></td>
            <td><a href = "https://www.tutorialspoint.com" target = "_self">Contact</a></td>
<td><a href = "https://www.tutorialspoint.com" target = "_self">About</a></td>
         </tr>
      </table>
<marquee> HTML </marquee>


  </br>
  <?php
  include "connect.php";
 
  $select = 'select * from data';
  $ex = $pdo->query($select);
  $ex->setFetchMode(PDO::FETCH_ASSOC);
 
      echo "<table border =1 align=center bgcolor=white>";
         echo"<tr>
<td>Categories</td>
            <td>ID</td>
            <td>Name</td>
<td>Description</td>
<td>Price</td>
<td>Picture</td>
<td>Order</td>
         </tr>";
 while ($do = $ex->fetch()){
echo"<tr><td>".$do['Category']."</td>";
echo"<td>".$do['ID']."</td>";
            echo"<td>".$do['Name']."</td>";
echo"<td>".$do['Description']."</td>";
echo"<td>$".$do['Price']."</td>";
echo"<td><a href='".$do['Picture']."' target='_blank'>Click Here</a></td>";
echo"<td><a href='method.php?n=".$do['ID']."'>Call Order</a></td></tr>";
 }
      echo "</table>";
  ?>
      <h3> Discount </h3>
  <table border = "1" align="center">
  <tr>
            <td><img src="img/home.png" alt="Home" style="width:300;height:150;" align="center"></td>
  </tr>
  <marquee> HTML </marquee>
  <table border = "1" align="center" bgcolor = "yellow" width = "100%">
         <tr>
            <td><a href = "index.php" target = "_blank">Footer</a></td>
         </tr>
      </table>
   </body>
</html>

No comments: