Guest User

Untitled

a guest
Oct 24th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. <?php
  2.  
  3. $mysqlhost = "127.0.0.1";
  4. $mysqluser = "diver_Marta";
  5. $mysqlpass = "Przytulanka6";
  6. $mysqldata = "diver_log";
  7.  
  8. $self = $_SERVER['PHP_SELF'];
  9. $user = $_SERVER['REMOTE_ADDR'];
  10.  
  11. mysql_connect($mysqlhost,$mysqluser,$mysqlpass);
  12. mysql_select_db($mysqldata);
  13.  
  14. $query = "INSERT INTO `access` VALUES (now(),'$self','$user')";
  15. mysql_query($query);
  16.  
  17. /*
  18. $query = "UPDATE `activity` SET timesopen=timesopen+1 WHERE `filename` = '$self'";
  19. $query = "INSERT INTO `activity` (filename) VALUES ('$self') ON DUPLICATE KEY UPDATE timesopen=timesopen+1;"; */
  20.  
  21. $result = mysql_query("SELECT * FROM `activity` WHERE `filename` = '$self'");
  22. if (mysql_num_rows($result) > 0) {
  23. mysql_query("UPDATE `activity` SET timesopen=timesopen+1 WHERE `filename` = '$self'");
  24. } else {
  25. mysql_query("INSERT INTO `activity` (filename) VALUES ('$self')");
  26. }
  27.  
  28. /* mysql_query($query); */
  29.  
  30. mysql_close();
  31.  
  32. ?>
Add Comment
Please, Sign In to add comment