Php Mysql web version general examination score query system v201901

Php+Mysql computer web version general examination score checking system: Linux (Utf-8)

You can easily apply it to various query systems such as score query, salary query, property fee query, utility bill query, class placement query, admission query, examination room query, certificate query, etc. that require infrequent modifications and low confidentiality.

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 (excluding demo data) is only 17KB, and it not only runs naturally and smoothly.

Easy for programmers to quickly master; greatly improves development speed and reduces secondary development costs.

It is easy for beginners to get started with PHP quickly; it greatly reduces the development speed and reduces the cost of secondary development.

3. 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.

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

4. 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

It is suitable for users who already have existing databases to quickly call queries or are familiar with mysql data import.

The query function is very general, so be careful not to use it for purposes not permitted by laws and regulations.

Do not pretend to post information in the name of others. Please pay attention to the protection of privacy information when posting inquiries.

Suggestions for use:

Then notepad++ opens inc/sqls.Php to modify the mysql parameters.

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

Upload the source code directly to the server space through FTP.

Front desk access: http://website/directory/(please configure mysql data and import data first)

Mysql version data opening method: phpmyadmin and server environment such as Pagoda's own software.

Environmental recommendations: php5.3+, mysql4.7+.

Limitations

1. The more frequent the modifications, the less suitable it is (scores, wages, utility bills, etc. are generally all released at once without modification)

2. Only suitable for two-dimensional tables (general databases adopt a two-dimensional structure, with headers in the first row and rows, and data in each subsequent row)

3. It is recommended that the number of single databases be controlled within 1 million (note the use of index optimization)