Category: PHP
-
Post Views: 18 1. The XML data is printed as follows. as shown in Figure 1 2. At this stage, the XML is converted into an array. The code is implemented as follows. The libxml_disable_entity_loader function has been abandoned since PHP 8.0.0. It is strongly recommended not to rely on this function. 3. After converting to an array, the printing…
-
Post Views: 15 1. Request parameter: filter[and][0][or][0][title][like]=\, the generated sql is as follows, the search result is empty. as shown in Figure 1 2. Check the value of the field title in the table plan, one of the records exists \. In theory, it is possible to query a record. as shown in Figure 2 3. Execute SQL in Navicat…
-
Post Views: 16 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 the right syntax to use near6. as shown in Figure 1 2. Remove the request parameter: filter[and][0][or][1][keyword][fis]=, the response is 200, and no error is…
-
Post Views: 17 1. Migrate data from the CSP database to the Cloud database. `channel-pub-api-csp`.`cpa_channel_app_source`. Query 95 records. as shown in Figure 1 2. `channel-pub-api-cloud`.`cpa_channel_app_source`. A total of 158 records were queried. as shown in Figure 2 3. Migrate data from the CSP database to the Cloud database. Field value changes: id, insert `channel-pub-api-cloud`.`cpa_channel_app_source`. Edit command line scripts. /console/controllers/migrate20210425controller.php 4.…
-
Post Views: 15 1. Modify the multi-domain name mode to a single domain name mode, and modify the file: frontend/config/main.php. as shown in Figure 1 2. Modify the multi-domain name mode to single-domain name mode, and modify the file: etc/nginx/conf.d/ccp_api.conf. as shown in Figure 2 3. Now plan to upgrade the container based on the environment variable: channel_pub_api_cfg_frontend_domain_mode=single|multiple. Default: single.…
-
Post Views: 53 1. Composer has been installed before, to ensure the latest version is used. You can update Composer to version 2.0.12 by running composer self-update, as shown in Figure 1 2. Updating Yii 2 to the latest version by running Composer Update, the Yii Framework has been upgraded from version 2.0.35 to 2.0.41.1, as shown in Figure 2…
-
Post Views: 21 1. Error in Yii 2.0: Malformed UTF-8 Characters, Possibly Incorrectly Encoded. 2. Check the code below 3. Print out $E->GetMessage(), which contains garbled characters. as shown in Figure 1 4. Edit the code, MB_CONvert_encoding — Convert the encoding of characters. The response status code is: 500, and the response body is: “SQLState[HY000][2002]php_network_getaddresses: getaddrinfo failed: I don’t know…
-
Post Views: 13 1. Reference URL:https://www.shuijingwanwq.com/2020/09/30/4552/, this is a previous blog. 2. When the cluster is deployed, the overall 4 groups of queues are all executed. It can be controlled within half an hour. However, sometimes, the length of time is still uncontrollable, and may even exceed an hour. 3. Decide to print log information in the relevant places in…