How to pull information from a DB based on current page and no ? = & characters

dougmcc1

Is there a way to populate a page with variables from a database that are unique to that page without giving it a long URL with ? = & characters?

For example:
If blue-widget.php is requested, I want it to pull $product, $description, and $price for blue widget from the database.
If red-widget.php is requested, I want it to pull $product, $description, and $price for red widget from the database.

I stored the page name in the row for the each product in the database. blue-widget.php is stored in the row that contains the information about blue widgets, red-widget.php is stored in the row that contains the information about red widgets.

possible pseudocode? :
$page_name = (somehow detect the current page)
SELECT [variables] FROM [table] WHERE page_name = $page_name

LordShryku

Try this. Should work if you're not using arguments in the URL. Otherwise, it will need a little revision.

if(substr($PHP_SELF,-1) == "/") { 
	$page = substr($PHP_SELF,0,-1);
}
else {
	$page = $PHP_SELF;
}
$myPage = substr(strrchr($page, "/"),1);

dougmcc1

Thanks, I'll give that a shot. Can you break it down for me and tell me what it means so I can revise it?

Thanks again.

LordShryku

if(substr($PHP_SELF,-1) == "/") {  // see if there is a / on the end of the url 
    $page = substr($PHP_SELF,0,-1); // if yes, remove it 
} 
else { 
    $page = $PHP_SELF; //otherwise, we use php_self
} 
$myPage = substr(strrchr($page, "/"),1); //strrchr finds the last occurace of something in a sting(in this case, we want the last / ). then we use substr to pull out everything after that.

Hope this helps. If you have aruments, you could just strip out the $_SERVER['argv']

dougmcc1

Ahh much better. Thanks

It's not working though. I'm just echoing out my variables, no arguments. Right now the only variable is $myPage.

If we are pulling out everything after the / then we shouldn't remove it should we?

LordShryku

Well ,we're not removing it. We check to see if there's on on the end, like /www/this/test/page.php/

We'll remove the one on the end if it's there

What other variables are you trying to get besides $myPage?

dougmcc1

None right now. Once I have this working I'll use $myPage in my WHERE statement to pull out the others.

LordShryku

So does $myPage come out correct?

dougmcc1

No it's not displaying anything. No errors though.

dougmcc1

It works when I don't include it in one of my includes. Thanks for your help, this is exactly what I needed.