在线客服QQ: 176797520 极酷FlvPlayer在线客服 酷播网页视频播放器

6.2 与PHP+Mysql结合的应用

高级应用可以实现通过获取FlvID或ListID这样的参数,传给JcScpFile[配置文件],配置文件接收传过来的FlvID或ListID,再进行查询数据库,最终匹配出对应的配置文件参数,从而播放视频。
简要过程说明(本例以php为例,其过程与ASP实际是类似的):
1. /Player/player.swf?FlvID=745,此处写入视频ID;
2. JcScpFile[配置文件]/Player/CuSunV2Set.php会接收以上传过来的FlvID=745,此时,也就是相当于/Player/CuSunV2Set.php?FlvID=745
3. 现在很清楚了,就是在/Player/CuSunV2Set.php?FlvID=745中,程序获取FlvID=745,再进行查询数据库,匹配出对应的配置文件参数
 
例(3)-1:使用[ HTML代码参数 ]
第一部分:在html中使用您需要的[ HTML代码参数 ]

<script type="text/javascript" src="images/swfobject.js"></script>

<div class="video" id="CuPlayer"><b>网页视频播放器加载中,请稍后...</b></div>
<script type="text/javascript">
var so = new SWFObject("/Player/player.swf?FlvID=745","ply","520","325","9","#000000");
so.addParam("allowfullscreen","true");
so.addParam("allowscriptaccess","always");
so.addParam("wmode","opaque");
so.addParam("quality","high");
so.addParam("salign","lt");
so.addVariable("JcScpFile","/Player/CuSunV2Set.php");
so.write("CuPlayer");
</script>

第二部分,以下是配置文件CuSunV2Set.php代码如下 (提示:注意以下的标红的数字序号) :

<?php
require_once("config.php");
@include("My89525_myfunction.php");

$FlvID=chkstr($_GET["FlvID"],2);//①. 获取第一部分中传过来的FlvID
$conn = @mysql_connect($dbhost,$dbusername,$dbpassword) or die ("Can't connect db server");
@mysql_select_db($dbname,$conn) or die ("Can't select db");
@mysql_query("SET NAMES 'gb2312'");
//@mysql_query("SET NAMES 'utf8'");
//’②. 此处对传过来FlvID的值,进行查询

$exec="SELECT * FROM jcplayer where id ='$FlvID' ";
$result=mysql_query($exec);
④. 此处rs匹配结果
$rs=mysql_fetch_object($result);
?>

<?xml version="1.0" encoding="gb2312"?>
<CuPlayer>
<Player_Set
JcScpBufferTime = "5"
JcScpVolume = "75"
JcScpAutoPlay = "yes"
JcScpAutoRepeat = "no"
JcScpImgDisplay = "no"
JcScpAutoHideControl="no"
JcScpControlHideTime="0.5"
JcScpControlHeight="40"
JcScpShowList= "showad"
JcScpShowListInfo= "no,yes,next,showad"
JcScpsetMode = "1"
JcScpsetModeInfo ="1:exactMode,2:strechMode,3:normalMode:,4:doubleMode"
JcScpCode = "gb2312"
JcScpAFrontCanClose = "no"

/>
<Logo_Set
JcScpLogoDisplay = "yes"
JcScpLogoPath = "Images/logo.png"
JcScpLogoPosition = "top-left"
JcScpLogoWidth = "165"
JcScpLogoHeight = "55"
JcScpLogoAlpha = "0.5"
/>
<Flashvars_Set
JcScpServer =""
<!-- ⑤. 赋值给对应的参数,用以传入播放器进行播放。至此传值完毕-->
JcScpVideoPath = "<?php echo $rs->JcScpVideoPath?>"
JcScpVideoPathHD = "<?php echo $rs->JcScpVideoPathHD?>"
JcScpImg ="<?php echo $rs->JcScpImg?>"


ShowJcScpAFront = "yes"
JcScpCountDowns = "10"
JcScpCountDownsPosition = "top-right"
JcScpAFrontW = "645"
JcScpAFrontH = "300"
JcScpAFrontPath = "Images/SevenColorPlayer_650x418.swf"
JcScpAFrontLink = "http://yxp.163.com/act/20120214.html"

ShowJcScpAVideo= "no"
JcScpAVideoPath= "http://vf1.mtime.cn/Video/2012/07/11/flv/120711093250238753.flv"
JcScpAVideoLink= "http://yxp.163.com/act/20120214.html"

ShowJcScpAPause = "yes"
JcScpAPausePath = "Images/SevenColorPlayer_a1.swf"
JcScpAPauseW = "375"
JcScpAPauseH = "230"
JcScpAPauseLink= "http://yxp.163.com/act/20120214.html"
ShowJcScpACorner = "yes"
JcScpACornerPath= "Images/SevenColorPlayer_a10.swf"
JcScpACornerW = "80"
JcScpACornerH = "50"
JcScpACornerPosition = "top-right"
JcScpACornerLink = "http://yxp.163.com/act/20120214.html"

ShowJcScpAEnd = "yes"
JcScpAEndPath = "Images/Cover_changfa.jpg"
JcScpAEndW = "400"
JcScpAEndH = "200"
JcScpAEndLink= "http://yxp.163.com/act/ShowJcScpAEnd466.html"
/>

......
......