PHP Csv

PHP+Csv (Excel) universal score query system [no background required] inherits the universal and easy-to-use advantages of the original (more than 12 different versions of five major series such as asp/php+txt/excelwindows/Linux), and is also applicable to almost all salary and other queries. Score inquiry, property inquiry, electricity bill inquiry, admission inquiry, certificate inquiry and other scenarios.

Just export the Excel two-dimensional table to a comma-separated Csv file, and then upload it through the FTP tool. Although the query speed is lower than php+txt, it is much higher than php+excel.

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 10,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.

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.

How to open the csv version: Change the suffix of the database file to, and use Excel file to view after csv.

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. 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. Convert to csv: save excel as a comma-delimited .csv file.

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