The current page ... variables in queries

Ravenous

1) I'm trying to get a last modified time of the current page to be echoed at the bottom of my pages. I had everything working nicely so long as I told the script the name of the current page explicitly. However, once I get to a large number of pages, this won't be efficient. So how do I get the name of the current page being viewed by the user? I tried $SERVER['PHP_SELF'], but that returns the entire path frm the document root which causes problems. I tried $SERVER['SCRIPT_NAME'], but that does the same thing, returns the entire path from document root. Bleh.. Kinda buggin' me. Anyone know how to resolve this issue? $_SERVER['REQUEST_URI'] doesn't work either.

2) Also, using a variable in a query.. Here's the code I'm using that is currently causing errors:

<?
	$db = mysql_connect("localhost", "myuserhere", "mypasshere") or die(mysql_error());
	mysql_select_db("mybhicom_website") or die(mysql_error());
	$aid = $_POST['aid'];
	$q = "SELECT * FROM mynews WHERE aid='$aid';";
	$r = mysql_query($q, $db) or die(mysql_error());
	$row = mysql_fetch_row($r) or die(mysql_error());
?>

I get a completely blank page. I'm able to echo $_POST['aid'] without a problem. SO by my reasoning, it oes exist and is set correctly. 😕 Can anyone spot the syntax error?

Thanks....

jernhenrik

re 1:
Perhaps you could use an explode() to find the last element after the / (slash)?
eg:

<?php
$var=$_SERVER["PHP_SELF"];
$arr=explode("/", $var);
$arr_count=count($arr);
$res=$arr[$arr_count-1];
echo $res;//this should be your page
?>

re 2:
Don't you get an error with the or die?? Seems to be a semicolon ( ; ) too much in the :
$q = "SELECT * FROM mynews WHERE aid='$aid'( ; )<-try and remove this";

hth

Ravenous

Thanks for the response, man.. The first one is working fine. I run into problems when I try to put that code into a function and call it, I get a problem, bu that's for another post. Thanks.

As for the second issue, I still get a blank page. There are no errors. 😕

EDIT:
Well, I tried echoing $aid, but I got nothing. Weird.. The url generated by the referring page is http://www.mybhi.com/assembly/admin/editarticle.php?aid=8 Appending stuff to the url with the question mark passes it with POST, does it not?

meowmix

You'd use $GET['aid'] and not $POST['aid'].

You dont get an error, because by default, your php is told not to report undefined variables.

If you'r ever unsure, use $_REQUEST (http://us4.php.net/manual/en/reserved.variables.php#reserved.variables.request)