connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT max(count) as c FROM count WHERE id = $iidd";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
if ($row==null || $row["c"]==null) {
//echo "new counter";
$visits = 1;
$sql = "INSERT INTO count (id, count) VALUES ( $iidd , $visits);";
$result = $conn->query($sql);
}
else {
$visits = $row["c"];
$visits++;
$sql = "INSERT INTO count (id, count) VALUES ( $iidd ,$visits )";
$conn->query($sql);
$sql = "DELETE from count where id=$iidd and count<$visits";
$conn->query($sql);
}
$conn->close();
return $visits;
}
?>
Visit counter