toevoegen.php 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. <?php
  2. if($_SERVER['REQUEST_METHOD'] == "POST"){
  3. $name = safeString($_POST["Name"]);
  4. $bid = safeString($_POST["bid"]);
  5. $streamurl = $_POST["StreamUrl"];
  6. $streamport = safeString($_POST["StreamPort"]);
  7. $streamsplit = parse_url($streamurl);
  8. $streamip = gethostbyname($streamsplit["host"]);
  9. $streamurl = $streamsplit["path"];
  10. if($stmt = $mysqli -> prepare("INSERT INTO PresetRadioStream(name, buttonid, streamip, streamurl, streamport, uid) VALUES(?,?,?,?,?,?)")){
  11. $stmt ->bind_param("sissii", $name, $bid, $streamip, $streamurl, $streamport, $userid);
  12. $stmt ->execute();
  13. $stmt ->close();
  14. }
  15. }
  16. ?>
  17. <div class="col-lg-12">
  18. <div class="ibox float-e-margins">
  19. <div class="ibox-title">
  20. <h5>Prefix toevoegen</h5>
  21. </div>
  22. <div class="ibox-content">
  23. <form method="POST" action="" class="form-horizontal">
  24. <div class="form-group">
  25. <label class="col-sm-2 control-label">Naam</label>
  26. <div class="col-sm-10">
  27. <input type="text" required name = "Name" class="form-control">
  28. </div>
  29. </div>
  30. <div class="form-group">
  31. <label class="col-sm-2 control-label">Knop nummer</label>
  32. <div class="col-sm-10">
  33. <select name = "bid" class="form-control">
  34. <option value="1">1</option>
  35. <option value="2">2</option>
  36. <option value="3">3</option>
  37. <option value="4">4</option>
  38. <option value="5">5</option>
  39. </select>
  40. </div>
  41. </div>
  42. <div class="form-group">
  43. <label class="col-sm-2 control-label">Streamurl</label>
  44. <div class="col-sm-8">
  45. <input type="text" required name = "StreamUrl" class="form-control">
  46. </div>
  47. <div class="col-sm-2">
  48. <input type="number" min"0" max="9999" value="80" required name = "StreamPort" class="form-control">
  49. </div>
  50. </div>
  51. <div class="form-group">
  52. <div class="col-sm-4 col-sm-offset-2">
  53. <button class="btn btn-primary" type="submit">Prefix opslaan</button>
  54. <button class="btn btn-primary" type="reset">Reset</button>
  55. </div>
  56. </div>
  57. </form>
  58. </div>
  59. </div>
  60. </div>