php+excel general timetable query system v2.1

The php+excel general timetable query system (the core part uses Php-Excel-Reader open source code) is generally suitable for primary and secondary school timetable query systems. University class schedules are also available (just use the final class schedule as a unit). At the same time, it can also be used for many other purposes, such as sports competition results inquiry, township and village financial public inquiry and other similar inquiries.

The design idea is: classification selection (such as grade, semester, etc. as categories) + display unit (such as class schedule as unit). Then with the help of the powerful display function of Php-Excel-Reader, it is very flexible and has a wide range of applications.

Advantages and features:

Feature 1: Read excel directly, including borders and font size, and also supports the display of merged cells. Read excel directly, and "what you see is what you get" is usually entered into excel, which is suitable for more users.

Feature 2: Second-level linkage drop-down to avoid the problem of not being able to query if the Chinese characters are not completely correct. The two-level linkage pull-down method avoids wasting time due to lack of correspondence between the first and second levels.

Feature 3: Very intuitive management, the first-level selection is the folder, and the second-level selection is the excel file name. This way everyone can understand it and it is more intuitive. Only FTP tool maintenance is required.

Feature 4: Simple operation: upload and use; no database support such as mysql is required, and no installation process is required. To add deletion options, just add and delete folders or file names, and manage them through FTP tools.

Usage steps:

1. Modify parameters: Edit several parameters of the conn.php file, and ignore the others.

//Set the following 6 items

$title="php+Excel universal class schedule query system";//Set the query title, I believe you understand;

$foldshuo="Please select a major category";

$timeshuo="Please select a subcategory";

$copyr="XX Middle School";//Bottom text;

$copyu="http://down.chinaz.com/";//Bottom URL;

$UpDir="shujukufangzheli";//Please modify the directory (folder name) where the database is located, and rename the corresponding folder after modification.

2. Upload the entire file to the PHP space (UTF-8) of the Windows environment, which can be the root directory or any folder, and no settings are required.

3. Upload your own excel data via FTP and manage folder file names.

Excel tips, the smaller the file, the better. Only the first sheet is read. Tables support color borders, border height, font size, etc.

4. Query test. If successful, it can be published for query.

PHP+excel general timetable query system 20160602 update log:

1. Solve the problem of blank line at the top of the page.