php Txt multi-purpose query system v2018
v0
This is an extremely simple but very versatile and very convenient score query system that can be used for almost all Excel single and two-dimensional data table queries. Just modify the query conditions and top and bottom text (very simple), and it can be used for almost all salary inquiries, grade inquiries, property inquiries, electricity bill inquiries, admission inquiries, certificate inquiries and other scenarios.
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 a single database be controlled within 90,000 items (the database can be divided into separate databases, and each database will not affect each other)
4. Formulas, pictures, and URLs are not supported yet. Can be customized for a fee.
Experience tips:
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 classified and divided into several databases.
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 (cannot be saved directly, you need to follow the method I provided)
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 correspondence between parameters and web pages.
Then open the default built-in database to compare the query results and check the corresponding relationship.
txt version opening method: You can copy the text data seen when you open Notepad to Excel for viewing.
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. Open the excel or wps table, select the data range (two-dimensional structure table), note that the column title is the first row, and then copy it.
2. Create a new blank text file, paste it, save it, change the file name (that is, the option name), and change the suffix (.dat).
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.Php.
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.
Update record:
2018.08.24
1. The interface is completely changed: use the latest 2008 version of the interface
2. Major update of instructions for use: all instructions have been rearranged
3. Many details have been optimized
