Dynamically creating a page based on info from a link?

rupertbj

I am creating a database for an art site and have a section to upload images and now I am creating pages from which to view them.

I have split the paintings and would like to know how I tell which
<a href="gallery.php">link</a>
link has been pressed to for each of the links down the page so that i can create a dynamically produced page depending which link is used. I have a database with all the info including paths for images etc.

      <table width="50%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td align="center" valign="middle" class="link"><a href="gallery.php">Prague, 
            Czech Republic</a></td>
        </tr>
        <tr> 
          <td align="center" valign="middle" class="link"><a href="gallery.php">St. 
            Petersburg, Russia </a></td>
        </tr>
        <tr> 
          <td align="center" valign="middle" class="link"><a href="gallery.php">Venice, 
            Italy</a></td>
        </tr>
        <tr> 
          <td align="center" valign="middle" class="link"><a href="gallery.php">Rome, 
            Italy</a></td>
        </tr>
        <tr> 
          <td align="center" valign="middle" class="link"><a href="gallery.php">Cornwall, 
            England</a></td>
        </tr>
        <tr> 
          <td align="center" valign="middle" class="link"><a href="gallery.php"></a></td>
        </tr>
      </table>

Thanks in advace for your help!

WinterDragon

Instead, do this...

#Put this in the top of the page...

$query = $QUERY_STRING;
$query_Array = explode("&", $query);
foreach ($query_Array as $i) {
$doubleItem = explode("=", $i);
$$doubleItem[0] = str_replace("%20", " ", $doubleItem[1]);
}

Now lets put some links down here...

<A href="gallery.php?page=index">Index</a><br>
<a href="gallery.php?page=prague">Prague</a><br>
etc...

now lets test out which one was clicked...

if($page) {
if($page == "index") {
echo "This is the index page, here is some information...<br>";
} elseif($page == "prague") {
echo "This is the prague page! Um... ok yeah here is some prague information!<br>";
}} elseif(!$page) {
echo "No page selected!<br>";
}

Any other questions? Hope this helps... btw, whatever page=whatever (replace whatever with what you want... then test it with an if statement where I have the others and then print out something or include something)

rupertbj

What does the bit at the top of the page do?

rupertbj

You put me on the right track though - by setting the string for each link by using this in galleries.html

<a href="gallery.php?page=cornwall">

I then used this in a MySQL statement in gallery.php

		$sql = "SELECT * FROM galleryTable WHERE tour = '$page' ORDER BY id DESC";

and it works a treat!

Thanks.

WinterDragon

Its a little snippet I made for parsing the query string in URLs because I would know exactly HOW to parse, and what to parse and what I would need...

What that does at the top? This is what it does...

#This gets the query string...
$query = $QUERY_STRING;
#This splits it at the & sign, (when there are multiple variables)
$query_Array = explode("&", $query);
#This foreach splits all of the variables...
foreach ($query_Array as $i) {
$doubleItem = explode("=", $i);
#Replaces with spaces..
$$doubleItem[0] = str_replace("%20", " ", $doubleItem[1]);
}

Anyways all it does is parse the query string, which is the end of it... index.php?variable=value&variable2=value%20with%20spaces&variable3=value3

It parses that... and returns each as a variable, er... so variable, and variable2, and variable3 will return appropriate results...
heh