asp+excel book online retrieval system v201904

asp+excel rural farmhouse book online retrieval system V201904

Update instructions

After four or five years, a major update

1. Use the query system interface to make it more beautiful

2. Use search statements to achieve better speed and performance

3. Optimize database suffix identification algorithm

4. To optimize the identification of tables, it is not necessary to use the sheet1 table.

5. Solve the problem of garbled jump prompts and invalid compatible query conditions (1-3 conditions)

6. Re-edited the instruction manual

Performance Notes

This is specially designed for online retrieval of books in rural bookstores. In the information age, a simple retrieval function can make your work more efficient and get twice the result 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 keep.

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, and it directly supports all two-dimensional tables.

Usage suggestions

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 for direct use, 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 post 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.

Data transformation

If it is a full-text two-dimensional table and you can directly query the data without reporting an error, you can ignore the following three steps.

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.