Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_connect = mysqli_connect('localhost', 'katalog', 'KatalogJanda123', 'produkty', 3306);
- function nazev() {
- $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);
- echo '<tr>';
- while ($radek = mysqli_fetch_array($db_data))
- {
- $i = 0;
- $nazev = $radek['nazev'];
- echo "<th>$nazev</th>";
- $i++;
- if (!($i %2))
- {
- echo '</tr>';
- }
- if ($id > 2 and !($i %2) and $i > 2)
- {
- echo '<tr>';
- }
- if ($i == $id)
- {
- echo '</tr>';
- }
- }
- }
- function popis() {
- $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);
- echo '<tr>';
- while ($radek = mysqli_fetch_array($db_data))
- {
- $i = 0;
- $popis = $radek['popis'];
- echo "<td>$popis</td>";
- $i++;
- if (!($i %2))
- {
- echo '</tr>';
- }
- if ($id>2 and !($i %2) and $i > 2)
- {
- echo '<tr>';
- }
- if ($i == $id)
- {
- echo '</tr>';
- }
- }
- }
- function tabulka() {
- echo '<table>';
- nazev();
- popis();
- echo '</table>';
- }
- if($db_connect)
- {
- tabulka();
- }
- 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