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.
PHP+Excel multi-purpose query system 1 general version [no background required] V 5.5_PM1X is the first release of PHP+Excel, using PHPexcel to query Excel, the test is available, the speed may be slow (thousands of data have no impact)
The page is suitable for mobile phones, tablets, and computers. The size should be small to save traffic. I hope everyone likes it. .
Directly query the first table of Excel data, modify the table and upload it via FTP. It is done quickly and is very convenient.
1. Very versatile. No matter how many columns or column titles you have in your Excel/Wps two-dimensional table, it is directly supported. Other formats are also supported after exporting to csv or excel. The query results are almost all controlled by your Excel two-dimensional table. You only need to maintain your Excel table. To operate Excel, almost every computer has software that can be opened and edited, and almost anyone can operate it.
2. Easy to use. Just modify the query conditions and title, and then copy, paste, rename, and upload the two-dimensional Excel table you usually enter. It is very convenient. You can publish a score query and it can be solved in half a minute. To modify the query conditions, etc., just open Notepad and edit a few words to customize whether to use the verification code.
3. Broad market. It can be widely used for one-time performance query with few changes, admission query, certificate query system (can be used in every school, educational institution, public institution examination, etc.), salary query system (every enterprise, school, all May be used by all units), water and electricity bill inquiry system, etc. (community, property company, university dormitory, etc.), admission, certificate inquiry system.
4. Flexible use: supports multiple queries. For example, salary queries often require multiple queries, so you only need to place one database per month, and the drop-down query options are automatically obtained (the options are file names); and each query is in addition to the set query conditions. Except for the column titles, which must be consistent, everything else is customizable and can be different (any number of columns, any column titles, any number of rows); if the query conditions are inconsistent, copy the code file and name it in a different folder, and then modify it. The query conditions can be used.
20170808 update
1. Made more optimizations to the mobile version page.
2. Completely rearranged the instruction manual.
3. More detailed optimization: For example, the identification of data files is more accurate and reliable.