I created a postgresDB with maps(.jpg) and additonal information about them such as "area,theme,type,language,date,creator,...etc"
I created a form with 4 drop-down options for "area,theme,type,language" and a "submit" button.After a query you can receive a table of results with the maps in small size and some of the additional information(not all).
QUESTION
I want to click on one of the the displayed images(map), open it in a new page enlarged and with all the rest aditional information from the database. I tried it with <a href=$imageurl> but only i can do is to enlarge the image without putting the information See bellow the resultpage.php code, at the "echo" part.
Does anybody knows how i can solve that?
Thanks all for your time and help.
Expand|Select|Wrap|Line Numbers
- while($row =pg_fetch_array($result, null, PGSQL_ASSOC))
- {
- echo "<tr>";
- echo "<td align='center'>" . $row['title'] . "</td>";
- echo "<td align='center'>" . $row['area_name'] . "</td>";
- echo "<td align='center'>" . $row['type_name'] . "</td>";
- echo "<td align='center'>" . $row['theme_name'] . "</td>";
- echo "<td align='center'>" . $row['language_name'] . "</td>";
- echo "<td align='center' > <a href=$row[link]>" . $row['link'] . "</a> </td>";
- $imagebytes = $row['name'];
- $imagebytes = trim($imagebytes);
- $imageurl='http://localhost/IMPCHEN/' . $imagebytes . ".jpg";
- echo "<td align='center'> <a href=$imageurl> <img src=$imageurl width='157' height='117'>" . $row['name'] . "</a> </td>";
- echo "</tr>";
- }
- echo "</table>";
- // onclick=myfunc(obj)
- pg_close($con);
- ?>