PHP book information fuzzy retrieval system v5.8 win

PHP+excel general book information fuzzy retrieval system PC web version This is the first PHP fuzzy query system released by this author. Performance description: This is specially designed for online retrieval of books in rural bookstores. In the information age, simple retrieval functions can increase your work efficiency 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 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 8 parameters, almost all other contents are controlled by excel tables, which directly supports all two-dimensional tables.

Usage suggestions: You can use it by uploading directly through FTP. It is recommended to upload directly for query testing first. Front-end access: http://website/directory/ (upload is used directly without the support of mysql database, etc.) and 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. How to open the xls version: You can directly double-click to open and view the Excel file in xls format.

Usage steps: Parameter modification 1. Open inc/conn.php in software notepad++ or Notepad to modify the website title, query conditions and other parameters. For details, see the file and the text description inside. For security reasons: Please modify the $UpDir parameter and modify the corresponding folder name, especially the linux series and excel series. Data transformation 1. Remove the edges: leave the two-dimensional table part (leave: the first row and column headers, and one data per row thereafter). 2. Multi-column titles must be merged into one row; if there are merged cells: after splitting the cells, fill each cell with the content before splitting. 3. Eliminate excess: delete useless tables, leaving only one table such as sheet1. If the query fails, please try to save it as an .xls file (excel97-2003). Source code upload 1. Source code upload: 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.Php. 4. Reduce the query category: Please delete the corresponding file name in the database directory. 5. Change the 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 one row and column headers are supported: that is, multiple rows and rows 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, Each cell is filled with the content before splitting. 3. In addition: For a more comprehensive description of the Excel and Csv versions, see the end of this page: Two-dimensional table specifications