<?php
//假设10个文本保存路径在$path中
$path = '/file/';
$files = scandir($path);
//删除文件中.和..
array_splice($files,0,2);
//html页面输出变量；
$html = "title filepath percent
";
//假设数据库信息如下，打开数据库连接
$con = mysql_connect('localhost','root','root');
mysql_select_db('database_name');
$sql = 'select id,title from tab_name';
$result = mysql_query($sql);
//循环读取title
while($tem = mysql_fetch_assoc($result)){
$count = count($files);
$max = 0;//接收最大百分比
$j = 0;//接收最大百分比文件下标
for ($i=0; $i < $count; $i++) {
similar_text($tem['title'], $files[$i], $percent);
if($max < $percent){
$max = $percent;
$j = $i;
}
}
//判断如果最大百分比大于80，则文件路径存入对应字段
if($max >= 80){
$filepath = $path . $files[$j];
$id = $tem['id'];
$sql = "update tab_name set filepath = $filepath where id = $id";
mysql_query($sql);
//拼接和html展示数据
$html .= $tem['title'] . ' ' . $filepath . ' ' . $max .'%
';
}
}
echo $html;
//遗留问题，html页面只输出大于80%的匹配列，最大匹配可能重复出现
