Please refer to the following code for single quotes in array elements: functionmethod () {$ str & quot; apply & quot; $ str2 & quot; tony & quot; $ SQL & quot; select * fromtablewhere11 & quot; $ Carrayarray (& quot; andcadlike % & quot: single quotes in array elements
The following code:
Function method (){
$ Str = "apply ";
$ Str2 = "tony ";
$ SQL = "select * from table where 1 = 1 ";
$ Carray = array ("and cad like '%". $ str. "%'", "and name like '%". $ str2. "% '");
// Echo ($ Carray [0]);
For ($ I = 0; $ I $ SQL. = $ Carray [$ I];
}
Echo $ SQL;
}
This code is written for ease. I want to ask why $ SQL cannot be input, that is, elements in the array cannot be input, and echo ($ Carray [0]) is added. this sentence cannot be entered. Is there a problem with single quotes in the array?
------ Solution --------------------
No problem.
Output: select * from table where 1 = 1 and cad like '% apply %' and name like '% tony %'
------ Solution --------------------
PHP code
Function method () {$ str = "apply"; $ str2 = "tony"; $ SQL = "select * from table where 1 = 1 "; $ Carray = array ("and cad like '% $ str %'", "and name like '% $ str2 %'"); for ($ I = 0; $ I <count ($ Carray); $ I ++) {$ SQL. = $ Carray [$ I];} echo $ SQL ;}
------ Solution --------------------
Single quotation marks are used in double quotation marks.