Guest User

Счётчик

a guest
Dec 7th, 2015
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. <?php
  2.  
  3. require_once 'db/db.php';
  4. $ip = $_SERVER["REMOTE_ADDR"];
  5.  
  6. $firstQuery = "SELECT `ip`,`number` FROM `counter`";
  7. $firstResult = mysql_query($firstQuery) or die("Ошибка MySQL: " . mysql_error());
  8. $row = mysql_fetch_assoc($firstResult);
  9. $count = $row['number']+1;
  10.  
  11. $secondQuery = "INSERT INTO `counter`(`ip`,`number`) VALUES('{$ip}','{$count}')";
  12. $secondResult = mysql_query($secondQuery) or die("Ошибка MySQL: " . mysql_error());
  13.  
  14.  
  15. echo 'Кол-во просмотров: '.$row['number'].'<br/>';
  16. echo $count;
  17. mysql_close();
Advertisement
Add Comment
Please, Sign In to add comment