使用JW Player 6在PHP和MySQL中执行JavaScript一次循环

使用JW Player 6在PHP和MySQL中执行JavaScript一次循环

问题描述:

I'm using JWPlayer6 (non-commercial version) and I'm facing a serious problem, using a while loop to loop over all videos from a MySQL database using PHP. Unfortunately, the web page just shows one video from MySQL. When I checked the code in Chrome, I saw that inside the <div id='my-video'></div>, there's nothing to show. How should I fix the problem?

<?php
$result = mysql_query("SELECT * FROM schoolvideo GROUP BY folderName ORDER BY id desc");
while($data = mysql_fetch_array($result)) {
  $id = $data['id'];
  $video = $data['video'];
  $folderName = $data['folderName'];
?>
<div class="square">
  <div id='my-video'></div>
  <script type="text/javascript">
  jwplayer('my-video').setup({
    file: 'http://abc.com/video/<?php echo $folderName; ?>/<?php echo $video; ?>',
    width: '370',
    height: '270',
    primary: 'flash',
    image: 'http://abc.com/img/poster.png',
    autostart: false
  });
  </script>
</div>
<?php
}
?>

我正在使用JWPlayer6(非商业版),我正面临一个严重的问题,使用while循环 使用PHP循环来自MySQL数据库的所有视频。 不幸的是,该网页只显示了一个来自MySQL的视频。 当我在Chrome中检查代码时,我在&lt; div id ='my-video'&gt;&lt; / div&gt; code>中看到了这一点,没有什么可以显示的。 我该如何解决这个问题呢? p>

 &lt;?php 
 $ result = mysql_query(“SELECT * FROM schoolvideo GROUP BY folderName ORDER BY id desc”); 
while(  $ data = mysql_fetch_array($ result)){
 $ id = $ data ['id']; 
 $ video = $ data ['video']; 
 $ folderName = $ data ['folderName']; \  n?&gt; 
&lt; div class =“square”&gt; 
&lt; div id ='my-video'&gt;&lt; / div&gt; 
&lt; script type =“text / javascript”&gt; 
  jwplayer('my-video')。setup({
 file:'http://abc.com/video/<?php echo $ folderName;?&gt; /&lt;?php echo $ video;?&gt;  ',
宽度:'370',
高度:'270',
主要:'flash',
图像:'http://abc.com/img/poster.png',
自动启动:  false 
}); 
&lt; / script&gt; 
&lt; / div&gt; 
&lt;?php 
} 
?&gt; 
  code>  pre> 
  div>

Your loop will generate multiple divs with the same id "my-video". You should make them unique.

<div id='my-video-<?php echo $id ?>'></div>
...
jwplayer('my-video-<?php echo $id ?>').setup({...