Php+xls general examination score checking system
v0
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.
202203 Modify the core code to enhance compatibility with PHP8
Features and advantages of PHP+excel universal score inquiry system 1. Flexible and versatile. Although the source code is extremely small, it does not require the design of a database and can be quickly used for various two-dimensional table queries.
Commonly used for score inquiry, utility and property fee inquiry, admission, class placement, dormitory assignment, examination room allocation inquiry, etc.
2. Compact and easy to expand. The entire source code (including demonstration data) is only 65KB, and it not only runs naturally and smoothly.
Easy for programmers to quickly master; greatly improves development speed and reduces secondary development costs.
3. More secure. The source code only has two pages, which are almost only for reading and not writing, and there are no risks such as SQL injection.
Most current software is tens of MB in size. The larger the file, the more complex it is, and the more difficult it is to master security.
4. Simple and easy to use, no installation (initialization) required, no need to modify parameters, just put it in the root directory or any directory and use it directly.
FTP can basically realize the background function and upload it to the space for use.
FTP batch upload of big data may consume less server resources and is not limited to virtual space upload size and timeout.
FTP upload can drag and drop multiple files, and supports resumed uploads, etc., with little impact on the server.
Files that cannot be deleted online can often be deleted via FTP.
5. Low memory consumption does not require Mysql, etc. (mostly non-conventional databases), and low-memory servers can also run smoothly (Mysql may consume 20% more server memory).
6. Low-consumption network. Most pages now have a single js file of several hundred KB, and the size is even larger when pictures are included.
A web page often exceeds 1MB. This query page is only about 30KB per page.
This means that with the same bandwidth resources, network concurrency can be increased dozens of times.
While saving a lot of network costs, it also greatly increases query concurrency.
7. Low-cost read-write query almost only reads and does not write; the compact web page will also save a lot of resources in reading JS and images.
To try usability first, it is recommended to directly upload FTP to the corresponding space for testing without modifying any content.
Query page access: http://website/directory/ (except for uploading directly using the mysql version)
Check the rules and then modify the parameters
Notepad++ opens inc/conn.Php to view the correspondence between web pages and parameters.
In addition: the file name desc.txt in the inc folder is the query page description file (supports html)
View database rules. Open the default built-in database to view rules and compare query results to help you quickly understand the working principle.
How to open the xls version: You can directly double-click to open and view the Excel file in xls format.
Key points of experience include Chinese names. Most of the online decompression function file names are garbled. It is recommended to upload via FTP specified encoding (UTF-8).
It is recommended to keep the original version of the test page: the original version is normal but the exception after your own modification indicates that there is a problem with your operation.
The compressed package contains usage steps, video tutorials and other information (HTML files); each file has its own meaning and is recommended to be retained.
For more instructions, see the two html format files under the compressed package. Double-click the browser to open them to view.
