PHP初学者,请教关于从数据库读取后输出会乱码的情况-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

PHP初学者,请教关于从数据库读取后输出会乱码的情况

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 23, 2016 pm 01:50 PM

Garbled charactersConditiondatabaseread

目前用的wampserver
数据库选择UTF8 general_CI ,页面charset使用utf8,PhpMyAdmin中夫妻链接校对使用UTF8 GENERAL CI,
然后这段代码:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf8"><title>Insert title here</title></head>    <body>    <p>This page uses frames. The current browser you are using does not support frames.</p>    <?php$con= mysql_connect("localhost","root","root");if(!$con){die('Could not connect : ' . mysql_error());}mysql_select_db("tes",$con);$result = mysql_query("select * from cat");while($row = mysql_fetch_array($result)){echo $row['1'] . " " . $row['2'];echo "Go<br/>瓦";}mysql_close($con)	?>    </body></html>

输出的是:

This page uses frames. The current browser you are using does not support frames.
a "乱码不给打" 123Go
瓦
列1中的数据在数据库中是' a 啊 ' 输出后乱码求教.

回复讨论(解决方案)

mysql_select_db("tes",$con);
mysql_query('set names utf8'); //加上这句

页面打开时默认的字符编码是GBK 手动切换成UTF8就可以正常显示但是在后面自己输入的中文又变成了乱码求教

mysql_select_db("tes",$con);
mysql_query('set names utf8'); //加上这句

加了,无效还是乱码. 目前试过正常输出的情况就是手动切换成utf,页面打开的时候默认使用了GBK.

但是切换成UTF8的话在后面的自己输入的中文就变成了乱码

我去.这下倒成了.我用java的时候打UTF8也能识别- - 没想到现在不可以.
不过还有一个问题就是这样的话我在读取完数据库之后自己输入的一个中文又变成了乱码

在哪输入，编辑器中？那说明你的文件不是utf-8编码，用编辑器设成utf-8 无bom 头格式保存。

已通过更改文本字符编码解决乱码问题谢谢

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

PHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

How to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

See all articles