Advertisement
Guest User

Untitled

a guest
Apr 10th, 2016
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2. $adre = $_SERVER['REMOTE_ADDR'];
  3. echo $adre." <br>";
  4.  
  5. $host = "localhost";
  6. $user = "test";
  7. $pass = "t3st3r123";
  8. $db = "test";
  9.  
  10. $l = mysqli_connect($host, $user, $pass, $db);
  11. /*mysqli_query($l, "SET CHARACTER SET UTF8") or
  12. die("Error, ei saa andmebaasi charsetti seatud");*/
  13. $sql = "INSERT INTO koiderma_IP (IPaadress,time) VALUES ('$adre',NOW())";
  14. $sql2 ="SELECT * FROM koiderma_IP";
  15. mysqli_query($l, $sql) or die("Error: " . mysqli_error($l) . $sql);;
  16. $result= mysqli_query($l, $sql2);
  17. while($row = $result->fetch_all()) {
  18. //print_r($row);
  19. $rownr= count($row);
  20. echo $rownr." <br>";
  21. for ($i=0; $i<$rownr; $i++){
  22. echo "IP: " . $row[$i][0]. " - aeg: " . $row[$i][1]." <br>";
  23. }
  24. }
  25. mysqli_close($l);
  26.  
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement