php+mysql single condition universal anti-counterfeiting traceability query system v2020

Applicable uses

Suitable for precise queries with various single conditions and low confidentiality.

For example, there are many uses such as certificate query, anti-counterfeiting query, asset management query, etc.

Features: Universal, the query conditions are unique and not repeated, the GET method realizes one thing and one QR code to scan the QR code to get direct results.

Features and advantages

1 Very versatile: It is applicable to almost all two-dimensional tables and can meet many query needs.

2. Simple and convenient: The code is small and simple, and can be quickly mastered and developed again.

3. Flexible and easy to use: Just modify a few parameters to customize your query system.

Conditions of use

1 linux php+mysql environment space or server. php:5.4-7.2;mysql:5.6.

2. If the domain name is bound to the domestic space, it must be registered first, and the registration may take more than half a month.

3 Technician: Must have experience in source code uploading, domain name binding, database information acquisition, etc.

4 Operator: Proficient in Excel, etc., Mysql import, export and backup capabilities.

5. It must not be used for illegal purposes or purposes not allowed by policies. Please pay attention to the protection of privacy information when using it.

Security advice

Backend path: Change the user/folder to a name only you know, and the management URL will change accordingly.

Delete files: Delete the install folder after normal use, or rename it to a folder name that only you know.

Delete the file: Delete the user/admin.php password-free login plug-in after normal use, or rename it to a file name only you know.

Source code usage

1. Upload to the website space, either in the root directory of the website or in a folder.

2. Installation

You can first modify the database information in inc/sqls.php.

Visit http://domain name/folder/install/ to enter the mysql database writing operation page function.

Note: Please use your email address as your username. The database mode is selected based on the actual situation (you can try them all)

If there are 6 red words successfully after submission, the library writing is successful. The default login user is the email address filled in, and the password is 253252545.

3. Transfer: Copy to new space. Then modify the new database information and import the previous database.

4. Database export: Export in your own way, such as phpmyadmin, pagoda and other server environments with built-in functions.

5. Reset account password: modify the database user table, where the password is the PHP MD5 value

Or directly delete the user table and rewrite the database (other existing tables will not be rewritten)

Performance description

1. Suitable for small and medium-sized queries, it is recommended that the number be within 1 million (depending on the server configuration).

2. Customize whether the front desk uses verification codes, that is, you can turn on/off verification codes by yourself.

3. Flexibly supports N columns of content, as long as the first few columns follow the rules; the remaining columns have customized content.

4. Can be added individually or imported externally in batches. . .

Backend functions

1. Single administrator login page, change password page

2. Setting page: Query title, query conditions, bottom copyright and links, query instructions, etc.

3. List page: displayed in pages and can be searched. Each record has modification and deletion functions.

4. New page: add corresponding information in a single piece. Batch import: Import information in batches.

5. Clear all: Clear the imported query table information. Batch deletion: Delete by import batch.

Front desk function

1. Query through a query condition (verification code is optional). Mobile game page (can also be accessed from a computer)

2. The GET method realizes one item and one QR code to scan the QR code to directly obtain the single row result.