:::
12. java上傳及影片播放
12-1 上課範例：data.php
<?php
/*-----------引入檔案區--------------*/
include_once "header.php";
include_once "up_file.php";
/*-----------function區--------------*/
$op=isset($_GET['op'])?$_GET['op']:"";
$sn=isset($_GET['sn'])?$_GET['sn']:"";
switch($op){
case "photo":
$main=get_photo($sn);
break;
case "file":
$main=get_files($sn);
break;
default:
$sql = "select * from `".$xoopsDB->prefix("contact")."` where `sn` = '{$sn}' ";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
$all=$xoopsDB->fetchArray($result);
//以下會產生這些變數： $tel , $email , $name , $gsn , $sn , $birthday , $zip , $county , $city , $addr
foreach($all as $k=>$v){
$$k=$v;
}
$main="
<table summary='list_table' id='tbl' style='width:100%;'>
<tr><th nowrap>姓名</th><td>{$name}</td></tr>
<tr><th nowrap>電話</th><td>{$tel}</td></tr>
<tr><th nowrap>信箱</th><td>{$email}</td></tr>
<tr><th nowrap>生日</th><td>{$birthday}</td></tr>
<tr><th nowrap>地址</th><td>{$zip} {$county}{$city}{$addr}</td></tr>
</table>";
break;
}
$sql = "select sn,name from `".$xoopsDB->prefix("contact")."` ";
$result = $xoopsDB->query($sql);
while(list($sn,$name)=$xoopsDB->fetchRow($result)){
$selected=($sn==$_GET['sn'])?"selected":"";
$option.="<option value='$sn' $selected>$name</option>";
}
echo "<!DOCTYPE html>
<html>
<head>
<title></title>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='".XOOPS_URL."/modules/tadtools/jquery.mobile/jquery.mobile.css' />
<script src='".XOOPS_URL."/modules/tadtools/jquery/jquery.js'></script>
<script src='".XOOPS_URL."/modules/tadtools/jquery.mobile/jquery.mobile.js'></script>
</head>
<body>
<div data-role='page' id='p1'>
<div data-role='header'>
<a data-icon='arrow-l' data-rel='back'>回上頁</a>
<h3><select onChange=\"location.href='data.php?op=$op&sn=' + this.value\">$option</select></h3>
<a href='pda.php' data-icon='home'>回首頁</a>
<div data-role='navbar' >
<ul>
<li><a href='data.php?op=base&sn={$_GET['sn']}' data-icon='star' data-iconpos='top' data-theme='a'>基本資料</a></li>
<li><a href='data.php?op=photo&sn={$_GET['sn']}' data-icon='search' data-iconpos='top' data-theme='a'>相關相片</a></li>
<li><a href='data.php?op=file&sn={$_GET['sn']}' data-icon='check' data-iconpos='top' data-theme='a'>相關檔案</a></li>
</ul>
</div>
</div>
<div data-role='content'>
{$main}
</div>
<div data-role='footer'></div>
</div>
</body>
</html>
";
function get_photo($sn=""){
$photo_file=get_pic_file('photo' , $sn , 1 );
$photo="<img src='{$photo_file}'>";
return $photo;
}
function get_files($sn=""){
$file=show_files('files' , $sn );
return $file;
}
?>
