php+access general examination score checking system v1.0

Suitable for users who are familiar with Access databases to quickly issue queries.

In addition, the Access database can only run normally on Windows systems.

Uses ODBC data source and does not rely on phpcom permissions.

Pay attention to the table name and field names to be consistent with the actual ones.

The data supports any number of columns, customizable column titles, and customizable content of each row.

Key points: The query condition settings can be exactly the same as the database fields.

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, certificate query, etc.

Features and advantages

1. Very versatile: It is applicable to almost all two-dimensional tables and can meet most of your needs.

2. Simple and convenient: The code is small and simple, and can be quickly modified to suit various scenarios such as multi-table joint query.

3. Flexible and easy to use: Just modify a few parameters to customize the query.

4. Quick use: Posting a score can be solved in two to three minutes at the fastest.

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. There is no limit on the number of records in a single database. It is recommended that the single database be controlled within 100,000 items

4. Formulas, pictures, and URLs are not supported yet. Can be customized for a fee.

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 corresponding relationship between parameters and web pages.

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

.mdb database opening method: MsAccess software

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. Import your two-dimensional table into Access in your own way (fields are column headers, one data per row).

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 (utf-8) 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. Modify the data content: Upload the newly transferred data to replace the original data with the same name.

Special emphasis (i.e. two-dimensional table rules)

1. Only supports one row and column headers: that is, multiple row and column headers are merged into one row (equivalent to resetting only one column header for each column)

2. Merging cells is not supported: after splitting the cells, fill each cell with the content before splitting.

3. The mdb database may be downloaded, please pay attention to handling, such as pseudo-static rules to prevent specified formats from being downloaded.

4. Mdb database query may be attacked by SQL, please add source code filtering information by yourself.