Php multi-condition query implementation using arrays (string segmentation)

This article mainly introduces how to implement multi-condition query (string segmentation) through arrays in php. For more information, see

This article mainly introduces how to implement multi-condition query (string segmentation) through arrays in php. For more information, see

The Code is as follows:

$ Keyword = "asp php, jsp ";
$ Keyword = str_replace ("", "", $ keyword );
$ Keyword = str_replace ("", $ keyword );
$ Keyarr = explode (',', $ keyword );
For ($ index = 0; $ index {
$ WhereSql. = "And (arc. title like '% $ keyarr [$ index] %' Or arc. keywords like '% $ keyarr [$ index] % ')";
}
Echo $ whereSql;

To support both spaces and commas, you must replace them with a uniform comma in advance. That is, you must first replace all spaces with commas, then use commas to separate strings, and then concatenate SQL query statements cyclically.

Str_replace is a commonly used string replacement function in php.
Explode is a common function used in php to split strings into arrays.