Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_connect = mysqli_connect('localhost', 'katalog', 'KatalogJanda123', 'produkty', 3306);
- $db_data = mysqli_query($db_connect, 'SELECT * FROM siesta ORDER BY id');
- $id = mysqli_num_rows($db_data);
- $db_lastdata = mysqli_query($db_connect, 'SELECT popis FROM siesta ORDER BY id DESC LIMIT 1');
- $popis = true;
- if ($db_connect) {
- echo '<table>';
- echo '<tr>';
- $i = 0;
- while ($radek = mysqli_fetch_array($db_data)) {
- $nazev = $radek['nazev'];
- echo "<th>$nazev</th>";
- $i++;
- if (!($i % 2)) {
- echo '</tr>';
- echo '<tr>';
- $in = 1;
- while ($in <= 2) {
- if ($popis == true) {
- $cislo = $i - 1;
- $db_popis = mysqli_query($db_connect, "SELECT popis FROM siesta WHERE id=$cislo");
- $get_popis = mysqli_fetch_array($db_popis);
- $popis = $get_popis['popis'];
- echo "<td>$popis</td>";
- $in++;
- $popis = false;
- } else {
- $cislo = $i;
- $db_popis = mysqli_query($db_connect, "SELECT popis FROM siesta WHERE id=$cislo");
- $get_popis = mysqli_fetch_array($db_popis);
- $popis = $get_popis['popis'];
- echo "<td>$popis</td>";
- $in++;
- $popis = true;
- }
- }
- echo '</tr>';
- }
- if ($id > 2 and !($i % 2) and $i > 2) {
- echo '<tr>';
- }
- if ($i == $id) {
- $lastradek = mysqli_fetch_array($db_lastdata);
- $lastpopis = $lastradek['popis'];
- echo '</tr>';
- echo '<tr>';
- echo "<td>$lastpopis</td>";
- echo '</tr>';
- }
- }
- echo '</table>';
- } else {
- echo 'Spojení s databází nebylo navázáno!';
- echo '<br />';
- echo 'Kontaktuje prosím administrátora na e-mail <a href="mailto:[email protected]">[email protected]</a> s chybovým hlášením.';
- echo 'Popis chyby: ', mysqli_connect_error();
- exit();
- }
- if ($db_connect)
- mysqli_close($db_connect);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement