$get multiple variables from url

Question

I am making a photography website. In the DB there is an images table, events table and category table which as linked via foreign keys. At the moment i generate events from when a photo was taken from the database and turn them into anchor links.

<?php
while ( $a_row = mysql_fetch_row( $result ) ){

 foreach ( $a_row as $field ){

?>
<a href="images.php?event=<?php echo $field;?> "> <php? echo $field; ?> </a>
<?php
 }
}
?>

When the link is clicked a script gets the variable from get in the url: /images.php?**event**=eventCalledParty

foreach($_GET as $value)
{
$event = $value;
}
$event = mysql_real_escape_string($event);

My question is - If i was to implement categories and have a url that looks like:

/images.php?event=eventCalledParty&category=categoryCalledFashionPhotography

How would i seperate these two variables from the url to use in my queries.

Thank You.

Please note that your current code makes no sense. No foreach have to be used — Your Common Sense
– Your Common Sense, Commented Sep 15, 2010 at 13:40
I should have figured, i already knew post worked like that :/ thank you — slexAtrukov
– slexAtrukov, Commented Sep 15, 2010 at 13:53

Brad · Accepted Answer · 2010-09-15 13:31:25Z

6

These will automatically show up in these variables...

$_GET['event']
$_GET['category']

PHP does all of this work for you.

answered Sep 15, 2010 at 13:31

Brad

164k57 gold badges380 silver badges559 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Brad Over a year ago

I should also note that you shouldn't be escaping your data until you go to use it in your query. Otherwise it won't be of much use to you for anything else.

Your Common Sense Over a year ago

good point. it worth to add it to the answer, rather in comment

Your Common Sense · Accepted Answer · 2010-09-15 13:34:41Z

5

$event = mysql_real_escape_string($_GET['event']);
$category = mysql_real_escape_string($_GET['category']);

answered Sep 15, 2010 at 13:34

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Comments

Fanis Hatzidakis · Accepted Answer · 2010-09-15 13:33:31Z

1

Each url parameter becomes a separate key in $_GET.

So, for /images.php?event=eventCalledParty&category=categoryCalledFashionPhotography you will get:

$_GET['event'] => 'eventCalledParty' 
$_GET['category'] => 'categoryCalledFashionPhotography'

and you can act accordingly:

if ($_GET['category'] == 'categoryCalledFashionPhotography') {
    //do stuff here
}

answered Sep 15, 2010 at 13:33

Fanis Hatzidakis

5,3401 gold badge35 silver badges36 bronze badges

2 Comments

Brad Over a year ago

You need to be checking if $_GET['something'] is set first! Use empty() or isset().

Fanis Hatzidakis Over a year ago

@Brad most certainly so. I was mostly trying to focus slexAtrukov's attention on how $_GET is used step by step. Good advice, though.

davydotcom · Accepted Answer · 2010-09-15 13:34:26Z

1

Im a bit rusty on php but I think in your foreach what you want is to get the name of teh field as well as its value.

foreach($_GET as $name->$value)
{
  if($name == 'event') {
    $event = mysql_real_escape_string($value);
  }
  else if($name == 'category')
  {
    $category = mysql_real_escape_string($category);
  }
}

answered Sep 15, 2010 at 13:34

davydotcom

2,2101 gold badge17 silver badges18 bronze badges

2 Comments

Your Common Sense Over a year ago

what's the use of a loop here?

James Over a year ago

That should be foreach($_GET as $name=>$value).

Dale Hurley · Accepted Answer · 2010-09-15 13:34:54Z

1

foreach($_GET as $key => $value) { $event[$key] = mysql_real_escape_string($value); }

answered Sep 15, 2010 at 13:34

Dale Hurley

1517 bronze badges

1 Comment

Your Common Sense Over a year ago

register globals will make a funny mess out of this code :) Better to add $event=array(); above

Collectives™ on Stack Overflow

$get multiple variables from url

5 Answers 5

2 Comments

Comments

2 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related