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.
These will automatically show up in these variables...
$_GET['event']
$_GET['category']
PHP does all of this work for you.
$event = mysql_real_escape_string($_GET['event']);
$category = mysql_real_escape_string($_GET['category']);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With