Home >Backend Development >PHP Tutorial >PHP reads excel and queries specified data_PHP tutorial
php reads excel and queries the specified data
php tutorial to read excel and query specified data Score Query System
Description:
Please enter correct and complete data.
This query system is for reference only. The actual transcript shall prevail.
For example: Query Class 1, Grade 1 of the Second Specialized Management Department in the first semester of the 2001 academic year
Student ID input format example: c017037
php代码
$filename=$pl.$p2.$p3.trim($p4).trim($p5).trim($p6). ".dbf";
if (file_exists($filename))(
$f=dbase_open($fiiename,0);
$k=dbase_get_record($f,1);
for($i=2;$i$a=dbase_get_record($f,$i);
if($no==trim($a[0])){
echo "成绩查询系统";
echo "
";
echo "$a[0] $a[1]
";;
echo "";
echo"科目名称 分数 ";
for ($j=2;$j<(dbase_numfields($f));$j++){
echo ""; $k[$j] $a[$j]";
}//end for j
break;
}//end if
}//end for i
echo "
dbase_close($f);
} else {
echo "错误信息:成绩数据库教程尚未建立
";
}
if($no=="") {echo "错误信息:请输入学号
";}
?>Statement:The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cnPrevious article:php access message board program_PHP tutorialNext article:php access message board program_PHP tutorialRelated articles
See more