Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. <?php
  2.  
  3. $link = mysqli_connect("localhost", "db", "pass", "table");
  4.  
  5.  
  6. if($link === false){
  7. die("ERROR: Could not connect. " . mysqli_connect_error());
  8. }
  9.  
  10.  
  11. $id = mysqli_real_escape_string($link, $_POST['id']);
  12. $game = mysqli_real_escape_string($link, $_POST['game']);
  13. $server = mysqli_real_escape_string($link, $_POST['server']);
  14. $server = mysqli_real_escape_string($link, $_POST['datetimepicker1']);
  15. $server = mysqli_real_escape_string($link, $_POST['et']);
  16. $server = mysqli_real_escape_string($link, $_POST['sc']);
  17. $server = mysqli_real_escape_string($link, $_POST['ss']);
  18. $server = mysqli_real_escape_string($link, $_POST['ec']);
  19. $server = mysqli_real_escape_string($link, $_POST['es']);
  20. $server = mysqli_real_escape_string($link, $_POST['dn']);
  21.  
  22.  
  23. $sql = "INSERT INTO events (id, game, server, datetimepicker1, et, sc, ss, ec, es, dn) VALUES ('$id', '$game', '$server', '$datetimepicker1', '$et', '$sc', '$ss', '$ec', '$es', '$dn')";
  24. if(mysqli_query($link, $sql)){
  25. echo "Records added successfully.";
  26. } else{
  27. echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
  28. }
  29.  
  30.  
  31. mysqli_close($link);
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement