passing a php page's name to a variable

waterox

Hi,

I am very new to php so go easy on me!
I am trying to hack some pre-existing php code (see below)

What I have is a page that currently gets the newest item from a database.
On some pages this works. However, in this instance I need to show a specific item.
Since the page is not fully dynamic, it is named after the corresponding item in the database (eg blue.php)

I need to change the line that orders by itemDate.
I'm guessing that grabbing 'blue' from /blue.php and looking this up in the table might be the solution?

How could I achieve this?

Below is the code:

<?php
$url = $_SERVER ["PHP_SELF"];
print "\n\n";

$productCode = substr($url, 15, 5);
print "\n\n";

include('/include/ez_sql.php');

$product = $db->get_row("
SELECT
productName, productText
FROM
product
WHERE
productCode = '$productCode'
");

$item = $db->get_row("
SELECT
itemCode, itemCat, itemName, itemText, itemDate
FROM
item
WHERE
itemCode REGEXP '^{$productCode'}
ORDER BY 'itemDate' DESC LIMIT 1
");

$format = $db->get_results("
SELECT
format
FROM
format
WHERE
itemCode = '$item->itemCode'
");

$categoryCode = substr($item->itemCode, 5, 3);
$itemCodex = substr($item->itemCode, -5);

$category = $db->get_row("
SELECT
categoryName
FROM
category
WHERE categoryCode = '$category'
");

$formats = $db->get_results("
SELECT lf.displayFormat FROM format f
LEFT JOIN lookupFormat lf ON lf.japFormat = f.format
WHERE f.itemCode = '$itemCodex'
");

cretaceous

um - your issue sounds back to front - the page name shouldn't be changed like that.. usually the item would be 'appended' to the page url so :

www.mysite.com/mypage.php?theitem=23&someotherattribute=foo

then on the page you do

$gotitem=$_REQUEST['theitem'];
$gototheratt=$_REQUEST['someotherattribute'];

(or $GET instead of $REQUEST)

ok so you're not doing that but I had to suggest it..

To get the part of the URL you want, do this

$url_array = explode("/", $_SERVER['REQUEST_URI']);
$url_array=array_reverse($url_array);
if($url_array) $urlpg= strtok($url_array[0],".");

line 1 gets the url and puts it into an array split on forward slashes
line 2 reverses it, so now the first item in the array, at position 0, is the ending bit: "mypage.php?etc=abc&more=xyz"
line 3 does a strtok on it, so its another way of splitting the string, this time its split on the 'period' so tada $urlpg now equals the bit you want, in this example "mypage"