主页
返回
上传文件
创建文件
编辑文件 ./tbb.php
当前文件编码
UTF-32
UTF-32BE
UTF-32LE
UTF-16
UTF-16BE
UTF-16LE
UTF-8
UTF-7
UTF7-IMAP
ASCII
EUC-JP
SJIS
eucJP-win
EUC-JP-2004
SJIS-win
SJIS-DOCOMO
SJIS-KDDI
SJIS-SOFTBANK
MacJapanese
SJIS-2004
UTF-8-DOCOMO
UTF-8-Mobile#KDDI-A
UTF-8-KDDI
UTF-8-SOFTBANK
CP932
CP51932
JIS
ISO-2022-JP
ISO-2022-JP-MS
GB18030
Windows-1252
Windows-1254
ISO-8859-1
ISO-8859-2
ISO-8859-3
ISO-8859-4
ISO-8859-5
ISO-8859-6
ISO-8859-7
ISO-8859-8
ISO-8859-9
ISO-8859-10
ISO-8859-13
ISO-8859-14
ISO-8859-15
ISO-8859-16
GB2312
GBK
HZ
EUC-TW
BIG-5
CP950
EUC-KR
UHC
ISO-2022-KR
Windows-1251
CP866
KOI8-R
KOI8-U
ArmSCII-8
CP850
JIS-ms
ISO-2022-JP-2004
ISO-2022-JP-KDDI
CP50220
CP50220raw
CP50221
CP50222
»
保存文件编码
UTF-32
UTF-32BE
UTF-32LE
UTF-16
UTF-16BE
UTF-16LE
UTF-8
UTF-7
UTF7-IMAP
ASCII
EUC-JP
SJIS
eucJP-win
EUC-JP-2004
SJIS-win
SJIS-DOCOMO
SJIS-KDDI
SJIS-SOFTBANK
MacJapanese
SJIS-2004
UTF-8-DOCOMO
UTF-8-Mobile#KDDI-A
UTF-8-KDDI
UTF-8-SOFTBANK
CP932
CP51932
JIS
ISO-2022-JP
ISO-2022-JP-MS
GB18030
Windows-1252
Windows-1254
ISO-8859-1
ISO-8859-2
ISO-8859-3
ISO-8859-4
ISO-8859-5
ISO-8859-6
ISO-8859-7
ISO-8859-8
ISO-8859-9
ISO-8859-10
ISO-8859-13
ISO-8859-14
ISO-8859-15
ISO-8859-16
GB2312
GBK
HZ
EUC-TW
BIG-5
CP950
EUC-KR
UHC
ISO-2022-KR
Windows-1251
CP866
KOI8-R
KOI8-U
ArmSCII-8
CP850
JIS-ms
ISO-2022-JP-2004
ISO-2022-JP-KDDI
CP50220
CP50220raw
CP50221
CP50222
<?php include "inc/conn.php";?><?php include "inc/excel.php";?> <?php include "inc/pubs.php";?><?php $tts = date("YmdHis",time());?> <!doctype html> <html lang="zh-CN"> <head> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width,minimum-scale=1.0,maximum-scale=1.0" /> <meta name="apple-mobile-web-app-capable" content="yes" /> <title><?php echo $title;?>,通用查询系统</title> <meta name="by-chafenba-com" content="9c79a8773df414763d0eef0c23553205" /> <meta property="ai:yaha" content="aba02efe91423a31f2b04d84951dd280" /> <meta name="author" content="yujianyue, admin@ewuyi.net"> <meta name="copyright" content="www.12391.net"> <link href="inc/css/style.css?s125=V200226_1506403G&t=180328" rel="stylesheet" type="text/css" /> <link rel="stylesheet" href="echart/css/index.css?s125=V200226_1506403G"> <script type="text/javascript" src="echart/scripts/my_index.js?s125=V200226_1506403G"></script> <script type="text/javascript" src="echart/scripts/echarts.min.js?s125=V200226_1506403G"></script> <script type="text/javascript" src="inc/js/js.js?s125=V200226_1506403G&t=180328"></script> </head> <body onLoad="inst();"> <div class="html"> <div class="divs" id="divs"> <div id="head" class="head" onClick="location.href='?t=<?php echo $tts;?>';"> <?php echo $title;?> <!--div class="back" id="pageback"> <a href="?t=<?php echo $tts;?>" class="d">更多</a> </div--> </div> <div class="main" id="main"> <?php /** * index.php LW2XTB:0451e248e06a880b11e25f5168f3b7183G * Created by yichaxin.com V200226_150640125 * @author yujianyue<admin@ewuyi.net> * Date: 200226@1255e561916281d1_12391.net * 注意;著作权所有,不得公开发布和出售 */ $stime=microtime(true); $codes = trim($_POST['code']); $shujus = trim($_POST['time']); $shuru1 = tram($_POST['name']); $shuru2 = tram($_POST['sfzh']); if(!$shujus){ //index.php?t=200226@1255e561916281d1&m=0451e248e06a880b11e25f5168f3b718 ?> <form name="queryForm" method="post" action="?t=<?php echo $tts;?>" onSubmit="return Check3G(0);"> <div class="select" id="10"> <select name="time" id="time" onBlur="Check3G(1)" > <?php traverse($UpDir."/",$dbtype);?></select></div> <div class="so_box" id="11"> <input name="name" type="text" class="txts" id="name" value="" placeholder="请输入<?php echo $tiaojian1;?>" onFocus="st('name',1)" onBlur="Check3G(2)" /> </div> <div class="so_box" id="22"> <input name="sfzh" type="password" class="txts" id="sfzh" value="" placeholder="请输入<?php echo $tiaojian2;?>" onFocus="st('sfzh',2)" onBlur="Check3G(4)" /> </div> <?php if($ismas=="1"){ ?> <div class="so_box" id="33"> <input name="code" type="text" class="txts" id="code" placeholder="请输入验证码" onFocus="this.value=''" onBlur="Check3G(3)" /> <div class="more" id="clearkey"> <img src="inc/code.php?t=<?php echo $tts;?>" id="Codes" onClick="this.src='inc/code.php?t='+new Date();" /> </div></div> <?php }?> <div class="so_but"> <input type="submit" name="button" class="buts" id="sub" value="立即查询" /> <input type="button" class="buts" value="刷新本页" name="print" onClick="location.reload();"> </div> <div class="so_bus" id="tishi"> 说明:【<?php echo $tiaojian1;?>+<?php echo $tiaojian2;?><?php if($ismas=="1"){ ?>+验证码<?php }?>】都输入正确才显示相应结果。 <!--你的其他说明在这里添加:开始--> <?php if(!file_exists($doup2s)){ //echo "<!-- $doup2s 不存在 -->"; }else{ echo file_get_contents($doup2s); } ?> <!--你的其他说明在这里添加:结束--> </div> <div id="tishi1" style="display:none;">请输入<?php echo $tiaojian1;?></div> <div id="tishi2" style="display:none;">请输入<?php echo $tiaojian2;?></div> <div id="tishi4" style="display:none;">请输入4数字验证码</div> </form> <?php }else{ if($ismas=="1"){ session_start(); if($codes!=$_SESSION['Code3G']){ webalert("请正确输入验证码!"); } } if(!$shuru1){ webalert("请输入$tiaojian1!"); } if(!$shuru2){ webalert("请输入$tiaojian2!"); } $files = $UpDir."/".$shujus.$dbtype; $files = charaget($files); if(!file_exists($files)){ $files = characet($files); } if(!file_exists($files)){ webalert('请检查数据库文件'); }else{ echo '<h2> </h2><p align="center"> '; //echo $shujus; echo '</p>'; } echo '<!--startprint-->'; $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('UTF-8'); $data->read($files); $tabs = array(); for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) { if($i=="1"){ $iaa=0; $iab=0; $iac=0; echo "<table cellspacing=\"0\">"; echo "<caption align=\"center\">$shujus<!--这里是表格标题--></caption><thead>"; echo '<tr class="tt">'; for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) { $taba = ''.$data->sheets[0]['cells'][$i][$j].''; $ix++; echo '<td>'.$taba.'</td>'; $io++; if($taba==$tiaojian1){ $iaa=$io; } if($taba==$tiaojian2){ $iab=$io; } } echo "</tr></thead><tbody>"; if(strlen($iaa)<1){ webalert('请检查Excel数据第1行是否存在【'.$tiaojian1.'】字段!'); } if(strlen($iab)<1){ webalert('请检查Excel数据第1行是否存在【'.$tiaojian2.'】字段!'); } echo "\r\n"; }else{ $Excelx=Tram($data->sheets[0]['cells'][$i][$iaa]); $Excely=Tram($data->sheets[0]['cells'][$i][$iab]); if("_".$shuru1=="_".$Excelx && "_".$shuru2=="_".$Excely){ //echo "<!-- $shuru1 == $Excelx $shuru2 == $Excely -->\r\n"; $iae++; echo '<tr>'; $taby=array(); $biti = Trim($data->sheets[0]['cells']['1'][$titles]); $bivi = Trim($data->sheets[0]['cells'][$i][$titles]); $taby[$biti]=$bivi; for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) { $tabe = ''.$data->sheets[0]['cells']['1'][$j].''; $tabu = Trim($data->sheets[0]['cells'][$i][$j]); echo '<td >'.$tabu.'</td>'; if(stristr($fenshu,"|{$tabe}|")){ $taby[$tabe]=$tabu; //分数列 } } echo "</tr>\r\n"; array_push($tabs,$taby); } } } if($iae<1){ $shuru1 = rephtmls($shuru1); $shuru2 = rephtmls($shuru2); echo '<tr>'; echo "<td colspan={$j} >没有查询到$tiaojian1 = $shuru1 且 $tiaojian2 = $shuru2 相关信息哦</td>"; echo '</tr>'; } echo "<tbody></table>\r\n"; echo '<!--endprint-->'; if($iae>0){ echo "<div id=\"ECharts_main\"><div id=\"select_tip\">图表显示区</div></div>"; if($iae>1){ //多条 多折线图 $jsarr = "var jsdata = ".json_encode($tabs,JSON_UNESCAPED_UNICODE); echo "<script type=\"text/javascript\">$jsarr</script>"; echo "<script type=\"text/javascript\">getLineChartFromJson(jsdata,\"{$shujus}\");</script>"; }else{ //单条 饼图 $tabs= array(); foreach($taby AS $t=>$v){ $taby= array(); $taby["科目"]=$t; //分数列 $taby["内容"]=$v; //分数列 array_push($tabs,$taby); } $jsarr = "var jsdata = ".json_encode($tabs,JSON_UNESCAPED_UNICODE); echo "<script type=\"text/javascript\">$jsarr</script>"; echo "<script type=\"text/javascript\">getPieChartFromJson(jsdata,\"{$shujus}\");</script>"; } } ?> <div class="so_but"> <input type="button" class="buts" value="预 览" name="print" onClick="preview()"> <input type="button" class="buts" value="返 回" id="reset" onClick="location.href='?t=back';"></div> <?php } $etime=microtime(true); $total=$etime-$stime; echo "<!----页面执行时间:{$total} ]秒--->"; ?> </div> <div class="boto" id="boto"> ©<?php echo date('Y');?> <a href="<?php echo $copyu;?>" target="_blank"><?php echo $copyr;?></a> </div> </div> </div> </body> <!--LW2XTB_index.php_V200226_150640_3G --> </html>
左侧上传操作菜单,底部删除操作按钮,详情联系QQ:81990101