婚庆网站有哪些,网页设计素材书店照片,开发者社区,三门峡做网站的公司自用PHP在线Access转html表格小功能(支持大文件上传,得到一表一文件) 本工具用于Access数据表转html下载供预览,特别适合各类程序员。 开发环境(可能只支持)Windows IIS PHP5.4 其他系统或新版本都不支持
?php
/*
//自用PHP在线Access转html表格小功能(支持大文件上传,得…自用PHP在线Access转html表格小功能(支持大文件上传,得到一表一文件) 本工具用于Access数据表转html下载供预览,特别适合各类程序员。 开发环境(可能只支持)Windows IIS PHP5.4 其他系统或新版本都不支持
?php
/*
//自用PHP在线Access转html表格小功能(支持大文件上传,得到一表一文件)
//本工具用于Access数据表转html下载供预览,特别适合各类程序员。
//作者信息:yujianyue15058593138qq.com 请保留版权信息
//开发环境(可能只支持)Windows IIS PHP5.4 其他系统或新版本都不支持
//不定期更新详情关注:https://Access2html.96448.cn/
*//*
广告易名一口价出售珍藏域名
网址https://135634.shop.ename.com/
域名 简介 类型 注册时间
yichabiao.cn 易查表(格) 易名一口价 2020/4/20
maLide.cn 码立得 易名一口价 2020/4/22
echafen.cn 易名一口价 2016/8/29
11170.cn 5数客服米 易名一口价 2012/9/5
aiyaha.com 哎呀哈 易名一口价 2014/10/9
mabida.com 易名一口价 2015/4/5
saoLide.cn 扫(码)立得 易名一口价 2021/4/21
Lidehui.cn 立得惠 易名一口价 2021/6/4
96448.cn 谐音:就来试试吧 易名一口价 2011/9/28
souLide.cn 搜立得 易名一口价 2020/4/9
*///error_reporting(0);
$biaoti 自用PHP在线Access转html表格小功能(Access2html);
$dlimi 1; //分片大小MB
$zlimi 10; //总文件限制MB
$upext .mdb|.asa;//上传格式限定;|隔开
$upexe str_replace(|,,,$upext);//上传格式限定
$tima date(YmdHis);
//以下只为获得功能页面网址用于上传文件网址拼接
$iport $_SERVER[SERVER_PORT];
$indes $_SERVER[SCRIPT_NAME];
$inder dirname($_SERVER[PHP_SELF]);
$ihost $_SERVER[HTTP_HOST];
if(stristr(-443-,-$iport-)){
$ihosts https://$ihost{$inder};
}elseif(stristr(-80-,-$iport-)){
$ihosts http://$ihost{$inder};
}else{
$ihosts http://$ihost:{$iport}{$inder};
}
/*
免费查询系统下载: http://96448.cn
phpmysql系列查询系统 http://sql.chalide.cn
phpTxt系列查询系统 http://txt.chalide.cn
一站式万用查询平台1:http://chalide.com
一站式万用查询平台2:http://add.12391.net
*/
$css meta charset\utf-8\ /;
$css . style\r\n *{margin:0; padding:0; font-size:12px;};
$css . table{margin:5px auto;border-left:1px solid #a2c6d3;border-top:3px solid #0180CF;width:96vw;};
$css . table td{border-right:1px solid #a2c6d3;border-bottom:1px solid #a2c6d3;};
$css . table td{padding:5px;word-wrap:break-word;word-break:break-all;max-width:300px;};
$css . .tt{background:#e5f2fa;line-height:150%;font-size:14px;padding:5px 9px;};
$css . /style;
function jsonMsg($code,$msg,$url){$arr []; $arr[code] $code; $arr[msg] $msg; $arr[url] $url;header(Content-type: application/json);exit(json_encode($arr));
}
function heFile($filebath,$bnum) {$wfp fopen($filebath, $bnum 1 ? wb : ab);$rfp fopen($_FILES[file][tmp_name], rb);$bool false;while ($buff fread($rfp, 4096)) {if(!$bool fwrite($wfp, $buff)) return $bool;}fclose($wfp);fclose($rfp);return $bool;
}
function characet($data){if(!empty($data) ){ $fileType mb_detect_encoding($data , array(UTF-8,GBK,LATIN1,BIG5)) ; if( $fileType ! UTF-8){ $data mb_convert_encoding($data ,utf-8 , $fileType); } } return $data;
}
//如果含html则替换
function reps($stext){
$stext str_replace(array(, ,), array(lt;, gt;), $stext);
$stext str_replace(array(\r\n,\r,\n),br /,$stext);
return characet($stext);
}
function db2zip($zipfile,$dbsname,$tima){
global $css;
if(!file_exists($dbsname)){ exit(存储路径出错!); }$shuoy h1$dbsname/h1; $zip new ZipArchive;
$res $zip-open($zipfile, ZipArchive::CREATE);
if ($res TRUE) {
//当前读取无密码数据文件
$cstr DRIVERMicrosoft Access Driver (*.mdb);DBQ{$dbsname};
$conn odbc_connect($cstr,,,SQL_CUR_USE_ODBC ) or die (数据库连接错误!);
$result odbc_tables($conn); $table[];
while (odbc_fetch_row($result)){
if(odbc_result($result,TABLE_TYPE)TABLE) $table[] odbc_result($result,TABLE_NAME);
}odbc_close($conn);if(count($table)1){ exit(读取失败:空白数据表!);}
foreach($table as $rowname){$rawhtml showbiao($dbsname,$rowname);$zip-addFromString($rowname.html, $css.$rawhtml);$shuoy . pa href\$rowname.html\ target_blank$rowname/a/p\r\n;
}
//$zip-addFile(chalide.zip,chalide.zip);
$zip-addFromString(_ReadMe.txt, $shuoy);
$zip-close();
} else {
exit(fail zipZipArchive failure);
}
}
function showbiao($dbsname,$rewname){
$cstr DRIVERMicrosoft Access Driver (*.mdb);DBQ{$dbsname};
$conn odbc_connect($cstr,,,SQL_CUR_USE_ODBC ) or die (数据库连接错误!);
$query odbc_do($conn, select * from [{$rewname}]);
$fieldcount odbc_num_fields($query);
$h . table cellspacing\0\ class\table\ \r\n;
$h . caption表:$rewname ({$fieldcount}列)/caption;
$h . tr classtt;
for( $i0; $i$fieldcount; $i){
$info reps(odbc_field_name($query,$i1));
$h . tdnobr$info/nobr/td;
}
$h . /tr;
while ($row odbc_fetch_row($query)){
$iy; $h . tr;
for( $i0; $i$fieldcount; $i){
$info reps(odbc_result($query,$i1));
$h . td$info/td;
}
$h . /tr;
}
if($iy1){ $h . trtd colspan{$i}没有查询到相关信息哦/td/tr; }
$h . /table;
odbc_close($conn);
return $h;
}if($_FILES[file][tmp_name] $_POST[blob_num]){$filex $_FILES[file];$filen (isset($_POST[file_name]))?Trim($_POST[file_name]):;$timen (isset($_POST[nowYmd]))?Trim($_POST[nowYmd]):date(YmdHis).$uniqid();
if ($filex[error] 0){
$fer []; $ercode $filex[error];
$fer[1] 上传的文件超过了upload_max_filesize选项限制的值;
$fer[2] 上传文件的大小超过了表单MAX_FILE_SIZE选项指定的值;
$fer[3] 上传异常,文件只有部分被上传;
$fer[4] 文件空白或者说没有文件被上传;
$fer[6] 上传的临时文件丢失;
$fer[7] 文件写入失败建议检查文件夹读写权限;
if($fer[$ercode]){
jsonMsg(0,Error 00.$ercode.:.$fer[$ercode]);
}else{
jsonMsg(0,Error 00.$ercode.:未知上传错误!);
}
}else{
$info pathinfo($filen); $tape strtolower($info[extension]);
if(!stristr(|$upext|,|.{$tape}|)){ jsonMsg(0,Error 010,后缀.{$tape}不支持!);}
if($filex[size]$dlimi*1024*1024){ jsonMsg(0,Error 011,单片文件大小超{$dlimi}MB!);}
if($_POST[filesize]$zlimi*1024*1024){ jsonMsg(0,Error 012,文件总大小超{$zlimi}MB!);}
$filepath ./upload/; //存储路径
if(!is_dir($filepath)) { mkdir($filepath,0755,true);}
if(!is_dir($filepath)) { jsonMsg(0,Error 015,文件夹失败{$filepath}!);}
$filebath $filepath . $timen.$tape;
$bnum (isset($_POST[blob_num]))?addslashes($_POST[blob_num]):;
$tnum (isset($_POST[total_blob_num]))?addslashes($_POST[total_blob_num]):;
$fnum (isset($_POST[filesize]))?addslashes($_POST[filesize]):0;
if(!is_numeric($bnum) || !is_numeric($tnum)) jsonMsg(0,Error 0161,分片参数得数字!);
if(!is_numeric($fnum) ) jsonMsg(0,Error 0162,参数filesize得数字!);$urlx $ihosts.Ltrim($filebath,.)..zip;
if($bnum 1 $tnum1){move_uploaded_file($_FILES[file][tmp_name],$filebath);//直接更名保存$fsizefilesize($filebath);$fzip db2zip($filebath..zip,$filebath,$tima);if($fnum$fsize) jsonMsg(2,OK,$urlx); else jsonMsg(2,可能异常!,$urlx);
}elseif($bnum$tnum $tnum1){heFile($filebath,$bnum);jsonMsg(1,waiting $bnum/$tnum !);
}elseif($bnum$tnum $tnum1){heFile($filebath,$bnum);$fsizefilesize($filebath);$fzip db2zip($filebath..zip,$filebath,$tima);if($fnum$fsize) jsonMsg(2,OK$filebath,$urlx); else jsonMsg(2,可能异常!,$urlx);
}else{jsonMsg(0,Error 017,分片异常$bnum / $tnum!);
}
}
}?
!DOCTYPE html
html
headtitle?php echo $biaoti; ?/titlestyle typetext/cssbody {font-family: Arial, sans-serif;font-size: 14px;background-color: #f2f2f2;}h3{margin: 0;font-size: 18px;line-height: 1.8;color: blue;}p {margin: 0; font-size: 14px; line-height: 1.5;}#urls {color: blue;}.container {margin: 50px auto;padding: 20px 20px 50px 20px;background-color: #fff;border-radius: 5px;box-shadow: 0 0 10px rgba(0,0,0,0.3);max-width: 775px;}#mask{position: fixed; top: 0; left: 0; width: 100%; height: 100%;background-color: rgba(0,0,0,0.5); display: none;}#dialog{position: fixed; top: 50%; left: 50%;min-width: 300px; transform: translate(-50%,-50%);background-color: #fff; padding: 20px; border-radius: 5px;box-shadow: 0 0 10px rgba(0,0,0,0.5); display: none;}#dialog .btn, .bts{display: flex; float: left; padding: 5px 8px;background-color: #007bff; color: #fff; border-radius: 3px;cursor: pointer; margin: 10px 10px 10px 0;}#dialog .btn:hover, .bts:hover{background-color: #0069d9;}#progress{width: 100%; min-width: 300px; height: 20px;background-color: #f7f7f7;box-shadow: inset 0 1px 2px rgba(0, 0, 0, 0.1);border-radius: 4px;background-image: linear-gradient(to bottom, #f5f5f5, #f9f9f9);}.finish {background-color: #149bdf;background-image: linear-gradient(45deg, rgba(255, 255, 255, 0.15) 25%, transparent 25%, transparent 50%, rgba(255, 255, 255, 0.15) 50%, rgba(255, 255, 255, 0.15) 75%, transparent 75%, transparent);background-size: 20px 20px;height: 100%;}/style
/head
body
div classcontainerh3?php echo $biaoti; ?/h3p自用在线Access转html表格小功能(支持大文件上传,得到一表一文件)/pp说明限制大小?php echo $zlimi;?Mb支持?php echo $upexe?格式上传!/p?php echo p作用上传Access数据得到各表html表格数据!/p; ??php echo p环境可能仅支持WIN PHP5.4/Linux不支持/高版本PHP不支持!/p; ?div stylemargin-bottom:20px;display:block;button onclickup(file) classbts上传/button/divinput typefile idfile accept?php echo $upexe? styledisplay:none;
/divdiv idmask/divdiv iddialogdiv idprogressdiv iduend classfinish stylewidth: 0%; progress0/div/divdiv idback/divdiv idbutsbutton classbtn idok onclickhideDialog()确定/button/div/divscript typetext/javascript
function $(Obj){return document.getElementById(Obj);}
function up(Obj){ $(Obj).value; $(Obj).click();}var mask $(mask);function showDialog(){mask.style.display block;dialog.style.display block;}function hideDialog(){mask.style.display none;dialog.style.display none;}var tici Date.parse(new Date())/1000;var ufile $(file);var jdt_s $(uend);var ipt_s $(back);ufile.onchange function () {tici tici 1; $(back).innerHTML;jdt_s.style.width 1%; jdt_s.innerHTML ;showDialog();var vupload new Upload(jdt_s, ipt_s);//后移解决二次选择文件上传失败vupload.addFileAndSend(this);};function Upload(jdt, ipt) {const LENGTH 1024 * 1024 * ?php echo $dlimi;?;//分片上传每片数量MBvar start 0; var end start LENGTH;var blob; var blob_num 1;this.addFileAndSend function (that) {var file that.files[0];
if(!file){ ipt_s.innerHTML b未上传:/b未选择文件!; return false;}
if (!/(?php echo $upext;?)$/.test(file.name)){ipt_s.innerHTML b未上传:/b仅支持后缀格式?php echo $upexe;?!; return false;
}
if (file.size ?php echo $zlimi;? * 1024 * 1024){ipt_s.innerHTML b未上传:/b文件大小超?php echo $zlimi;?MB限制!; return false;
}blob cutFile(file);sendFile(blob, file);blob_num 1;};function cutFile(file) {var file_blob file.slice(start, end);start end; end start LENGTH;return file_blob;}function sendFile(blob, file) {var xhr new XMLHttpRequest();var fdata new FormData();var total_blob_num Math.ceil(file.size / LENGTH);fdata.append(file, blob);fdata.append(blob_num, blob_num);fdata.append(filesize, file.size);fdata.append(nowYmd, tici);fdata.append(total_blob_num, total_blob_num);fdata.append(file_name, file.name);xhr.open(POST, ?actuptMath.random(), false);xhr.onreadystatechange function () {var progress; var progressObj jdt;if (total_blob_num 1) {progress 100%;} else {progress Math.ceil((blob_num / total_blob_num) * 10000) / 100 %;}progressObj.style.width progress;progressObj.innerHTML progress;var tt setTimeout(function () {var jj JSON.parse(xhr.response);console.log(jj);if (jj.code 2 || jj.code 1) {if (start file.size) {blob cutFile(file);sendFile(blob, file);blob_num 1;}
if (jj.code 2){ $(back).innerHTMLh3上传成功:/h3下载:a hrefjj.url target_blankjj.url/a;}}
if (jj.code 0){ $(back).innerHTMLh3上传失败:/h3bjj.msg/b;}xhr undefined;fdata undefined;}, 500);};xhr.send(fdata);}}
/script/body
/html
