connect_error) { die("ERROR: Unable to connect: " . $conn->connect_error); } $id = intval($_GET['id']); $sql = "SELECT * FROM ads WHERE id= '$id'"; $result = mysqli_query($conn,$sql); $row = mysqli_fetch_array($result); $url=$row["url"]; $id = intval($_GET['id']); $klick=$row["klicks"]; $klick=$klick+1; $sql = "UPDATE ads SET klicks='$klick' WHERE id='$id'"; $result = $conn->query($sql); $date = date('Y-m-d H:i:s'); $REMOTE_ADDR = $_SERVER['REMOTE_ADDR']; header("LOCATION: $url"); ?>