PHP+MYSQL 出现乱码的解决方法
使用PHP+MYSQL时遇到过字符乱问题，解决方法：
在mysql_connect后面加一句SET NAMES UTF8，即可使得UTF8的数据库消除乱码，对于GBK的数据库则使用SET NAMES GBK，代码如下：
<div>
<span style="color: #008080;">1</span> <span style="color: #000000;">$mysql_mylink </span><span style="color: #808080;">=</span><span style="color: #000000;"> mysql_connect($mysql_host, $mysql_user, $mysql_pass); <br></span><span style="color: #008080;">2</span> <span style="color: #000000;">mysql_query("</span><span style="color: #0000ff;">SET</span><span style="color: #000000;"> NAMES </span><span style="color: #ff0000;">'</span><span style="color: #ff0000;">GBK</span><span style="color: #ff0000;">'</span><span style="color: #000000;">"); </span>
</div>数据库字符集为utf-8
连接语句用这个
<div>
<span style="color: #008080;">1</span> <span style="color: #000000;">mysql_query("</span><span style="color: #0000ff;">SET</span><span style="color: #000000;"> NAMES </span><span style="color: #ff0000;">'</span><span style="color: #ff0000;">UTF8</span><span style="color: #ff0000;">'</span><span style="color: #000000;">"); <br></span><span style="color: #008080;">2</span> <span style="color: #000000;">mysql_query("</span><span style="color: #0000ff;">SET</span><span style="color: #000000;"> </span><span style="color: #0000ff;">CHARACTER</span><span style="color: #000000;"> </span><span style="color: #0000ff;">SET</span><span style="color: #000000;"> UTF8"); <br></span><span style="color: #008080;">3</span> <span style="color: #000000;">mysql_query("</span><span style="color: #0000ff;">SET</span><span style="color: #000000;"> CHARACTER_SET_RESULTS</span><span style="color: #808080;">=</span><span style="color: #000000;">UTF8</span><span style="color: #ff0000;">'</span><span style="color: #ff0000;">"); </span>
</div>
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Explain late static binding in PHP (static::).
Apr 03, 2025 am 12:04 AM
Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.
What are PHP magic methods (__construct, __destruct, __call, __get, __set, etc.) and provide use cases?
Apr 03, 2025 am 12:03 AM
What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.
How to solve the problem that custom structure labels in Goland do not take effect?
Apr 02, 2025 pm 12:51 PM
Regarding the problem of custom structure tags in Goland When using Goland for Go language development, you often encounter some configuration problems. One of them is...
How to solve the problem of Golang generic function type constraints being automatically deleted in VSCode?
Apr 02, 2025 pm 02:15 PM
Automatic deletion of Golang generic function type constraints in VSCode Users may encounter a strange problem when writing Golang code using VSCode. when...
How to specify the database associated with the model in Beego ORM?
Apr 02, 2025 pm 03:54 PM
Under the BeegoORM framework, how to specify the database associated with the model? Many Beego projects require multiple databases to be operated simultaneously. When using Beego...
Explain JSON Web Tokens (JWT) and their use case in PHP APIs.
Apr 05, 2025 am 12:04 AM
JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,
Common errors and ways to avoid char in C language
Apr 03, 2025 pm 03:06 PM
Errors and avoidance methods for using char in C language: Uninitialized char variables: Initialize using constants or string literals. Out of character range: Compare whether the variable value is within the valid range (-128 to 127). Character comparison is case-insensitive: Use toupper() or tolower() to convert character case. '\0' is not added when referencing a character array with char*: use strlen() or manually add '\0' to mark the end of the array. Ignore the array size when using char arrays: explicitly specify the array size or use sizeof() to determine the length. No null pointer is not checked when using char pointer: Check whether the pointer is NULL before use. Use char pointer to point to non-character data
What should I do if I encounter garbled code printing for front-end thermal paper receipts?
Apr 04, 2025 pm 02:42 PM
Frequently Asked Questions and Solutions for Front-end Thermal Paper Ticket Printing In Front-end Development, Ticket Printing is a common requirement. However, many developers are implementing...
