先看圖，后有完整代碼?
?
文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-837240.html
<?php
$t = "Excel數(shù)據(jù)轉(zhuǎn)Sql查詢系統(tǒng)字段半智能分析";
$s = "Excel復(fù)制過(guò)來(lái)的二維結(jié)構(gòu)表內(nèi)容,分析查詢條件！";
$x = "字段|最大長(zhǎng)度|長(zhǎng)度有|數(shù)字字段|空值存在|純姓名|英文用戶名|科學(xué)計(jì)數(shù)|是否等長(zhǎng)|是否唯一";
$xx= explode("|",$x);
function isname($str) {
$pattern = '/^[\x{4e00}-\x{9fa5}]{2,8}$/u'; // Unicode編碼范圍內(nèi)的漢字
return preg_match($pattern, $str);
}
function isuser($str) {
$pattern = '/^[a-zA-Z0-9_\-]{6,18}$/'; //
return preg_match($pattern, $str);
}
$tt=array();
$tt["空值存在"]="查詢條件列內(nèi)容如果空值則查詢不到";
$tt["純漢字姓名特征"]="是(2-6漢字):適合查詢條件";
$tt["英文用戶名特征"]="是(6-16字母數(shù)字):適合查詢條件";
$tt["科學(xué)計(jì)數(shù)"]="數(shù)值已科學(xué)計(jì)數(shù),會(huì)影響數(shù)值精度和人眼識(shí)別；如果是查詢條件則查詢不到!";
$datedir = "";
if($_GET["x"] == "cha"){
$base = isset($_POST['tips']) ? $_POST['tips'] : "";
$files="S2".date("YmdHis");
$uptis = "上傳失?。?;
if(!stristr($base,"\t"))$uptis .= "制表符;";
if(!stristr($base,"\n"))$uptis .= "回車符;";
if($uptis<>"上傳失敗：") exit("提交內(nèi)容由Excel復(fù)制過(guò)來(lái):應(yīng)當(dāng)包含:".$uptis);
file_put_contents($datedir.$files.".csv", $base);
$file = fopen($datedir.$files.".csv", 'r');
$header = fgetcsv($file, 0, "\t");
$nozd = count($header); $jj=0;
$max_lengths = array_fill(0, $nozd, 0); //字段最長(zhǎng)
$lengths = []; //字段長(zhǎng)度
$strlist = []; //字段集合
$lies = []; //字段集合
$num_str = array_fill(0, $nozd, "是"); //是否全數(shù)字
$is_null = array_fill(0, $nozd, "No"); //是否空值
$is_user = array_fill(0, $nozd, "<b>是</b>");
$is_name = array_fill(0, $nozd, "<b>是</b>");
while (($line = fgetcsv($file,0,"\t")) !== false) {
$jj ++; if(count($line)<>$nozd) $lies[] = $jj;
foreach ($line as $i => $value) {
$strlist[$i][] = $value;
$lenx = strlen($value);
$lengths[$i][] = strlen($value);
if( Trim($value)=="" ) $is_null[$i] = "<b>是</b>";
if( !is_numeric($value) ) $num_str[$i] = "否";
if( !isuser($value) ) $is_user[$i] = "否";
if( !isname($value) ) $is_name[$i] = "否";
$max_lengths[$i] = max($max_lengths[$i], strlen($value));
}
}
fclose($file);
echo "<h3>分析結(jié)果:<strong>機(jī)器識(shí)別,僅供參考</strong></h3>\r\n";
echo "<table cellspacing=\"0\" class=\"table\" cellpadding=\"0\">\r\n";
echo "<tr class='tt'><td>".join("</td><td>",$xx)."</td></tr>\r\n";
for($ii=0;$ii<$nozd;$ii++){
$line = [];
$uni = array_count_values($strlist[$ii]); $una = array_keys($uni); $unb = join(";",$una);
$lilen = array_unique($lengths[$ii]); $listl = join(",",$lilen);
$line["字段"] = $header[$ii];
$line["最長(zhǎng)長(zhǎng)度"] = $max_lengths[$ii];
$line["字段長(zhǎng)度有"] = $listl;
$line["字段屬性"] = $num_str[$ii];
$line["空值存在"] = $is_null[$ii];
$line["漢字名字"] = $is_name[$ii];
$line["用戶名"] = $is_user[$ii];
preg_match_all("/[+-]?[\d]+([\.][\d]+)?[Ee][+-]?[\d]+/", $unb, $match);
$kes = count($match[0]);
if($kes>0){ $line["科學(xué)計(jì)數(shù)"] = "異常<b>$kes</b>處";}else{ $line["科學(xué)計(jì)數(shù)"] = "正常";}
if(count($lilen)==1) $line["是否等長(zhǎng)"] = "是"; else $line["是否等長(zhǎng)"] = "否";
$isc = array_diff($uni, [1]);
if(count($isc)<1) $line["是否唯一"] = "是"; else $line["是否唯一"] = "否";
echo "<tr><td>".join("</td><td>",$line)."</td></tr>\r\n";
}
echo "</table>\r\n";
echo "<p><b>請(qǐng)核對(duì):</b>核對(duì)數(shù)據(jù)：{$jj}行{$nozd}列</p>\r\n";
if(count($lies)>0) echo "<p><b>有".count($lies)."行</b>(行:".join(",",$lies).")列數(shù)與標(biāo)題列數(shù)({$nozd})不一致</p>\r\n";
foreach($tt as $ti=>$tv){ echo "<p><b>$ti</b>: $tv</p>";}
exit();
}
?>
<!DOCTYPE html>
<html>
<head>
<title><?php echo $t; ?></title>
<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" />
<script type="text/javascript">
console.log("問(wèn)題反饋電話:","15058593138");
console.log("問(wèn)題反饋郵件:","admin@12391.net");
function $(objId){
return document.getElementById(objId);
}
function loadcha(xid) {
var xmlhttp;
var Stxt= "nums=aa";
Stxt+="&tips="+ encodeURIComponent($("tips").value);
//$("tips").innerHTML = "正在加載...";
if (window.XMLHttpRequest) {
xmlhttp = new XMLHttpRequest();
} else {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
var btxt = xmlhttp.response;
if(btxt == "err01"){ $("tipx").innerHTML = "!"; return false;}
$('tipx').innerHTML = xmlhttp.response;
}
}
xmlhttp.open("POST", "?x=cha&tt="+Math.random(), true);
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlhttp.send(Stxt);
}
</script>
<style>
div,#tipx{display:block;width:99.7%;border:0;margin-top:5px;}
textarea{display:block;width:99.7%;border:1px solid #ccc;height:160px;}
table{margin:20px auto;border-left:1px solid #a2c6d3;border-top:3px solid #0180CF;font-size:12px;width:99.7%;}
table td{border-right:1px solid #a2c6d3;border-bottom:1px solid #a2c6d3;padding:2px;word-wrap:break-word;word-break:break-all;}
td{min-width:30px;max-width:490px;}
.tt{background-color: #f2f2f2;}
b{color:red;}
#submit{ height:35px;}
</style>
</head>
<body>
<form class="form" id="form" method="POST" act="?act=cha" >
<p><?php echo $t; ?></p>
<textarea id="tips">
姓名 學(xué)號(hào) 身份證 科目1 科目2 科目3 科目4 科目5 科目. 科目N
李一一 10001001 90001001 87 84 75 91 83 76 87
李二 10001002 90001001 95 81 81 71 60 8299
李三 10001003 90001003 68 80 65 79 68 71 91
李四 10001004 90001004 82 80 75 90 87 1.23457E+15 81
李五 10001005 90001005 60 64 61 71 73 61
李六 10001006 90001006 62 69 77 73 96 6 82
李七 10001007 90001007 98 72 68 59 84 333 92
</textarea>
<input type="button" id="submit" value="提交分析" onclick="loadcha('xid')">
<div id="tipx"></div>
</form>
</body>
</html>僅供娛樂(lè)！文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-837240.html
到了這里，關(guān)于PHP分析二維數(shù)據(jù)表(長(zhǎng)度|數(shù)字字段|空值|純姓名|英文用戶名|科學(xué)計(jì)數(shù)|是否等長(zhǎng)|是否唯一)的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
