CODEWITHSUNDEEP
phprefresh
Moon
Moon

Reputation: 20002

PHP: Detect Page Refresh

I have a page action.php on which I run an SQL query through the code, so that whenever the page is viewed the query runs like its like counting page views

<?php
mysqli_query("UPDATE ****");
?>

The problem is when the page is refreshed, the query is run & PAGE REFRESH is counted as a PAGE VIEW which I want to avoid.

   Question: How to avoid it ?

What I am looking for is a simple solution so that I can check 

if( page was refresh ) //some condition
{
 do
}

Upvotes: 23

Views: 79987

Answers (10)

Namures
Namures

Reputation: 1

My own solution is like this:

Add Form field, ex: 'refresh', which value will always increase unless it's a Page-Refresh. Because Page-Refresh only submit old value. Then compare to same value kept in PHP's SESSION var. If a new page, just initiate both values different each other.

in the PHP:

$pageWasRefreshed = false;
if (isset($_POST['refresh']) && isset($_SESSION['refreshdetect']))
    $pageWasRefreshed = ($_SESSION['refreshdetect'] == $_POST['refresh']);
                                                                    
if(!$pageWasRefreshed ) 
{
   //.....change status
}

if (isset($_POST['refresh']))
{
    $_SESSION['refreshdetect'] = $_POST['refresh'];                                 
    $row['refreshdetect'] = ((int)$_POST['refresh'])+1;                             
}
else //if new page
{
    $_SESSION['refreshdetect'] = 0;
    $row['refreshdetect'] = 1;                              
}

in the PHP->HTML (if using Twig. change to PHP code to display variable's value):

<input type="hidden" id="refresh" name="refresh" value="{{ row.refreshdetect }}" />

Upvotes: 0

Froggy
Froggy

Reputation: 1

if( $_SERVER['HTTP_CACHE_CONTROL'] == 'max-age=0')
{
    $_SESSION['status'] = null;<br>
}

Upvotes: -1

iammark
iammark

Reputation: 37

This can work in your scenario:

if(isset($_GET["token"])) {
    $view_token = $_GET["token"];
} else {
    $new_views = $views + 1;
    // UPDATE VIEWS
    $view_token = substr(str_shuffle(str_repeat("0123456789abcdefghijklmnopqrstuvwxyz", 5)), 0, 5);
    header("Location: ?token=$view_token");
}

If the user has a token in the URL, the view count will not update. Therefore, if the user tries to refresh, it will not update the view count. When the user does not have a token in the URL, the view count updates and refreshes the page WITH a token. It is thinking outside of the box but it works!

Upvotes: 2

Rizwan Siddiquee
Rizwan Siddiquee

Reputation: 891

Best way to Detect Page Refresh. or Not ?(Ctrl+F5,F5,Ctrl+R, Enter) 

$pageRefreshed = isset($_SERVER['HTTP_CACHE_CONTROL']) &&($_SERVER['HTTP_CACHE_CONTROL'] === 'max-age=0' ||  $_SERVER['HTTP_CACHE_CONTROL'] == 'no-cache'); 
if($pageRefreshed == 1){
    echo "Yes page Refreshed";
}else{
    //enter code here
    echo "No";
}

Upvotes: 18

Jim
Jim

Reputation: 401

    //here you get the url behind the domain.
    $currentPage = $_SERVER['REQUEST_URI']; 

    //if the session current page is not set.
    if(!isset($_SESSION['currentPage'])){ 

      //set the session to the current page.
      $_SESSION['currentPage'] = $currentPage;     
    }

    //check if the session is not equal to the current page
    if($_SESSION['currentPage'] != $currentPage){

       // if it's not equal you set the session again to the current page.
       $_SESSION['currentPage'] = $currentPage;

       //set the query you want to use
    }

Upvotes: 3

Gideon Rosenthal
Gideon Rosenthal

Reputation: 2033

I found this snippet here, and it worked perfectly for me:

$pageWasRefreshed = isset($_SERVER['HTTP_CACHE_CONTROL']) && $_SERVER['HTTP_CACHE_CONTROL'] === 'max-age=0';

if($pageWasRefreshed ) {
   //do something because page was refreshed;
} else {
   //do nothing;
}

Upvotes: 40

Sairam
Sairam

Reputation: 2898

You can save a cookie that will be associated with the present page and if any link is clicked, update the cookie with the new page name. Assuming the above is done in Javascript, you can send this updateCookie information to the server to notify about a new page hit.

Or another approach could be, you can specify a HTTP HEADER that specifies after how much time the cache expires on a page and that way, the browser wont even send you a request about page load/refresh.

See http://www.mnot.net/cache_docs/#IMP-SCRIPT for information about CACHING

Also , check out Etag vs Expires in HTTP - ETag vs Header Expires

Upvotes: 1

Moon
Moon

Reputation: 20002

i have solved the problem ... HURRAHHH with no session & no cookies

the solution is a combination of PHP : AJAX : JavaScript

the query that you want to run on Page Load & not on page Refresh run it as via AJAX call lets say my function for doing that is 

function runQUERY()
{
    xmlhttp=new XMLHttpRequest();
    xmlhttp.open("POST","doIT.php",false);
    xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
    xmlhttp.send();
}

and i can simply check with Javascript that the page is a fresh load or its a refresh by doing the following

<head>
<script type="text/javascript">
function checkRefresh()
{
    if( document.refreshForm.visited.value == "" )
    {           
        // This is a fresh page load
            alert ( 'Fresh Load' );
        document.refreshForm.visited.value = "1";
            ..call you AJAX function here
    }
    else
    {
        // This is a page refresh
        alert ( 'Page has been Refreshed, The AJAX call was not made');

    }
}
</script>    
</head>

<body onLoad="checkRefresh()">

<form name="refreshForm">
<input type="hidden" name="visited" value="" />
</form>

</body>
</html>

and in your doIT.php simple add your PHP code which you were going to put in the normal page

<?php
mysql_query("UPDATE---------");
//put any code here, i won't run on any page refresh
?>

Upvotes: 3

casablanca
casablanca

Reputation: 70701

You can't directly detect a page refresh, but you can use a cookie to simulate what you want:

if (isset($_COOKIE['action'])) {
  // action already done
} else {
  setcookie('action');
  // run query
}

Depending on your requirements, you also need to decide when to remove the cookie and/or perform the action again.

Upvotes: 11

Rutger
Rutger

Reputation: 96

If you just want to run it once for a user, I would set a session cookie and then use an if() statement.

<?php
session_start();

if (!$_SESSION['loaded'])
{
    // insert query here
}

$_SESSION['loaded'] = true;

?>

Upvotes: 6

Related Questions