The asp+excel rural farmhouse book online retrieval system is specially designed for online retrieval of rural farmhouse books. In the information age, a simple search function can increase your work efficiency with half the effort.
1. The code is extremely simple. You can make slight improvements to use it in a fuzzy query system that suits you. It has a wide range of functions and is recommended for code learners to treasure.
2. The code is very versatile and can be applied to almost all three-choice fuzzy queries, such as product information query systems, without modifying the core code.
3. It is extremely easy to use. After modifying several parameters of conn.asp, almost all other contents are controlled by excel tables, which directly supports all two-dimensional tables.
asp+excel rural farmhouse book online retrieval system v201904 update log 1. Use the latest version of the query system interface, which is more beautiful
2. Use search statements to achieve better speed and performance
3. Optimize database suffix recognition algorithm
4. To optimize the identification of tables, it is not necessary to obtain the sheet1 table.
5. Solve the problem that the jump prompt is garbled and the compatible query conditions are partially invalid (conditions 1-3)
6.Re-edited the instruction manual
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.Asp 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.
How to open the xls version: You can directly double-click to open and view the Excel file in xls format.
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.
Usage steps:
Parameter modification
1. Open inc/conn.asp in Notepad to modify the website title, query conditions and other parameters. For details, see the file and the text description inside.
If the data conversion is already a full-text two-dimensional table and the data can be queried directly without reporting an error, then the following three steps can be ignored:
1. Create a new excel file: Create a new book1.xls file--->Select all tables--->Format--->Cells--->Number--->Select text--->OK
2. Remove the original format: open the original .xls database ---> copy the two-digit table part of the table ---> create a new notepad file ---> paste ---> select all ---> copy
3. Paste the deformatted data to a new file: Paste the copied result to book1.xls--->Save file--->Modify the file name (drop the option name)
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.Asp.
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.
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.