PHP excel universal score query system v2018

Usage:

It is suitable for various precise queries such as grades, wages, property utility bills, etc. that require infrequent modifications and low confidentiality.

1. Score inquiry system, which can be used by every school, educational institution, public institution examination, etc.

2. Salary query system, which can be used by every school, educational institution, public institution examination, etc.

3. Property fee query system, every enterprise, school, and all units may use it

4. Utility bill inquiry system, residential communities, property companies, university dormitories, etc.

5. Other query systems with few modifications, such as class placement query, admission query, examination room query, certificate query, etc.

Features and advantages

1. Flexible and versatile

Even though 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. Small and easy to expand

The entire source code (including demo data) is only 30-50KB, 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 read and not written, 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

There is no need to install (initialize) or modify parameters. You can 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

There is no need for Mysql, etc., and low-memory servers can run smoothly (Mysql may consume 20+ server memory).

6. Low consumption network

Nowadays, most pages have a single js file of several hundred KB, and the size becomes 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.

At present, the 8MB (actual 1MB) bandwidth of Alibaba Cloud, Tencent Cloud, etc. exceeds 2,000 yuan per year.

Therefore: while saving a lot of network costs, the concurrency of queries is greatly increased.

7. Low consumption reading and writing

This query almost only reads and does not write; the small web page will also save a lot of resources in reading JS and images.

Instructions for use:

1. Please do not use this system for purposes not permitted by policies and regulations.

2. Please pay attention to privacy protection when using this system

3. Please use it for inquiries of your own organization and do not pretend to be another organization to issue inquiries.

Suggestions for use:

It can be used by uploading directly through FTP. It is recommended to upload directly for query testing first.

Front desk access: http://website/directory/ (upload is used directly without the support of mysql database, etc.)

Then notepad++ opens inc/conn.Php to view the correspondence between parameters and web pages.

Then open the default built-in database to compare the query results and check the corresponding relationship.

How to open the xls version: You can directly double-click to open and view the Excel file in xls format.

Recommendation: use php5.X environment under windows.

Usage steps:

Parameter modification

1. Use notepad++ or notepad to open inc/conn.php and modify the website title, query conditions and other parameters. For details, see the file and the text description inside.

Data transformation

1. Remove the edges: leave the two-dimensional table part (leave: the first row and column headers, and one data per row thereafter).

2. Multi-column titles must be merged into one row; if there are merged cells: after splitting the cells, fill each cell with the content before splitting.

3. Eliminate excess: delete useless tables, leaving only one table such as sheet1. If the query fails, please try to save it as an .xls file (excel97-2003).

Source code upload

1. Upload the source code: Keep the original structure and upload it to the website for direct use. Please pay attention to the encoding (gb2312) when uploading. You can watch the video tutorial for details.

Data upload

1. Upload method: FTP tool upload (recommended); remote desktop upload; online file management tool management; etc.

2. Upload the code and data by specifying the encoding (i.e. character set: gb2312) and upload it to the website database directory.

3. Add new query category: upload a new data. Note that the suffix is ​​the same as the original. The query conditions must be the same as those set in inc/conn.Php.

4. Reduce query categories: Please delete the corresponding file name in the database directory.

5. Change query category: rename the corresponding file name.

6. Modify the data content: Upload the newly transferred data to replace the original data with the same name.

Update record

2018.10.24

1. The interface is completely changed: use the latest 2008 version of the interface

2. Major update of instructions for use: all instructions have been rearranged

3. Many details have been optimized, such as text encoding optimization, etc.