Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $adre = $_SERVER['REMOTE_ADDR'];
- echo $adre." <br>";
- $host = "localhost";
- $user = "test";
- $pass = "t3st3r123";
- $db = "test";
- $l = mysqli_connect($host, $user, $pass, $db);
- /*mysqli_query($l, "SET CHARACTER SET UTF8") or
- die("Error, ei saa andmebaasi charsetti seatud");*/
- $sql = "INSERT INTO koiderma_IP (IPaadress,time) VALUES ('$adre',NOW())";
- $sql2 ="SELECT * FROM koiderma_IP";
- mysqli_query($l, $sql) or die("Error: " . mysqli_error($l) . $sql);;
- $result= mysqli_query($l, $sql2);
- while($row = $result->fetch_all()) {
- //print_r($row);
- $rownr= count($row);
- echo $rownr." <br>";
- for ($i=0; $i<$rownr; $i++){
- echo "IP: " . $row[$i][0]. " - aeg: " . $row[$i][1]." <br>";
- }
- }
- mysqli_close($l);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement