How to call IP list from database and perform matching verification?

Database IP list matching verification method

In program development, it is often necessary to read the IP list from the database and verify it. This article has improved a piece of code to read a comma-separated IP list from the database and convert it into an array for IP matching.

The original code tries to assign the IP list (comma-separated string) read by the database to the array directly, resulting in failure.

Suppose that the IP list in the database is stored as a comma-separated string, for example: "99.88, 110.52, 43.80.235, 11.9.67.180". We need to use the Split function to convert the string into an array.

The improved code is as follows:

This code first obtains the IP list from the database and stores it in dbiplist variable. Split(dbiplist, ",") function converts a comma-separated string into an array and assigns a value to iplist . Loop through each IP in iplist , use the Trim function to remove spaces to ensure exact matches. If the match is successful, output "ok".

This improved code solves the problem of array assignment failure in the original code, effectively implementing the function of reading IP list from the database and performing matching verification. Please make sure that the database connection and client IP address acquisition section are implemented correctly.

The above is the detailed content of How to call IP list from database and perform matching verification?. For more information, please follow other related articles on the PHP Chinese website!