Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once("header.php");
- require_once("connect.php"); // spojenie s hostom a vyber databazy
- if (isset($_GET['ok']) and $_GET['ok'] == "true")
- {
- echo "<p><center>Záznam bol úspešné vymazaný!</p></center>";
- }
- ?>
- <center>
- <h2>Zobraziť/editovať údaje v databáze:</h2>
- <form action="druhy.php" method="post">
- <p>Zvoľte tabuľku:<br></p>
- <select name="platforma">
- <option value="filmy">Filmy</option>
- <option value="reziser">Režisér</option>
- </select>
- <input type=submit name="vyber" value="zobraziť">
- </form>
- </center>
- <?php
- $nazov_tabulky = isset($_POST['platforma']) ? $_POST['platforma'] : "";
- if ($nazov_tabulky)
- {
- if ($vysledok = $spojenie->query("select * from $nazov_tabulky"))
- {
- echo "<center><table><tbody></center>";
- if ($nazov_tabulky == "filmy")
- { echo "<center><tr><td><b>Názov</b><td></td></td><td><b>Rok vydania</b></td><td></td><td><b>Hodnotenie</b></td><td></td></tr>";
- while ($film_data = $vysledok->fetch_array())
- {
- echo "<center><tr><td>{$film_data['nazov']}</td><td></td><td>{$film_data['rok']}</td><td></td><td>{$film_data['percento']}</td><td></td><td><a href='treti.php?id={$film_data['filmy_id']}&co=filmy'><img src=\"images/button_edit.png\" border=0 alt=Editovať></a></td><td><a href=\"javascript: if (confirm('Chcete naozaj zmazať tento záznam?')) { window.location.href='zmazat.php?id={$film_data['filmy_id']}&co=filmy' }\"><img src=\"images/button_delete.gif\" border=0 alt=Zmazať></a></td></tr><center>";
- }
- }
- else if ($nazov_tabulky == "reziser")
- { echo "<center><tr><td><b>Režisér</b></td><td><b></b></td><td><b>Rok narodenia</b></td></tr>";
- while ($reziser_data = $vysledok->fetch_array())
- {
- echo "<center><tr><td>{$reziser_data['meno_krstne']}</td><td>{$reziser_data['meno_priezvisko']}</td><td>{$reziser_data['datum_narodenia']}</td><td><a href='treti.php?id={$reziser_data['reziser_id']}&co=reziser'><img src=\"images/button_edit.png\" border=0 alt=Editovať></a></td><td><a href=\"javascript: if (confirm('Chcete naozaj zmazať tento záznam?')) { window.location.href='zmazat.php?id={$reziser_data['reziser_id']}&co=reziser' }\"><img src=\"images/button_delete.gif\" border=0 alt=Zmazať></a></td></tr><center>";
- }
- }
- echo "</tbody></table>";
- }
- else
- echo "<p><center>Chyba, niekde nastal problem: </p></center>". $spojenie->error;
- }
- $spojenie->close(); // ukoncenie spojenia
- ?>
- <br><br><br>
- <div class="rightalign"><img src="images/movie2.jpg" alt="obrázok_nezobrazený" width="186" height="232"></div><br><br><br>
- <?php
- require_once("footer.php");
- ?>
Add Comment
Please, Sign In to add comment