i need to explode a string (The string is dynamically)
“ID = 2 AND CITY IN (9) AND (YN = ‘N’ OR YN IS NULL) AND ((UPPER BETWEEN ‘300000’ AND ‘9900000000’) OR (LOWER BETWEEN ‘300000’ AND ‘9900000000’)) AND INCOME BETWEEN ‘50000’ AND ‘9900000000’ AND AGE BETWEEN ‘25’ AND ‘69’ AND PROFESSION_ID IN (1,2) AND ((TOTAL_EMI_AMT >=10000))”
the string needs to be xploded as
Array
(
[0] =>PRODUCT_ID = 2
[1] =>CITY IN (9)
[2] =>(YN = 'N' OR YN IS NULL)
[3] =>((UPPER BETWEEN '300000' AND '9900000000') OR (LOWER BETWEEN '300000' AND '9900000000'))
[4] =>INCOME BETWEEN '50000' AND '9900000000'
[5] =>AGE BETWEEN '25' AND '69'
[6] =>PROFESSION_ID IN (1,2)
[7] => ((TOTAL_EMI_AMT >=10000))
}
Instead when i use explode(‘AND’,$str) where $str is the above string i get the array as
Array
(
[0] => ID = 2
[1] => CITY IN (9)
[2] => (YN = 'N' OR YN IS NULL)
[3] => ((UPPER BETWEEN '300000'
[4] => '9900000000') OR (LOWER BETWEEN '300000'
[5] => '9900000000'))
[6] => INCOME BETWEEN '50000'
[7] => '9900000000'
[8] => AGE BETWEEN '25'
[9] => '69'
[10] => PROFESSION_ID IN (1,2)
[11] => ((TOTAL_EMI_AMT >=10000))
)
PLZ HELP ON THIS…