details from the ie address bar?

[del753]

Hi, i've made a seatmap with rows of seats with a url of: selectseats.php?id= Which is all fine, select a seat and you get taken to: seat.html?id=r25, for example, again fine, i want to write an if statement or something similar to say if id=r25 (in the address bar) then show corrensponding picture, so basically how do you look at the address in the browser within an if statement? also i've got 100 seats so I hope this can be done without 100 if statements!?!

thanks in advance

[terfle]

It sounds like you need to create a lookup table in a database. The database table would have an ID and picture name value. Then your code would have an sql statement similar to:

if (isset($_GET[id])) {
	$sql = "SELECT picture_name FROM SEAT WHERE ID=$_GET[id]";
	$result = mysql_query($sql);
	if ($row = mysql_fetch_array($result)) {
		echo "<img src=images/$row[picture_name]>\n";
	}
}

If this seems to be a bit overkill maybe try to combine the picture name and the id. For example have the image name

seat, underscore, id value, file extension
i.e. seat_12.jpg

Then you could create an image tag like:

echo "<img src=images/seat_{$_GET[id]}.jpg>";

Hope this helps generate a few ideas.

[paulnaj]

Hi del,

The variables after the '?' in the url end up in an array called $_GET.

Suppose the URL is iof the form ...

index.php?id=25&name=fred

<?php
// Set a default if necessary
if(!isset($_GET['id'])){
	$_GET['id'] = 1; 
}
echo '<p>'.$_GET['id'].'</p>';

// Set a default if necessary
if(!isset($_GET['name'])){
	$_GET['name'] = 'paul'; 
}
echo '<p>'.$_GET['name'].'</p>';
?>

How many if's depends on the conditions that you have. The more complicated the conditions the more if's.

Paul 🙂

[del753]

thanks for your replys, .........that actually worked first time, thank you very much indeed guys!