[RESOLVED] URL on image for multiple rows in table

jrtaylor

I've got a php front-end table on my website. You can see the "test page" here:

http://www.ascentfx.com/en/red.html

I want the buttons to point to their respective URLS. For example the "CPFX" button should point to

http://www.ascentfx.com/en/cpfx.html

I can't do this in the usual HTML way. So somehow I need to get the URL into the php code, which I've put in bold below.

I assume there's some sort of echo code to grab the specific table row's name, but I'm not a coder and I'm also OLD and not as sharp as I was in my youth!

Thanks much!

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252" /> 
<script language ="javascript">
function vmail()
{
m= document.programs.T2.value;
if ((m.indexOf('@')==-1)||(m.indexOf('.')==-1)||(m.length<5)){
alert ('Please enter a correct e-mail!');
document.programs.T2.value='';
document.programs.T2.focus();
}
}

function verif()
{
if ((document.programs.T10.value=="")||(document.programs.T2.value=="")||(document.programs.T5.value=="")) {alert ("Please fill all required fields"); 
document.programs.T10.focus();
return false; }

return true;
}


</script>
</head>
<?php

if (isset($_POST['T10'])) {
include('components/com_ckforms/views/ckformsdata/tmpl/affichage.php');
}
else
{
?>

<p><br></p>
  <style>
.hide label{display:none;}

.thumbnail{
position: relative;
z-index: 0;


}

.thumbnail:hover{
background-color: transparent;
z-index: 50;
}

.thumbnail span{ /*CSS for enlarged image*/
position: absolute;
background-color: #FFFFFF;
padding: 5px;
left: -1000px;
border: 0px SOLID #000088;
visibility: hidden;
color: black;
text-decoration: none;
}

.thumbnail span img{ /*CSS for enlarged image*/
border-width: 0;
padding: 2px;
}

.thumbnail:hover span{ /*CSS for enlarged image on hover*/
visibility: visible;
top: -100px;
left: 150px; /*position where enlarged image should offset horizontally */

}


</style>


<style type="text/css" mce_bogus="1"></style>
<div height=100%>

<p> </p>
<table style="text-align: center; width: 99%;" align="center" border="1" cellpadding="5" cellspacing="0">
<tbody><!--Start 1st tr-->
<tr style="text-align: center; background-color: rgb(173, 216, 230);" mce_style="text-align: center; background-color: #add8e6;" background="" valign="center" height="100" lang="">
<td width="13%" style="text-align: center; background-color: rgb(173, 216, 230);" scope="" lang="" mce_style="text-align: center; background-color: #add8e6;">
  <p><span style="font-family: arial,helvetica,sans-serif;" mce_style="font-family: arial,helvetica,sans-serif;">Program</span></p></td>
<td width="54%" style="text-align: center; background-color: rgb(173, 216, 230);" scope="" lang="" mce_style="text-align: center; background-color: #add8e6;">
<p><span style="font-family: arial,helvetica,sans-serif;" mce_style="font-family: arial,helvetica,sans-serif;">Graph (roll mouse over for larger image)</span></p></td>
<td width="15%" style="text-align: center; background-color: rgb(173, 216, 230);" scope="" lang="" mce_style="text-align: center; background-color: #add8e6;">
<p><span style="font-family: arial,helvetica,sans-serif;" mce_style="font-family: arial,helvetica,sans-serif;">Minimum Investment</span></p></td>
<td width="18%" style="text-align: center; background-color: rgb(173, 216, 230);" scope="" lang="" mce_style="text-align: center; background-color: #add8e6;"><span style="font-family: arial, helvetica, sans-serif">Program Details</span></td>
</tr><!--Start 2nd tr-->
<?php
$i=0;
@ include ('DBconnect.php');
$sql= ("select * from program group by program");
$req= mysql_query($sql);
while ($data= mysql_fetch_array($req)) {
$nom= $data['program'];
$sql2= ("select * from program where (year= 2010)and(program= '$nom')");
$req2= mysql_query($sql2);
while ($val= mysql_fetch_array($req2)) {
$avg= $val['avgmonth'];
}
$sql2= ("select * from program where (year= 2009) and(program= '$nom')");
$req2= mysql_query($sql2);
while ($val= mysql_fetch_array($req2)) {
$return = $val['total'];
}
$i++;
?>

<tr <?php if ($i%2==1){ echo("class=even" ) ; } ?> >
<td lang="">
  <p><?php echo $data['program']; ?></p></td>
<td><a class="thumbnail"  mce_href="#"><img src="components/com_ckforms/views/ckformsdata/tmpl/display.php?D1=<?php echo $data['program']; ?>" mce_src="components/com_ckforms/views/ckformsdata/tmpl/display.php?D1=<?php echo $data['program']; ?>" width="124" height="75"><span> <img src="components/com_ckforms/views/ckformsdata/tmpl/display.php?D1=<?php echo $data['program']; ?>" mce_src="components/com_ckforms/views/ckformsdata/tmpl/display.php?D1=<?php echo $data['program']; ?>" ></span></a><br mce_bogus="1"></td>
<td>
<p><?php echo $data['mininvest']; ?></td>
<td>
  [U][B]<img src="components/com_ckforms/views/button.png">[/B][/U]</td>
</tr>
<?php
}
?>
<!--Start 3rd tr-->
	<!--Start 4th tr-->
	<!--Start 5th tr-->
	<!--Start 6th tr-->
	<!--Start 7th tr-->
	<!--Start 8th tr-->
	<!--Start 9th Row-->
	<!--Start 10th Row-->
	<!--Start 11th Row-->
	<!--Start 12th Row-->
</tbody></table>

<br>
</div>
<p style="text-align: left;" mce_style="TEXT-ALIGN: left"> </p>
<?php
}
?>

etully

Replace this:

with this:

<a href="<?php
if ($data['program']=="cpfx") { print "http://www.ascentfx.com/en/cpfx.html"; }
if ($data['program']=="c1fcs") { print "http://www.ascentfx.com/en/page2.html"; }
if ($data['program']=="ccml") { print "http://www.ascentfx.com/en/ccml.html"; }
if ($data['program']=="goog") { print "http://www.google.com"; }
if ($data['program']=="cpfx2") { print "http://www.ascentfx.com/en/cpfx2.html"; }
?>"><img src="components/com_ckforms/views/button.png" border=0></a>

Another solution, if the program name is also the name of the html file, would be this:

<a href="http://www.ascentfx.com/en/<?php echo $data['program']; 
?>.html"><img src="components/com_ckforms/views/button.png" border=0></a>

The first example is better because sometimes the name of the program isn't the name of the HTML file. For example, what if your program "abcde" was supposed to link to yahoo.com. By doing it as a series of if statements, you have the flexibility to make them link anywhere.

etully

Note that these are two simple ways to solve the problem. As you become a better PHP programmer, you would probably put the program names and their associated page URL's into an array... or better yet, you would have a 3rd sql table that keeps track of the program names and URL's so that they can be edited without bothering the PHP programmer.

jrtaylor

etully,

thanks for your help! I had to use the second code you suggested because the list of links changes periodically and thus I need a "dynamic" link (if that's what you call it).

You can see the results here, by clicking any of the buttons:http://www.ascentfx.com/en/red.html

you'll see that your code works... except the final part of the URL is in all CAPS.

On my site, the URLS for articles are all in lower case. I tried changing to upper but it (joomla) automatically changes back to lower case.

And I can't change the source to lower caps because the acronyms I'm using are published in my articles elsewhere, and they need to be in caps.

To try to solve the problem I've read about coding my .htaccess file but also read that this will slow down the loading time for the site.

Is there some code I could add to make the url all lower case?

Thanks!

etully

<a href="http://www.ascentfx.com/en/<?php echo strtolower($data['program']); 
?>.html"><img src="components/com_ckforms/views/button.png" border=0></a>

By the way, I don't think that .htaccess would solve that problem (but it might). If it does, there's a steep learning curve there because you're going to need to learn about mod_rewrite and regular expressions too. Lots of technologies at the same time.

As for the speed hit, it will be imperceptible unless you are getting so much traffic that your server is running at 90% capacity. I'm talking a hundred hits a second or more. Seriously, feel free to use .htaccess - it's not a performance problem until you are extremely popular - and by then, you're making enough money to deal with the problem.

jrtaylor

Thanks much! It works perfectly.

I appreciate your time and comments as well re: .htaccess.