Çó½Ì~~mysqlµÄÎÊÌâ - PHP / »ù´¡±à³Ì
ÎÒ½¨Á˸ö±í ÓÉÓÚÒª´æ´¢±È½Ï´óÁ¿µÄÎÄ×Ö
ËùÒÔÀàÐÍÓõÄÊÇtext
µ«ÊÇÎÒÔÚÓÃÍøÒ³ºǫ́дÈëÊý¾ÝµÄʱºòÌáʾ
Incorrect string value: '\xD5\xA2\xB7\xA7\xC6\xD0...' for column 'bt' at row 1
Ö»ÒªÓÃÖÐÎľͳöÏÖ ±àÂëÀàÐÍÎÒÓõÄÊÇGBK ÓÐûÓÐÈËÄܽâ´ðÏÂ
ת³Éutf-8ÄØ£¬²»ÕýÈ·µÄ×Ö·ûÖµ
ת³Éutf-8Ò²Ò»Ñù »¹ÊDz»ÐÐ
ÍøÒ³Ê¹ÓõıàÂëÒªºÍÊý¾Ý¿â×ֶεÄÏàͬ
Êý¾Ý¿âÒ²ÊÇGBK
ÄÜ·ñ°ÑÄǾäsql Êä³ö¡£ »á²»»áÊÇÀïÃæ³öÏÖÁË ' ÕâÖÖÌØÊâ×Ö·û¡£
ÒѾ½â¾öÁË ÓÃGBK¾ÍÊDz»³É¹¦
¸É´àÎÒÈ«¶¼¸Ä³Éutf8 Õâϳɹ¦ÁË
Ïà¹ØÎÊ´ð£º
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
index.phpÄÚÈÝ£º
$smarty->assign('name',strtotime('-0'));
$smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......