Eternal Night

Monthly Archive: August 2019

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

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

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

浏览量： 13 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...

打开 RedisDesktopManager，数量变化为 32，符合预期 0

Cache Server / Database / Database Management Tools / Operating System / PHP / PHP 7.2 / Redis / Redis 3.0 / RedisDesktopManager / RedisDesktopManager 2019 / Server / Web Application Development / Web Framework / Windows / Windows 10 / Windows 10 Home Chinese Edition / Yii / Yii 2

In the console command of Yii 2.0, when connecting to Redis, an error is reported: yii\db\exception: redis error: err invalid db index redis command was: select Analysis of 29 in /vendor/yiisoft/yii2-redis/src/connection.php:736

浏览量： 15 1. In the console command of Yii 2.0, an error is reported: yii\db\exception: redis error: err Invalid DB index Redis command was: Select 29 in /vendor/yiisoft/yii2-redis/src/connection.php:736, view /console/runtime/logs/app.log 2. The analysis found...

在 Yii 2.0 中数据验证失败：来源发布用户ID必须是一条字符串。 0

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

Data validation fails in Yii 2.0: the source publishing user ID must be an analysis of a string (to ensure the compatibility of the version, both numeric type and string type must be supported)

浏览量： 49 1. Data validation failed in Yii 2.0: the source publishing user ID must be a string. as shown in Figure 1 2. The reason is the field: source_pub_user_id was int(11) in the...

表：pub_log 中的字段：data 的数据结构为：json，格式化后的数据如下 0

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

In Yii 2.0, modify a column of data in the MySQL 5.6 database (type: text, the data structure is: json) in the value of a field (that is, to search and replace some text in the field), based on one Implementation of SQL

浏览量： 17 1. Table: Fields in pub_log: The type of data is: text, as shown in Figure 1 2. Table: field in pub_log: data structure of data is: json, the formatted data is as...

执行数据库迁移命令 0

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

In Yii 2.0, migrate a column of data in the A table in the MySQL database to a column of data in the B table, based on the implementation of a SQL

浏览量： 16 1. Reference URL:https://www.shuijingwanwq.com/2019/08/15/3427/ 2. Update table: field in channel_app_source: The value of Permission is: 3, as shown in Figure 1 3. Based on the database migration command, generate the implementation of a...

在 Yii 2.0 中报错：Calling unknown method yii2techarsoftdeleteSoftDeleteBehaviorisTransactional() 0

Cache Server / PHP / PHP 7.2 / Programming Language / Redis / Redis 3.0 / Server / Web Application Development / Web Framework / Yii / Yii 2

Error in Yii 2.0: Calling unknown method Yii2tech\ar\softdelete\\softdeleteBehavior::IsTransactional() analysis solution

浏览量： 10 1. Error in Yii 2.0: Calling unknown method yii2tech\\ar\\softdelete\\softdeleteBehavior::IsTransactional(), as shown in Figure 1 2. Check the code, because the operation of the Redis model uses soft delete (SoftDelete) 3. Edit the...