Category: PHP
-
Post Views: 17 1. Expect the generated SQL statement, as shown in Figure 1 2. LIKE: The first operand should be a field name or dB expression, and the second operand can make a string or an array, representing the value of the first operand that needs to be fuzzy. For example,[‘like’, ‘name’, ‘tester’]will generate name like%tester%. If the range…
-
Post Views: 15 1. PHP fatal errorYii\Base\ErrorExceptionwith messageAllowed memory size of 2147483648 bytes exhausted (Tried to allocate 1084897244 bytes). as shown in Figure 1 2. Downloaded files:https://webtv-test.oss-cn-beijing.aliyuncs.com/rmhadmin/vod/2020/12/02/b73b9e8c3796447494a9dbe6dc66e2ad/b73b9e8c3796447494a9dbe6dc66e2ad_h264_1200k_mp4.mp4. Its size is 1.44 GB. In the local environment, this file is successfully downloaded, memory usage: 6.376 MB, time consuming: 916,308 ms. as shown in Figure 2 3, the uploaded file, its size…
-
Post Views: 12 1. Now it has been implemented: Copy the resource file of the source to the resource directory published by the channel, and return the relative path (sync). The code is as follows 2. Now it needs to be adjusted and can be realized again: download the file and save it as a specific file name, rather than…
-
Post Views: 17 1. In K8s, the container has no restart options, as shown in Figure 1 2. In non-K8s, the container has a restart option, modify the php file before, and the container will automatically take effect after restarting. as shown in Figure 2 3. Edit the php file and output some information, as shown in Figure 3 4.…
-
Post Views: 20 1. The current requirements are as follows. Based on the time range of article publishing, it is necessary to filter account rankings based on the number of articles published. as shown in Figure 1 2. View the method file of the obtained account list, the code is as follows 3, gethttp://api.channel-pub-api.localhost/v1/channel-app-sources?group_id=015ce30b116ce86058fa6ab4fea4ac63&sort=-channel_app_task_count。Sometimes, when connecting two tables, you may…
-
Post Views: 14 1. Main table: CPA_CHANNEL_APP_TASK and Schedule: CPA_Task: many-to-one. as shown in Figure 1 2, table: cpa_task and Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article The association relationship: one-on-one. Table: A record in cpa_task will only exist in Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article in one of the tables. As shown in Figure 2, Figure 3, Figure 4 3. Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|c PA_Netease_Article|CPA_QQ_Article|CPA_Weibo_Article|CPA_WX_Article…
-
Post Views: 10 1. Table name: CPA_CHANNEL_APP_SOURCE design, table prefix: CPA_, as shown in Figure 1 2. View command: yii migrate/create help documentation 3. Add field. If the migrated name follows the format of add_xxx_to_yyy, the generated class file will contain the necessary addColumn and dropColumn. You can specify multiple fields like this: yii migrate/create add_xxx_column_yyy_column_to_zzz_table –fields=”xxx:integer,yyy:text”. as shown in…
-
Post Views: 15 1. When upgrading the container in Rancher, an error is reported: channel_pub_api_cfg_app_avatar_upload_path: unbound variable. as shown in Figure 1 2. View the file: /config/init/config0.sh. 3. Even in Rancher Add environment variables: channel_pub_api_cfg_app_avatar_upload_path_url, channel_pub_api_cfg_app_avatar_upload_path . The same error is still reported. as shown in Figure 2 4. Assign the environment variable in Rancher: channel_pub_api_cfg_app_avatar_upload_path A specific value. The…
-
Post Views: 16 1. Yii2 queue extension, in the Redis driver, when the info command prints information about the queue status, the queue of the reserved state has always existed. Check the system log, there is no abnormal output. Reference URL:https://www.shuijingwanwq.com/2019/12/16/3737/. as shown in Figure 1 2. Check the running status of supervisord: supervisorctl status. Delete the task group queue,…