PHP+excel general grade query system v6.8 SAE version

Introduction to PHP+excel general grade query system

The PHP+excel universal score query system is an extremely simple but very versatile and convenient score query system that can be used to query almost all Excel single and two-dimensional data tables. Just modify the query conditions and top and bottom text (very simple), and it can be used for almost all salary inquiries, grade inquiries, property inquiries, electricity bill inquiries, admission inquiries, certificate inquiries and other scenarios.

PHPexcel is used to query Excel, and the test is available, but the speed may be slow (thousands of data have no impact)

Directly query the first table of Excel data, modify the table and upload it via FTP. It is done quickly and is very convenient.

Of course, LINUX may allow xls files to be downloaded twice as long. If the data is confidential, please prevent it from being downloaded.

sae can directly upload the code package to have the same effect as the demonstration, allowing you to implement the query system for free

(Free code + free second-level domain name + free sae space)

In other LinuxPHP environments, if the characters are garbled, please use the UTF-8 character set to upload.

1. Very versatile. No matter how many columns or column titles you have in your Excel/Wps two-dimensional table, it is directly supported. Other formats are also supported after exporting to csv or excel. The query results are almost all controlled by your Excel two-dimensional table. You only need to maintain your Excel table. To operate Excel, almost every computer has software that can be opened and edited, and almost anyone can operate it.

2. Easy to use. Just modify the query conditions and title, and then copy, paste, rename, and upload the two-dimensional Excel table you usually enter. It is very convenient. You can publish a score query and it can be solved in half a minute. To modify the query conditions, etc., just open Notepad and edit a few words to customize whether to use the verification code.

3. Broad market. It can be widely used for one-time performance query with few changes, admission query, certificate query system (can be used in every school, educational institution, public institution examination, etc.), salary query system (every enterprise, school, all May be used by all units), water and electricity bill inquiry system, etc. (community, property company, university dormitory, etc.), admission, certificate inquiry system.

4. Flexible use: supports multiple queries. For example, salary queries often require multiple queries, so you only need to place one database per month, and the drop-down query options are automatically obtained (the options are file names); and each query is in addition to the set query conditions. Except for the column titles, which must be consistent, everything else is customizable and can be different (any number of columns, any column titles, any number of rows); if the query conditions are inconsistent, copy the code file and name it in a different folder, and then modify it. The query conditions can be used.