Image Map Problem with PHP

reub77

Has anyone encountered this? I'm using Dreamweaver to construct a website and the main navigation involves image maps. The page works fine when it's only html. Once I add PHP to the code the image maps get disabled.

I've had this problem with other websites I've built as well and ended up just breaking the image up and making individual links for each image. It would be easier to just correct the problem I would hope without having to go through all that trouble.

My code is long and I'll spare you the time of looking over it unless you'd like to see it. Just ask.

feldon23

Dreamweaver does not play well with PHP.

It's probably screwing up quotes or adding spaces where it shouldn't.

reub77

That means I should still be able to go into it and fix it though.
Can you see the problem?

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<?PHP 
//Checks to see if User is Logged in
include("checkAuth.php"); 
//Connecting to database
include("connectDB.php");
$chr = "1";
$chr = $_GET['chr'];

?>
<html><!-- InstanceBegin template="/Templates/main.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>View the Entire Library</title>
<!-- InstanceEndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="body.css">
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body background="images/mf_home_bg.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" cellspacing="0" cellpadding="0">
  <tr> <!-- InstanceBeginEditable name="top" -->
    <td background="images/topBannerFiller.gif"><img src="images/topBanner.jpg" width="453" height="125"></td>
    <!-- InstanceEndEditable --></tr>
</table>
<table width="100%" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="4"></td>
    <td width="220" valign="top"><img src="images/home_nav.gif" width="206" height="156" border="0" usemap="#Map"></td>
    <!-- InstanceBeginEditable name="Main" -->
    <td valign="top">
	  <p><font color="#FFFFFF" size="4" face="Arial, Helvetica, sans-serif">View Movies </font></p>      

      <p><a href="viewEntireLibrary.php?chr=1"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">ALL</font></a><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"> 
        | <a href="viewEntireLibrary.php?chr=num"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">#</font></a> | <a href="viewEntireLibrary.php?chr=A"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">A</font></a> 
        | <a href="viewEntireLibrary.php?chr=B"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">B</font></a> | <a href="viewEntireLibrary.php?chr=C"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">C</font></a> 
        | <a href="viewEntireLibrary.php?chr=D"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">D</font></a> | <a href="viewEntireLibrary.php?chr=E"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">E</font></a> 
        | <a href="viewEntireLibrary.php?chr=F"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">F</font></a> | <a href="viewEntireLibrary.php?chr=G"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">G</font></a> 
        | <a href="viewEntireLibrary.php?chr=H"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">H</font></a> | <a href="viewEntireLibrary.php?chr=I"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">I</font></a> 
        | <a href="viewEntireLibrary.php?chr=J"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">J</font></a> | <a href="viewEntireLibrary.php?chr=K"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">K</font></a> 
        | <a href="viewEntireLibrary.php?chr=L"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">L</font></a> | <a href="viewEntireLibrary.php?chr=M"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">M</font></a> 
        | <a href="viewEntireLibrary.php?chr=N"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">N</font></a> | <a href="viewEntireLibrary.php?chr=O"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">O</font></a> 
        | <a href="viewEntireLibrary.php?chr=P"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">P</font></a> | <a href="viewEntireLibrary.php?chr=Q"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Q</font></a> 
        | <a href="viewEntireLibrary.php?chr=R"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">R</font></a> | <a href="viewEntireLibrary.php?chr=S"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">S</font></a> 
        | <a href="viewEntireLibrary.php?chr=T"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">T</font></a> | <a href="viewEntireLibrary.php?chr=U"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">U</font></a> 
        | <a href="viewEntireLibrary.php?chr=V"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">V</font></a> | <a href="viewEntireLibrary.php?chr=W"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">W</font></a> 
        | <a href="viewEntireLibrary.php?chr=X"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">X</font></a> | <a href="viewEntireLibrary.php?chr=Y"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Y</font></a> 
        | <a href="viewEntireLibrary.php?chr=Z"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">Z</font></a></font><br>
      </p>
	  <?PHP
$conn = db_connect(); 
print "<table width='96%' border='1' bordercolor='#FFFFFF' cellspacing='0' cellpadding='0'><tr><th class='tabletext'>Movie</th><th class='tabletext'>Owner</th><th class='tabletext'>Category</th><th class='tabletext'>Actors/Actresses</th><th class='tabletext'>Director</th><th class='tabletext'>Rating</th><th class='tabletext'>Format</th><th class='tabletext' >DVD/VHS</th><th class='tabletext'>Availability</th></tr>";
//declare query
if($chr=="1"){
  $query = "SELECT * FROM movies WHERE owner NOT LIKE '".$siteuser."'  ORDER BY movieName ASC";
//Will display all movies with a number as the first characters
}else if($chr=="num"){
  $query = "SELECT * FROM movies WHERE movieName REGEXP '^[0-9]' AND owner NOT LIKE '".$siteuser."'  ORDER BY movieName ASC";
}else{
  $query = "SELECT * FROM movies WHERE movieName LIKE '".$chr."%' AND owner NOT LIKE '".$siteuser."'  ORDER BY movieName ASC";
}
//execute query
$result = mysql_query($query);
if (mysql_errno()) die(mysql_error());
$x = 0;
while ($x < mysql_num_rows($result)) :
   $mName = mysql_result($result, $x, 'movieName');
   $avail = mysql_result($result, $x, 'availability');
   $year = mysql_result($result, $x, 'releaseYear');
   $own = mysql_result($result, $x, 'owner');
   $cat = mysql_result($result, $x, 'category');
   $act1 = mysql_result($result, $x, 'actorActress1');
   $act2 = mysql_result($result, $x, 'actorActress2');
       if($act2 != ""){$act2 = ", $act2";}
   $act3 = mysql_result($result, $x, 'actorActress3');
       if($act3 != ""){$act3 = ", $act3";}
   $act4 = mysql_result($result, $x, 'actorActress4');
       if($act4 != ""){$act4 = ", $act4";}
   $dir = mysql_result($result, $x, 'director');
   $mode = mysql_result($result, $x, 'modeDelivery');
   $rat = mysql_result($result, $x, 'rating');
   $form = mysql_result($result, $x, 'format');
   $rb = mysql_result($result, $x, 'rentedBy');
   $Id = mysql_result($result, $x, 'id'); 

   print "<tr>";
   print "<td class='tabletext'>$mName "; if($year!="")print "($year)"; 
   print "</td><td align='center' class='tabletext'>$own</td><td class='tabletext' align='center'>$cat</td><td class='tabletext'>";if($act1=="")print"<center>n/a</center>";
   print "$act1$act2$act3$act4</td><td class='tabletext'>";
   if($dir=="")print"<center>n/a</center>";
   print "$dir</td><td align='center' class='tabletext'>$mode</td><td align='center' class='tabletext'>$rat</td><td align='center' class='tabletext'>$form</td><td align='center' class='tabletext'>";
   if($avail=="IN") print "<a href='formmail.php?act=REQUEST&&ID=$Id&&OWN=$own'><font color='#FFFFFF'>REQUEST</font></a></td>";
   else if($avail=="OUT") print "$rb</td>";   

   print "</tr>";
   $x++;
endwhile;
print "</table>";
mysql_close();
if(!$result)
  return("Query could not be executed"); // if query error
if(mysql_num_rows($result)>0) { 
  // if the values match values in the database 
  return("true"); 
}else{
   print "<center class='tabletext'>No Movies to Display</center>";
}
?>
</td>
    <!-- InstanceEndEditable --></tr>
</table>
<map name="Map">
  <area shape="rect" coords="18,9,186,27" href="viewEntireLibrary.php" alt="View the Entire Library">
  <area shape="rect" coords="18,32,186,51" href="viewYourLibrary.php" alt="View Your Library">
  <area shape="rect" coords="18,57,186,75" href="checkin_out.php" alt="Checkin &amp; Checkout">
  <area shape="rect" coords="18,81,187,99" href="editYourLibrary.php" alt="Edit Your Movies">
  <area shape="rect" coords="18,105,187,123" href="add2Library.php" alt="Add a Movie">
  <area shape="rect" coords="18,129,186,147" href="editProfile.php" alt="Edit Your Profile">
</map>
</body>
<!-- InstanceEnd --></html>

Sorry that it's so much code, but thanks

feldon23

I can't see anything wrong from here.

Is the HTML finishing? I mean if you load up the page, is it getting to </body></html> ?

reub77

Yup, everything is finishing great. The image isn't clickable. The php code all works and everything, just not the stupid image map. I can't figure it out.

Skull

i dont know if this will work or not but there is a one off chance it might...

why not move the image map before the php code and see if it makes a difference?

reub77

Yup, that worked.