Tag: escape
-
Post Views: 21 1. Discover problems Recently, when I was using the Polylang + AutoPoly plugin to multilingually translate the blog, I found a strange phenomenon: – The code block inserted by the Gutenberg editor (SyntaxHighlighter block), the code format in the translated English article is intact, and the indentation, angle brackets, etc. are all normal. – The code blocks…
-
Post Views: 54 1. The URL URL of a column of a CSV file is now escaped after a string. Example: 2. Because it is planned to import the CSV file into WooCommerce’s products, the URL is mapped as a picture. If it is escaped, the picture is empty after importing. After deciding to deliberate, import again. 3. Select the…
-
Post Views: 44 1. The URL URL of a column of a CSV file is now escaped after a string. Example: 2. Because it is planned to import the CSV file into WooCommerce’s products, the URL is mapped as a picture. If it is escaped, the picture is empty after importing. After deciding to deliberate, import again. 3. Select the…
-
Post Views: 50 The correct display of code blocks is critical when writing a technical blog. Recently, I’m having trouble with code blocks using the WordPress Gutenberg editor, and I’m struggling to find a better solution. After repeated exploration, I finally summed up a complete set of ‘from manual to automatic’ complete plan, which can not only solve the problem…
-
Post Views: 114 The background When writing a technical blog with a WordPress block editor (Gutenberg), I often need to include multiple code blocks in one article, such as: SQL query (SQL) Go sample code (GO) PHP code (PHP) Description text (Text) Usually, an article will contain about 10 code blocks in combination. This kind of content was very stable…
-
Post Views: 15 1. When using native expression query in Laravel 9, an error is reported: SQLState[42000]: Syntax error or access Violation: 1064 you have an error in your SQL syntax;. The reason should be with Hannah OConno is related. in it. as shown in Figure 1 2. Reference:In condition for multiple fields when using native expression query in Laravel…
-
Post Views: 21 1. The existing code is implemented as follows 2. The final generated JSON data structure is as follows: 3. The Blade {{ }} statement is automatically passed through PHP’s HtmlSpecialChars function to prevent XSS attacks. Therefore, you need {!! !!} to prevent the “(double quotes) from being converted into HTML entities. 4. However, the generated JSON structure…
-
Post Views: 18 1. Execute the generated sql, which can be found in the local Windows 10. In the liunx container, no records are found. Print records under Windows 10. as shown in Figure 1 2. Print the record under the liunx container. The result is null. as shown in Figure 2 3. Decide to print the generated sql, you…
-
Post Views: 18 1. Print the SQL statement executed by the program, and the result is as follows. as shown in Figure 1 2. The number of SQL statements executed by the print program is 79. Array elements start with 0. as shown in Figure 2 3. Print the SQL and copy it to MySQL 5.7 to execute. Its number…
-
Post Views: 14 1. The data in the table is as follows 2. When executing a where like query, use likelayouts\\%Attempts to query the data rows starting with Layouts\. The result is empty. as shown in Figure 1 3. When executing a where like query, use likelayouts\\\%Attempts to query the data rows starting with Layouts\. Only the corresponding results are…