Eternal Night

Tagged: FIND_IN_SET()

分析发现，请求参数：filter[and][0][or][1][keyword][fis]='，所生成的 SQL：(FIND_IN_SET(''', `pa_plan`.`keyword`))。 0

Programming Language / Web Framework / PHP / SQL / Yii / PHP 7.4 / Yii 2 / Web Application Development

sql error: sqlstate[42000]: Syntax error or access Violation: 1064 you have an error in your SQL syntax; check the manual that Corresponds to your MySQL Server version for the right syntax to use near6, find_in_set(, `PA_plan`.`keyword`)

浏览量： 1 1. Interface response to SQL error: SQLSTATE[42000]: Syntax error or access Violation: 1064 you have an error in your SQL syntax; check the manual that Corresponds to your MySQL Server version for...

filter[and][0][or][1][keyword][fis]=关键字3 0

Database / Programming Language / Web Framework / MySQL / PHP / Yii / MySQL 5.7 / PHP 7.2 / Yii 2 / Web Application Development

In Yii 2.0, the method is constructed based on the mapping filter condition keyword. Added implementation of specific condition builder (FIS) to support the mysql find_in_set() function

浏览量： 1 1. Open the URL in Postman:http://api.pcs-api.localhost/v1/plans/have?login_id=2e368664c41b8bf511bcc9c65d86dbc3&login_tid=f347ba5bb18cb3fbef94c0b37c796bf5&filter[and][0][or][0][title][like]=Shenzhen &Filter[status][neq]=0&filter[and][0][or][1][keyword]= keyword, as shown in Figure 1 2. Print request parameter: $requestParams 3. Print the filter: $filter 4. The final generated SQL is as follows, as...