The Php+MySql simple education query and charging system is suitable for scenarios such as school tuition fees with preset amounts, water and electricity fees in property communities, etc. Users check their own amount information and then scan the QR code to pay.
The administrator imports user and amount information in the background, and can view the user payment list (searchable, deletable, and paging).
It also has simple statistical functions (number and amount of paid and unpaid orders) and supports export.
php(5.4-7.2)+mysql(5.6+), recommended integrated environments such as Pagoda Guardian God
Software and hardware requirements include website space and website domain name. For domestic space, you also need to register on the Ministry of Industry and Information Technology/Ministry of Public Security website (both may take half a month).
You need to use the payment interface: pay 300 certified public accounts annually and activate scan code payment (pay in person), no domain name requirements.
The working ability of Php+MySql simple education query and charging system requires administrators (users) to have skills such as FTP, domain name binding, website space use, and basic excel operations.
Have working experience in public accounts, payment interfaces, database backup, restore and migration, etc.
Notepad++ opens inc/sqls.Php and finds around lines 22-27 to modify the database information.
Upload the source code to the website space and visit http://website/directory/install/ to execute the user query page for writing the library: http://website/directory/
Management login page: http://url/directory/user/
It is recommended to modify the backend directory user to the content that only you know, and the URL you visit should change accordingly.
The installation is complete and has been used normally, please delete the file ../install/index.php. See the source file on this page for more tips.
This is the payment interface, which relies on the official account to be certified every year; there may be a 0.6% rate (education categories may apply for a free interface)
It has been developed for a long time, but it has not been used in actual scenarios yet. Please test it internally first and then launch it when it is available.
When it comes to money, it is recommended that it be operated by people who understand finance and have a high ability to learn new things. For example, you can understand what is going on when you mention scan-code payment (Native payment).
20200331 Enhanced filtering of parameter passing.
Screenshot of Php+MySql simple education inquiry and charging system