PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔÒò¼°½â¾ö
PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔÒò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕ߶¼Í³Ò»²ÅÐУº£¨ÒÔutf-8ΪÀý£©
1£ºÒ³ÃæÌá½»Êý¾Ý±àÂëutf-8£¨ÕâÒ²¿ÉÒÔËãÊÇÏÔʾҳÃæ±àÂ룩£¬
2£ºÊý¾Ý¿âдÈëʱ±àÂ룺alter database db default character set ‘utf8’collate ‘utf8-general-ci’£¬
3£ºÊý¾Ý¿â¶ÁȡʱËùÓñàÂ룺mysql_query£¨“set names ‘utf8’”£©£»
4£ºÏÔʾҳÃæ±àÂ룺
×¢£ºÈç¹ûÄã´Ó³ÌÐò»òÊÇÖ±½ÓÔÚphpMYadminÀï²åÈëÖÐÎÄ»¹³öÏÖÂÒÂëÏÖÏóµÄ»°£¬Äã²»·À°´ÏÂÃæµÄ²Ù×÷ÊÔ£¡£¡£¡
½øÈëMYSQLÃüÁîÐÐ:
mysql> alter database you_dbname default character set 'utf8';
mysql> SET character_set_client='utf8';
mysql> SET character_set_connection='utf8'
mysql> SET character_set_results='utf8'
utf8ºÍgbkÖ®¼äµÄ±àÂëת»»
function gb2utf($string) {
$out = iconv( "gb2312", "UTF-8" , $string);
return $out;
}
Ïà¹ØÎĵµ£º
mssql,oracleÖÐ
test񡜧
1 5 abc
2 6 bcd
1 7 ade
2 8 adc
select a,b,c
from(
select a,b,c
,row_number()over(partition by a order by b desc) rn
from test
) &nb ......
<?php
/********************************************************************
* FileName: class.msn.php
* by changwei, 2010-4-13
* Contact MSN: changwei0112@hotmail.com
* »ñÈ¡MSNºÃÓÑEmailÁбí
*
========================== ......
<?php
$s = <<<html
<html>
<head>
<title>nested tag test</title>
<mce:script type="text/javascript"><!--
alert('fdsafdasfasd');
// --></mce:script>
</head>
<body>
<div id=0>
<div id=1><img name="im ......
ÉϺ£ÔóÎäÍøÂçÓÐÏÞ¹«Ë¾
ÕÐƸ£ºÕÐƸjsp\phpÍøÕ¾¿ª·¢³ÌÐòÔ±
ÒªÇóÓÐÈýÄêÒÔÉÏ¿ª·¢¾Ñé
¶ÔTomcat+Apache¼¯Èº¼¼ÊõÓÐÊìϤµÄ¾Ñé.¶ÔËÑË÷ÒýÇæ¼¼Êõ(Lucene)±È½ÏÁ˽⡣
-ÊìÁ·Ê¹ÓÃUML½¨Ä£¹¤¾ß¡¢°æ±¾¿ØÖƹ¤¾ß; ÊìÁ·Ê¹ÓÃEclipseµÈIDE¿ª·¢¹¤¾ß;
-¾«Í¨JAVA,php,ÉîÈëÀí½âOOP˼Ïë,ÊìϤÉè¼Æģʽ¡£
-ÊìÁ·ÔËÓÃJ2EE¼¼Êõ¡¢WEB·þÎñÆ÷ºÍ¹ØϵР......