PHP and Javascript work together!

xkrazykidx

I have a site that will be a music database, I am trying the most simple of of Javascripting where I hide and display a Div container but when I get it to work It completely stops the PHP Query.

Example Site : http://elixclothing.com/connection.php

Head:

<head>
<title>Test</title>
<link rel="stylesheet" href="stylesheet.css" type="text/css" />
<script src="ac_quicktime.js" language="JavaScript" type="text/javascript"></script>
<script type="text/javascript" src="webtoolkit.scrollabletable.js"></script>
<script type="text/javascript" src="webtoolkit.jscrollable.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>

<script type="text/javascript"> 
function toggle(id) { 
 if (document.getElementById(id)) { 
 var obj = document.getElementById(id); 
 obj.style.display=(obj.style.display == 'block')?'none':'block'; 
 } 
 else { alert('object not found'); } 
 return false; 
} 
</script> 
</head>

Body:

<html>
<?php 
include "head.php";
?>
<body>
<?php
include "navigation.php";
?>

  <?php
  mysql_connect("localhost", "root", "") or die(mysql_error());
  mysql_select_db("music") or die(mysql_error());
  $query = "SELECT * FROM tracks";
  $result = mysql_query($query) or die(mysql_error());

$cue_id = $_GET['cue'];

while($line = mysql_fetch_array($result))
	{
	if($cue_id == $line[1])
 	  {    

   	  $audioURL = $line[10];
    	  }
	else
	  {
	  }
}
?>



<div id="mydiv" style="display:none">
  <OBJECT CLASSID='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' WIDTH='290' HEIGHT='20'
CODEBASE='http://www.apple.com/qtactivex/qtplugin.cab'>
<PARAM name='AUTOPLAY' VALUE='true'>
<PARAM name='CONTROLLER' VALUE='true'>
<EMBED src="<?php print $audioURL; ?>" WIDTH='290' HEIGHT='20'
AUTOPLAY='false' CONTROLLER='true'
PLUGINSPAGE='http://www.apple.com/quicktime/download/'>
</EMBED>
</OBJECT>
</div>



<table align="center" border="1" width="800px" cellpadding="2" cellspacing="2"> 
<tr> 
<td align="left">Cue Code</td> 
<td align="left">Cue Title</td> 
<td align="left">Cue Description</td> 
<td align="left">Time</td>
<td align="left"><0></td>
</tr> 
<br />

<?php
  mysql_connect("localhost", "root", "") or die(mysql_error());
  mysql_select_db("music") or die(mysql_error());
  $query = "SELECT * FROM tracks";
  $result = mysql_query($query) or die(mysql_error());

$cue_id = $_GET['cue'];

while($line = mysql_fetch_array($result))
	{
	echo "<td align='left'>".$line['cue_code']."</td>"; 
	echo "<td align='left'>".$line['cue_title']."</td>"; 
	echo "<td align='left'>".$line['cue_description']."</td>"; 
	echo "<td align='left'>".$line['time']."</td>";
	echo '<td align="center"><a href="."?cue='.$line['cue_code'].' onclick="return toggle(\'mydiv\');"><img src="speaker_dark.gif" border="0"></a></td>'; 
	echo "</tr>";

if($cue_id == $line[1])
  {    
  $audioURL = $line[10];
	  }
else
  {
  }


}
?>
</table>



</body>
</html>

Any help would be greatly appreciated. I would just like for it to work as well as pull the correct audio tracks.

awbrowni30

Hey Try this... just something quick and dirty. Let me know how it works out... 🙂

<?php
include "head.php";
?>
<body>
<?php
include "navigation.php";
?>

<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("music") or die(mysql_error());
$query = "SELECT * FROM tracks";
$result = mysql_query($query) or die(mysql_error());

$cue_id = $_GET['cue'];

while ($line = mysql_fetch_array($result)) {
$bodyText = '<td align='left'>".$line['cue_code']."</td>
<td align='left'>".$line['cue_title']."</td>
<td align='left'>".$line['cue_description']."</td>
<td align='left'>".$line['time']."</td>
<td align="center"><a href="."?cue='.$line['cue_code'].' onclick="return toggle(\'mydiv\');"><img src="speaker_dark.gif" border="0"></a></td>
</tr>";

if($cue_id == $line[1]) $audioURL = $line[10];

}
?>

<div id="mydiv" style="display:none">
<OBJECT CLASSID='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' WIDTH='290' HEIGHT='20'
CODEBASE='http://www.apple.com/qtactivex/qtplugin.cab'>
<PARAM name='AUTOPLAY' VALUE='true'>
<PARAM name='CONTROLLER' VALUE='true'>
<EMBED src="<?php print $audioURL; ?>" WIDTH='290' HEIGHT='20'
AUTOPLAY='false' CONTROLLER='true'
PLUGINSPAGE='http://www.apple.com/quicktime/download/'>
</EMBED>
</OBJECT>
</div>

<table align="center" border="1" width="800px" cellpadding="2" cellspacing="2">
<tr>
<td align="left">Cue Code</td>
<td align="left">Cue Title</td>
<td align="left">Cue Description</td>
<td align="left">Time</td>
<td align="left"><0></td>
</tr>
<br />

<? echo $bodyText; ?>
</table>

</body>
</html>