Advertisement
Guest User

Untitled

a guest
Feb 18th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. //Index.php
  2. <!DOCTYPE HTML>
  3. <html>
  4. <head>
  5. <title>VIP System - Add a VIP</title>
  6. <style>
  7. .error {color: #FF0000;}
  8. </style>
  9. </head>
  10. <body>
  11. <?php
  12. // define variables and set to empty values
  13. $steamErr = $daysErr = "";
  14. $steamid = $days = "";
  15.  
  16. if ($_SERVER["REQUEST_METHOD"] == "POST") {
  17. if (empty($_POST["steamid"])) {
  18. $steamErr = "steamid is required";
  19. } else {
  20. $steamid = test_input($_POST["steamid"]);
  21. }
  22.  
  23. if (empty($_POST["days"])) {
  24. $daysErr = "days is required";
  25. } else {
  26. $days = filter_var( $_GET["days"], FILTER_VALIDATE_INT);
  27. }
  28. }
  29.  
  30. function test_input($data) {
  31. $data = trim($data);
  32. $data = stripslashes($data);
  33. $data = htmlspecialchars($data);
  34. return $data;
  35. }
  36. ?>
  37.  
  38. <h2>Add a V.I.P</h2>
  39. <p><span class="error">* Required Field.</span></p>
  40. <form method="post" action="dbstaff.php">
  41. SteamID: <input type="text" name="steamid">
  42. <span class="error">* <?php echo $steamErr;?></span>
  43. <br><br>
  44. Days: <input type="text" name="days">
  45. <span class="error">* <?php echo $daysErr;?></span>
  46. <br><br>
  47. <input type="submit" name="submit" value="Submit">
  48. </form>
  49.  
  50. </body>
  51. </html>
  52.  
  53. //dbstaff
  54. <?php require 'includes/database.php';
  55.  
  56.  
  57. try {
  58. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  59. // set the PDO error mode to exception
  60. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  61. $sql = "INSERT INTO users (steamid, time) VALUES ('$steamid', '$days')";
  62. // use exec() because no results are returned
  63. $conn->exec($sql);
  64. echo "User has been added successfuly for a VIP ";
  65. }
  66. catch(PDOException $e)
  67. {
  68. echo $sql . "<br>" . $e->getMessage();
  69. }
  70. $conn = null;
  71. ?>
  72.  
  73. //Includes/database.php
  74. <?php
  75. $servername = "db4free.net";
  76. $username = "xxxxxxx";
  77. $password = "xxxxxx";
  78. $dbname = "xxxxxxxx";
  79. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement