Advertisement
Guest User

Untitled

a guest
May 8th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "username";
  4. $password = "password";
  5. $dbname = "myDB";
  6.  
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. // Check connection
  10. if ($conn->connect_error) {
  11. die("Connection failed: " . $conn->connect_error);
  12. }
  13. $sql = mysqli_query("SELECT * FROM gebruikers WHERE naam= '$naam' ");
  14. if (mysqli_num_rows($sql) != 0) { // kijken of de naam in DB betaat
  15. $path = $_SERVER["REQUEST_URI"];
  16. $ip = $_SERVER['REMOTE_ADDR'];
  17. $website = $_SERVER['HTTP_HOST'];
  18. $time = date('h:i:s d/m/Y');
  19.  
  20. $sql = "INSERT INTO ips (ip, datum, website, locatie, name)
  21. VALUES ('$ip', '$time', '$website, '$path', '-')";
  22.  
  23. if ($conn->query($sql) === TRUE) {
  24. // code runnen
  25. }
  26. }
  27.  
  28.  
  29. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement