Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jun 4th, 2012  |  syntax: None  |  size: 0.44 KB  |  hits: 10  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How do I update a MySQL table each time a page loads?
  2. <?php include_once $_SERVER['DOCUMENT_ROOT'] . "/incl_func/env_constants.php"; ?>
  3.     <?php
  4.     //check 404 visits
  5.     $ip = $_SERVER['REMOTE_ADDR'];
  6.     $date = date("Y-m-d H:i:s");
  7.     $agent = $_SERVER['HTTP_USER_AGENT'];
  8.     $refer = $_SERVER['HTTP_REFERER'];
  9.  
  10.     $query = @mysql_query("INSERT INTO 404 (REF_URL, IP, AGENT, DATE) VALUES ('$refer', '$ip', '$agent', '$date')");    
  11.     ?>