Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form method="post">
- <div class="form-group">
- <label>Nadpis</label>
- <input type="text" name="nadpis" class="form-control" placeholder="Nadpis" maxlength="70" size="70">
- </div>
- <textarea name="editor" id="editor" rows="30"></textarea>
- <script>CKEDITOR.replace('editor');</script>
- <div class="form-group">
- <label for="sel">Kategorie</label>
- <select name="kategorie" class="form-control" id="sel" title="Vyberte kategorii">
- <?php
- $sql = "SELECT id_k, nazev FROM kategorie ORDER BY nazev";
- $kat = mysqli_query($connect, $sql) or die ("Něco je špatně");
- while($prvek = mysqli_fetch_assoc($kat))
- echo "<option value='".$prvek['id_k']."'>".$prvek['nazev']."</option>";
- ?>
- </select>
- </div>
- <div class="form-group">
- <label>Fotogalerie k článku (není povinná)</label>
- <input type="file" value="Nahrát fotku">
- </div>
- <div class="form-group">
- <input type="submit" class="btn btn-default" name="sub" value="Zveřejnit">
- </div>
- </form>
- <?php
- if(isset($_POST['sub']))
- {
- $nadpis = $_POST['nadpis'];
- $text = mysqli_real_escape_string ($connect, $_POST['editor']);
- $kategorie = $_POST['kategorie'];
- $katid = "SELECT id_k FROM kategorie WHERE nazev = $kategorie";
- $query = mysqli_query($connect, $katid);
- $vysledek = mysqli_fetch_assoc($query);
- $sql = "INSERT INTO clanek (id_c, nazev, obsah, datum, id_k, id_u) VALUES ('', '$nadpis', '$text', current_timestamp, '".$vysledek['id_k']."', '1')";
- if(!isset($_POST['nadpis']))
- {
- echo "Nebyl zadán nadpis článku!";
- }
- else if(!isset($_POST['editor']))
- {
- echo "Chybí obsah článku!";
- }
- else
- {
- $query = mysqli_query($connect, $sql);
- if(!$query)
- echo mysqli_error($connect);
- else
- echo "Článek úspěšně přidán!";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement