Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once 'db/db.php';
- $ip = $_SERVER["REMOTE_ADDR"];
- $firstQuery = "SELECT `ip`,`number` FROM `counter`";
- $firstResult = mysql_query($firstQuery) or die("Ошибка MySQL: " . mysql_error());
- $row = mysql_fetch_assoc($firstResult);
- $count = $row['number']+1;
- $secondQuery = "INSERT INTO `counter`(`ip`,`number`) VALUES('{$ip}','{$count}')";
- $secondResult = mysql_query($secondQuery) or die("Ошибка MySQL: " . mysql_error());
- echo 'Кол-во просмотров: '.$row['number'].'<br/>';
- echo $count;
- mysql_close();
Advertisement
Add Comment
Please, Sign In to add comment