Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once("inc/DB.php");
- require_once("inc/Currency.php");
- $db = new DB;
- $currency = new Currency;
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <title>Page Title</title>
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <link rel="stylesheet" type="text/css" media="screen" href="css/bootstrap.css">
- <script src="js/bootstrap.bundle.js"></script>
- <script src="js/jquery-3.3.1.js"></script>
- </head>
- <body>
- <div class="container-fluid">
- <nav class="navbar navbar-expand-lg navbar-dark bg-dark mb-4">
- <a class="navbar-brand" href="#">Navbar</a>
- <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarColor01"
- aria-controls="navbarColor01" aria-expanded="false" aria-label="Toggle navigation">
- <span class="navbar-toggler-icon"></span>
- </button>
- <div class="collapse navbar-collapse" id="navbarColor01">
- <ul class="navbar-nav mr-auto">
- <li class="nav-item active">
- <a class="nav-link" href="index.php">Home <span class="sr-only">(current)</span></a>
- </li>
- <li class="nav-item">
- <a class="nav-link" href="#">Features</a>
- </li>
- <li class="nav-item">
- <a class="nav-link" href="#">Pricing</a>
- </li>
- <li class="nav-item">
- <a class="nav-link" href="#">About</a>
- </li>
- </ul>
- <form class="form-inline">
- <input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search">
- <button class="btn btn-outline-info my-2 my-sm-0" type="submit">Search</button>
- </form>
- </div>
- </nav>
- <div class="row">
- <div class="col-2">
- <div class="container-fluid shadow p-4 bg-white rounded">
- <div class="row">
- </div>
- </div>
- </div>
- <div class="col-10">
- <div class="table-responsive shadow p-4 bg-white rounded mb-4">
- <table class="table table-hover table-striped">
- <thead class="thead-dark">
- <tr>
- <th>ID</th>
- <th>Name</th>
- <th>Price in €</th>
- <th>Price in CZK</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $eurValue = $currency->GetEurToCzk();
- $conn = $db->connect();
- $data = $db->SelectAllEntries($conn);
- if ($data->num_rows > 0) {
- $totalPriceEuro = 0;
- while ($row = $data->fetch_assoc()) {
- $totalPriceEuro += $row["price"];
- ?>
- <tr>
- <th>
- <?= $row["id"] ?>
- </th>
- <td>
- <?= $row["tobacco"] ?>
- </td>
- <td>
- <?= $row["price"] ?>
- </td>
- <td>
- <?= $eurValue["rates"]["CZK"] * $row["price"] ?>
- </td>
- </tr>
- <?php
- }
- }
- ?>
- </tbody>
- <thead class="thead-dark">
- <tr>
- <th></th>
- <th></th>
- <th>Total price in €</th>
- <th>Total price in CZK</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <th></th>
- <td></td>
- <td>
- <?= $totalPriceEuro ?>
- </td>
- <td>
- <?= $eurValue["rates"]["CZK"] * $totalPriceEuro ?>
- </td>
- </tr>
- </tbody>
- </table>
- </div>
- <div class="container-fluid shadow p-4 bg-white rounded">
- <div class="row">
- <div class="col-lg-7">
- <form method="POST" action="index.php">
- <div class="form-group">
- <label for="productName">Product name:</label>
- <input type="text" name="name" class="form-control" placeholder="Product name" id="productName"
- required>
- </div>
- </div>
- <div class="col-lg-5">
- <div class="form-group">
- <label for="productPrice">Product price in €:</label>
- <input type="number" name="productPrice" class="form-control" placeholder="Product price"
- id="productPrice" required>
- <div class="mt-2">
- <button type="submit" class="btn btn-primary">Create entry</button>
- </div>
- </div>
- </div>
- </form>
- </div>
- </div>
- </div>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement