对于乱码这个问题php开发者几乎都会有碰到过,我们下面主要是介绍了php文件乱码和页面乱码以及php mysql数据库连接时乱码解决方法。
PHP页面转UTF-8编码问题
1.在代码开始出加入一行:header("Content-Type: text/html;charset=utf-8");
2.PHP文件编码问题,点击编辑器的菜单:“文件”->“另存为”,可以看到当前文件的编码,确保文件编码为:UTF-8,如果是ANSI,需要将编码改成:UTF-8。
3.PHP文件头BOM问题:PHP文件一定不可以有BOM标签,否则,会出现session不能使用的情况,并有类似的提示:Warning: session_start() [function.session-start]: Cannot send session cache limiter – headers already sent
这是因为,在执行session_start() 的时候,整个页面不能有输出,但是当由于前PHP页面存在BOM标签,PHP把这个BOM标签当成是输出了,所以就出错了,所以PHP页面一定要删除BOM标签
删除这个BOM标签的方法:
(1).可以用Dreamweaver打开文件,并重新保存,即可以去除BOM标签!
(2).可以用EditPlus打开文件,并在菜单“首选项”->“文件”->"UTF-8标识",设置为:“总是删除签名”,然后保存文件,即可以去除BOM标签!
4.PHP以附件形式保存文件的时候,UTF-8编码问题:PHP以附件形式保存文件,文件名必须是GB2312编码,否则,如果文件名中有中文的话,将是显示乱码:如果你的PHP本身是UTF-8编码格式的文件,需要将文件名变量由UTF-8转成GB2312:
iconv("UTF-8", "GB2312", "$filename");
利用程序来实例字符截取方法
- function utf8_substr($str,$len)
- {
- for($i=0;$i<$len;$i++)
- {
- $temp_str=substr($str,0,1);
- if(ord($temp_str) > 127){
- $i++;
- if($i<$len){
- $new_str[]=substr($str,0,3);
- $str=substr($str,3);
- }
- }else {
- $new_str[]=substr($str,0,1);
- $str=substr($str,1);
- }
- }
- return join($new_str);
- }
1.用phpmyadmin创建数据库和数据表,创建数据库的时候,请将“整理”设置为:“utf8_general_ci”或执行语句:
CREATE DATABASE `dbname` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
创建数据表的时候:如果是该字段是存放中文的话,则需要将“整理”设置为:“utf8_general_ci”,如果该字段是存放英文或数字的话,默认就可以了。
相应的SQL语句,例如:
- CREATE TABLE `test` (
- `id` INT NOT NULL ,
- `name` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
- PRIMARY KEY ( `id` )
- ) ENGINE = MYISAM ;
2.用PHP读写数据库,在连接数据库之后:
[hide]$connection = mysql_connect($host_name, $host_user, $host_pass);
加入两行:
- mysql_query("set character set 'utf8'");//读库
- mysql_query("set names 'utf8'");//写库
就可以正常的读写MYSQL数据库了,用的appserv-win32-2.5.10做的环境,装这个包的时候用默认的utf8编码,在写数据库连接文件时,写成:
- $conn = mysql_connect("$host","$user","$password");
- mysql_query("SET NAMES 'UTF8'");
- mysql_select_db("$database",$conn);
然后在做页面时,注意这句:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
这样不管输入数据库的中文,还是页面显示,就都正常了,在DW CS4版里,默认生成的也是utf8页面,同样的,如果一开始写数据库连接文件时写成:
mysql_query("SET NAMES 'GBK'");
那页面也要相应变成:
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
总结,最后主要是页面编码要统一就可以很方便的解决乱码问题,特别是在mysql_query()这个set names的设置必须和页面及数据库编码统计一就可以了。
波比源码 » php和mysql中uft-8中文编码乱码的几种解决办法
purchase levofloxacin without prescription buy generic levofloxacin
ampicillin oral sulfamethoxazole sale buy generic erythromycin
buy sildenafil for sale order fildena 100mg online cheap oral robaxin 500mg
prednisone tablet deltasone 20mg over the counter order viagra 50mg online
order tacrolimus generic urso 300mg pill order urso online cheap
zyban 150 mg without prescription zyrtec order seroquel 50mg usa
order zoloft 100mg pill order generic sertraline 50mg sildenafil in usa
order dapsone 100mg sale order generic adalat 30mg buy aceon 8mg
tadalafil online cialis walmart buy viagra online
clozapine 50mg generic order combivent 100 mcg online decadron oral
sildenafil 100mg pills for sale viagra 50mg brand buy lisinopril 10mg online
oral tadalafil cialis 20mg over the counter buy viagra 50mg without prescription
buy losartan online cheap purchase losartan sale oral topamax 200mg
ozobax buy online tizanidine 2mg us buy toradol online cheap
order sumatriptan 50mg online cheap oral dutasteride purchase avodart generic
buy gloperba online colchicine 0.5mg drug online blackjack with real money
tadalafil drug tadalafil oral ciprofloxacin 500mg oral
zocor 10mg drug zocor 10mg sale buy finasteride 1mg generic
fluconazole online buy diflucan tablet viagra mail order usa
cost viagra cialis 40mg pill cialis 5mg without prescription
online casino games for real money big fish casino online order modafinil 200mg online
prednisone 10mg cost order deltasone for sale purchase vermox
retin gel cheap order tadalis 10mg generic avanafil 100mg pills
tadalafil cost brand indocin 75mg order indomethacin 75mg generic
order tiotropium bromide 9mcg pill buy generic tiotropium bromide terazosin sale
order generic proventil 100mcg order cipro online cheap order cipro 1000mg
order singulair 5mg sale montelukast price viagra order
order tadalafil 20mg pills Cialis medication win real money online casino
tadalafil 5mg brand Best price for generic cialis real cialis
ivermectin 6 mg otc order stromectol 6mg order avlosulfon 100 mg pill
buy adalat 30mg pills perindopril over the counter order fexofenadine
ramipril 5mg oral order ramipril 5mg generic buy etoricoxib 120mg sale
mesalamine 800mg tablet order irbesartan 300mg pill cost avapro
temovate us buspar 10mg for sale amiodarone over the counter
carvedilol 25mg sale purchase elavil for sale generic elavil 50mg
fosamax 35mg for sale alendronate ca order motrin 600mg pill
buy priligy online order avanafil online cheap order domperidone 10mg generic
indocin 50mg without prescription indomethacin ca cenforce online
generic famotidine 20mg tacrolimus 1mg oral purchase remeron
ropinirole online buy purchase labetalol pills order labetalol 100 mg generic
buy generic esomeprazole 40mg buy nexium 20mg capsules order lasix generic
glucophage generic buy tamoxifen 10mg pill buy nolvadex 20mg online cheap
buy prednisone online cheap purchase accutane pills cheap amoxil tablets
cost clomid order prednisolone 5mg generic order prednisolone 40mg pill
order fildena 100mg proscar 1mg over the counter buy propecia generic
accutane 40mg generic buy ampicillin 250mg generic ampicillin 500mg cost
buy ondansetron pills purchase bactrim online cheap sulfamethoxazole for sale
ivermectin 20 mg order stromectol 12mg pills order prednisone online cheap
buy prednisolone 5mg generic order lasix 100mg pill buy lasix online diuretic
purchase avodart for sale buy keflex 250mg for sale order generic orlistat 60mg
order generic monodox oral zovirax acyclovir pill
sildenafil india sildenafil 50mg tadalafil 10mg for sale
purchase alfuzosin generic buy alfuzosin 10 mg order diltiazem 180mg generic
order levofloxacin 250mg online actigall 150mg canada bupropion 150 mg generic
purchase cenforce order metformin 1000mg online glycomet 500mg brand
cialis 10mg oral buy tadalafil 5mg pill buy ed medication online
ivermectin 20 mg isotretinoin 40mg ca buy accutane 20mg without prescription
buy amoxil 500mg for sale azithromycin 500mg cost buy prednisolone 5mg generic
brand isotretinoin 10mg isotretinoin 20mg for sale azithromycin without prescription
buy clomid pills buy serophene for sale purchase plaquenil generic
buy albenza 400 mg for sale albenza 400mg for sale order provera online cheap
buy metformin 1000mg generic lipitor 20mg over the counter amlodipine 10mg us
order praziquantel 600mg without prescription hydrochlorothiazide 25mg generic buy cyproheptadine generic
lisinopril 2.5mg without prescription purchase metoprolol pill generic metoprolol
purchase lyrica generic buy priligy 90mg dapoxetine 60mg price
orlistat oral buy orlistat 60mg how to buy allopurinol
buy cheap sumatriptan buy levofloxacin online order avodart pills
sumycin where to buy buy baclofen buy ozobax online
buy toradol 10mg for sale colcrys pills inderal 20mg canada
zantac medication mobic for sale celebrex online
plavix 75mg without prescription fluvoxamine 50mg tablet buy nizoral pills for sale
order tamsulosin 0.2mg online cheap cost spironolactone 100mg buy generic aldactone over the counter
order cymbalta 20mg sale generic duloxetine order nootropil 800mg for sale
betnovate creams sporanox 100mg tablet sporanox us
ipratropium without prescription buy cheap combivent oral zyvox 600mg
progesterone 200mg brand buy olanzapine generic olanzapine oral
nateglinide brand buy capoten 25 mg pill candesartan 16mg uk
simvastatin 20mg over the counter sildenafil 50mg drug cheap viagra 50mg
buy carbamazepine 200mg lincocin 500 mg drug order lincomycin 500mg for sale
order cefadroxil online cheap buy duricef 500mg for sale propecia cost
order estradiol sale order lamictal 200mg sale prazosin 2mg price
diflucan 200mg ca where to buy ampicillin without a prescription ciprofloxacin cheap
avana brand avana for sale online diclofenac 100mg price
cleocin brand oral cleocin buy fildena no prescription
oral nolvadex 20mg order nolvadex 10mg generic buy ceftin 250mg
catapres 0.1 mg pill generic meclizine buy spiriva 9mcg online
minocin capsules buy minocycline 100mg online actos 30mg cheap
order arava sale buy leflunomide 10mg generic buy sulfasalazine medication
ivermectin tablet prednisone 20mg without prescription deltasone 5mg without prescription
buy furosemide tablets cheap doxycycline order albuterol 2mg sale
ramipril 10mg uk buy amaryl 1mg buy etoricoxib 60mg without prescription
vardenafil 10mg ca cheap levitra 20mg hydroxychloroquine 400mg uk
buy benicar sale benicar 10mg pills depakote 500mg drug
order generic clobetasol temovate for sale buy generic amiodarone 100mg