Çë½Ì liunx php mysqlÖÐÎÄÂÒÂëÎÊÌâ
ÍøÉÏ¿´ÁËЩÎÄÕ²»ÊǺÜÃ÷°× ÇëÖ¸µãÏÂ
ÓÐʱÊÇphpMyAdmin²é¿´¿âÖеĺº×Ö¶¼ÊÇ£¿
ÓÐʱphpÒ³ÃæÏÔʾµÄ¶¼ÊÇÂÒÂë
Äã¿ÉÒÔÏȲ鿴һÏÂÄã´æÈëÊý¾Ý¿âÖеÄʱºò£¬ÄãµÄÖµÊDz»ÊǾÍÊÇÂÒÂë¡£
Õâ¸öÎÊÌâÎÒÒÔǰҲÓöµ½¹ý£¬PHP¶ÔÒ³ÃæµÄºº×Ö±àÂë±È½ÏÑϸñ£¬ÁíÍâmysqlÖÐÿ¸ö×Ö¶ÎÒ²¿ÉÒÔµ¥¶ÀÉèÖÃ×Ö·û±àÂë¸ñʽ¡£
ʲô½ÐÓÐʱ°¡£¿
Õâ¸ö¸úÄãÊý¾Ý¿âµÄĬÈϱàÂëÓйØÏµ£¬ÖÐÎͼÊÇÎʺŵϰ£¬ÄǾÍÊÔ×ÅÔÚÖ´ÐÐSQLÓï¾äǰ¼ÓÉÏÒ»¾ä£º
set names gbk;
select * from test
²»ÐÐÔÙÊÔһϣºset names utf8£»
·´Õý¾ÍÊDZàÂëÑ¡Ôñ²»¶Ô£¬»¹ÊDz»ÐоÍÊÔһϱðµÄÈ磺latin1µÈ
È·¶¨ÊÇÄÄÖÖ±àÂëºó£¬ÔÚÒ³Ãæ²éѯʱ¾ÍÔÚ²éѯÓï¾äÇ°Ãæ¼ÓÉÏÕâ¸öÉèÖñàÂëÓï¾äºóÔÙ²éѯ¾Í¿ÉÒÔÁË£¡
Ö±½ÓÔÚphpMyAdmin insert Êý¾Ý£¬µÄphpMyAdmin²é¿´Õý³£ ÍøÒ³²»Õý³£
phpÍøÒ³Ìá½» ÍøÒ³ÏÔʾÕý³£¡£phpMyAdmin ÏÔʾ²»Õý³£
±¾»úwindowsϵͳûÓÐÎÊÌâ¡£¾ÍÊÇ´«µ½ÍøÉϲ»ÐÐÁË
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
ÍøÒ³¶¼ÊÇutf-8±àÂëµÄ
ÄãÓõÄÊÇʲôϵͳ£¿¿Ï¶¨ÊÇÔÚ½¨Á¢Á¬½ÓʱÉèÖÃÁ˱àÂë¸ñʽ£¿
²»¹ý£¬Èç¹ûÊÇÓõÄͬһ¸öÁ¬½ÓÄÇÓ¦¸Ã²»»á³öÏÖÕâÑùµÄÎÊÌ⣬ÒòΪÔÚÈ¡Êý¾ÝʱҲ½øÐÐÁ˱àÂëÉèÖÃÁË
³ý·ÇÊÇÄã×Ô¼ºÓÖ´´½¨ÁËÁ¬½Ó£¬ÒªÊǵϰ£¬ÄǾÍÔÚÁ¬½ÓʱÏàÓ¦µÄ¼ÓÒ»¾äÉèÖÃÓï¾ä¾Í¿ÉÒÔÁË£¡
ÖÁÓÚÊÇʲô±àÂ룬¾Í°´ÎÒÉÏÃæÐ´µÄ£¬ÔÚÊý¾Ý¿âÀïÖ±½Ó¼ÓÉÏÄǸöÉèÖÃÓï¾äºóÔÙÊÔһϣ¬ÕÒµ½ÊÇʲô±àÂë²Å²»ÂÒÂë¡£
ÔÚphpMyAdminÖÐ sql
set names latin1;
select * from test;
ÉÏÃæµÄÕ
Ïà¹ØÎÊ´ð£º
¸÷λ´óÏÀ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
¸÷λ´óÏÀ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......