getting current page URL

Anon

I have a plain HTML page with a php script imbedded in it with a server side include. The script is a glorified access counter that stores the number of hits for a given page in a mySQL database. The mySQL database has three columns:

page - url of page being counted
count - number of hits
date - date last hit

I want to code this script so it will get the page URL to build the SQL query by looking at the address in the browser's address window. This type of check is easy in JavaScript. How can I get the URL for the current page in PHP?

My script follows:
<?php
//counter.php
$dbhostname = "myhostname";
$dbusername = "myusername";
$dbpassword = "mypassword";
$dbname = "mydatabasename";
$link = mysql_connect ($dbhostname, $dbusername, $dbpassword) or die ("Could not connect");
mysql_select_db($dbname);
$stmt = "UPDATE counter SET count=count+1 WHERE page = 'somepage.html'";
$result = mysql_db_query($dbname,$stmt);
mysql_close ($link);
?>

brandonschnell

$stmt = "UPDATE counter SET count=count+1 WHERE page = '$PHP_SELF'";

Anon

No, I think this will not work, $PHP_SELF will retun a name and path of a php file, not a .shtml page.

Try using $REQUEST_URI - it's contains parameter of HTTP's GET or POST request, just that your browser tells to web server.

Remember: this can return a full URI, including scheme, hostname, path and document, or just a document name if you're usin relative links.

You may use this function:
array parse_url (string url)

This function returns an associative array returning any of the various components of the URL that are present. This includes the "scheme", "host", "port", "user", "pass", "path", "query", and "fragment".