Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require 'conn.php';
- $sql = "SELECT p.nr_katalogowy, p.nazwa, p.opis, p.cena_netto, s.stawka, p.cena_brutto, p.stan_magazynowy, p.id_foto FROM produkt p join stawka_vat s on s.id = p.stawka_vat where p.nazwa_kategorii=1";
- $result = $conn->query($sql);
- if ($result->num_rows > 0): ?>
- <table>
- <thead>
- <tr>
- <th>zdj</th>
- <th>nr katalogowy</th>
- <th>nazwa</th>
- <th>opis</th>
- <th>cena netto</th>
- <th>vat</th>
- <th>brutto</th>
- <th>ilość</th>
- <th></th>
- </tr>
- </thead>
- <tbody>
- <?php while ($row = $result->fetch_row()): ?>
- <tr>
- <td><img src="<?php echo $sciezka_do_obrazka; ?>"></td>
- <td><?php echo $nr_kat; ?></td>
- <td><?php echo $nazwa; ?></td>
- <td><?php echo $opis; ?></td>
- <td><?php echo $cena_n; ?></td>
- <td><?php echo $nr_kat; ?></td>
- <td>23%</td>
- <td><?php echo $cena_n * 1.23 ?></td>
- <td><?php echo $ilosc; ?></td>
- <td> <a href="/addtocart?productid=<?php echo $nr_kat; ?>">Dodaj do koszyka</a> </td>
- </tr>
- <?php endwhile; ?>
- </tbody>
- </table>
- <?php endif; ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement