PHP reads Excel and queries the specified data
PHP tutorials read Excel and query for specified data
Score Enquiry System
|
Description
Please enter the correct and complete data.
This query system is for reference only, the actual transcripts shall prevail.
For example: Enquiry for the first semester of the 2001 academic year two special management Division One class Example of number input format: c017037
|
|
PHP code
$filename = $pl. $p 2. $p 3.trim ($p 4). Trim ($p 5). Trim ($p 6). ". 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 "
Score Enquiry System ";
echo "";
echo "$a [0] $a [1]
";;
echo "
<> Score ";
for ($j =2; $j < (Dbase_numfields ($f)); $j + +) {
echo " $a [$j] ";
}//end for J
Break
}//end if
}//end for I
echo "
http://www.bkjia.com/PHPjc/630816.html www.bkjia.com true http://www.bkjia.com/PHPjc/630816.html techarticle PHP reads Excel and queries the specified data Htmlheae titlephp tutorial reads Excel and queries the specified data/title bodycenter score query System HR table BORDER=0TR TD bgcolor=red Align =center) score Check ...
"; Echo
Account name |
$k [$j] |
"; Dbase_close ($f); } else {echo "error message: The score database tutorial has not been established";} if ($no = = "") {echo "error message: Please enter the number";}?>