The asp+txt score query system is the simplest and most practical query system. It is widely used for performance inquiry, salary inquiry, property fee inquiry, certificate inquiry, etc. The page is suitable for mobile phone, WeChat, tablet and computer access.
Asp+txt universal query system mobile version operation instructions:Front desk access: http://website/directory/ (no installation, no configuration, upload and use directly)
It can be used directly by uploading it. It is recommended to directly upload the code for query and testing after receiving it.
1. Open the file in Notepad and edit the content of conn.asp. For details, please open the file in Notepad and see the Chinese character description inside.
2. Open the excel or wps table, select the data range, note that the column header is the first column, and then copy.
3. Create a new blank text file, paste, save, rename (option name), and change the suffix (.dat).
4. Upload new files to the website database directory using your usual upload method, and the options will be automatically added.
5. To add a new query category, please repeat the previous steps 2-3. Note that the two query conditions must be consistent with those set in conn.asp.
6. To reduce the query category, please delete the corresponding file name in the database directory. To replace the data, repeat steps 1-3 and replace it with the file of the same name.
Asp+txt universal query system mobile version experience and skills:1. It is recommended to use name/student number/admission ticket/ID card/employee number, etc. for query condition setting. It is not recommended to use class, etc., which may have multiple input contents.
2. There may be a URL that is not yours in the program. Just open the corresponding file in Notepad and replace it with your own URL. If you are not sure, don't modify it.
3. Reminder: You can set a password, but it cannot be modified online; you can use your ID card, but please pay attention to the case (for example, if the data is in uppercase, then please follow the instructions on the input page).
4. The program itself does not limit the number of records, but more records will affect the speed; it is recommended to keep each database file within a few thousand records. If more records are added, they can be divided into several databases based on classification.
5. You can almost customize Excel (as long as it is a two-dimensional table). You can also right-click -> Excel to open and view the Excel template (remember that direct saving cannot be used, and you need to follow the method I provided)
Exception troubleshooting:
If an error occurs, please first check whether the set query conditions are consistent, and check whether the cells contain carriage returns, line feeds, and tab characters;
1. There are many replacement methods. You can use Baidu by yourself: Excel replaces carriage return and line feed, Excel replaces tab character Tab. Please refer to more experience.
2. Direct replacement method 1: Excel press Enter to replace Ctrl+H--->Input where to find the content--->Hold down Alt+Numpad 1+Numpad 0--->Replace all--->Save.
3. Directly replace tab characters: Excel press Enter to replace tab characters--->Copy the column containing tab characters--->Paste into Notepad--->Replace tab characters--->Copy and paste the contents of Notepad Return to EXCEL column.
4. After the Excel replacement is completed, follow steps 4-6 to convert Excel again and then upload the replacement. It is to edit excel and re-transmit it, rather than modifying it based on TXT.
3. There may be many ways to replace carriage returns and tab characters, some directly, some using formulas, WPS to replace "^p", etc. For details, you can download other methods from Baidu.
asp+txt universal query system mobile version update log:2016.11.11 Improvement
1. Add custom verification code function (modify a number to control whether to use verification code)
2. Instructions for use of the new version. Also: Attached are the video tutorial download links and data conversion tool URLs for use.
asp+txt universal query system mobile version page display