<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script type="text/javascript">
/* Create a new XMLHttpRequest object to talk to the Web server */
function getbw()
{
var xmlhttp;
try {
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} catch (oc) {
xmlhttp=null;
}
}
if(!xmlhttp && typeof XMLHttpRequest != "undefined")
xmlhttp = new XMLHttpRequest();
return xmlhttp;
}
function IDRequest(n) {
xmlhttp=getbw();
//定義收到服務器的響應后需要執行的JavaScript函數
url=n+document.getElementById('163id').value;//定義網址參數
alert(url);
xmlhttp.open("GET",url, true);
xmlhttp.send(null);
//xmlhttp_request=getXMLRequester();//調用創建XMLHttpRequest的函數
xmlhttp.onreadystatechange = doContents;//調用doContents函數
}
function doContents() {
if (xmlhttp.readyState == 4) {// 收到完整的服務器響應
if (xmlhttp.status == 200) {//HTTP服務器響應的值OK
document.getElementById('message').innerHTML = xmlhttp.responseText;//將服務器返回的字符串寫到頁面中ID為message的區域
} else {
alert(xmlhttp.status);
}
}
}
</script>
</head>
<body>
<input type="text" id="163id" />
<input type="button" value="校驗" onclick="IDRequest('check.php?userid=')" />
<div id="message"></div>
</body>
</html>
<?
//utf-8->gb2312函數,本程序沒有用到,僅供參考
function u2utf82gb($c){
$str="";
if ($c < 0x80) {
$str.=$c;
} else if ($c < 0x800) {
$str.=chr(0xC0 | $c>>6);
$str.=chr(0x80 | $c & 0x3F);
} else if ($c < 0x10000) {
$str.=chr(0xE0 | $c>>12);
$str.=chr(0x80 | $c>>6 & 0x3F);
$str.=chr(0x80 | $c & 0x3F);
} else if ($c < 0x200000) {
$str.=chr(0xF0 | $c>>18);
$str.=chr(0x80 | $c>>12 & 0x3F);
$str.=chr(0x80 | $c>>6 & 0x3F);
$str.=chr(0x80 | $c & 0x3F);
}
return iconv('UTF-8', 'GB2312', $str);
}
function unescape($str) {
$str = rawurldecode($str);
preg_match_all("/(?:%u.{4})|.{4};|\d+;|.+/U",$str,$r);
$ar = $r[0];
print_r($ar);
foreach($ar as $k=>$v) {
if(substr($v,0,2) == "%u")
$ar[$k] = iconv("UCS-2","GB2312",pack("H4",substr($v,-4)));
elseif(substr($v,0,3) == "")
$ar[$k] = iconv("UCS-2","GB2312",pack("H4",substr($v,3,-1)));
elseif(substr($v,0,2) == "") {
echo substr($v,2,-1)."<br>";
$ar[$k] = iconv("UCS-2","GB2312",pack("n",substr($v,2,-1)));
}
}
return join(" ",$ar);
}
//下面是轉換功能
$db = mysql_connect("localhost", "dbname", "password");
mysql_select_db("dbname",$db);
$result = mysql_query("SELECT * FROM dede_archives",$db);
if ($result === false) die("failed");
while ($fields = mysql_fetch_row($result)) {
$con=$fields[10];
$con = iconv("UTF-8","GB2312",$con);//主要是iconv函數的使用
$update="update dede_archives set title='".$con."' where ID=".$fields[0];
//echo $update;
mysql_query($update);
echo $fields[0]."OK"."<br />";
}
?>
最近在研究CMS,在數據轉換的時候需要用到mysql的replace函數,這里簡單介紹一下!
比如你要將 表 tb1里面的 f1字段的abc替換為def
UPDATE tb1 SET f1=REPLACE(f1, 'abc', 'def');
REPLACE(str,from_str,to_str)
在字符串 str 中所有出現的字符串 from_str 均被 to_str替換,然后返回這個字符串:
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
這個函數是多字節安全的。
示例:
UPDATE `dede_addonarticle` SET body = REPLACE ( body,
'</td>',
'' );
UPDATE `dede_addonarticle` SET body = REPLACE ( body,
'</tr>',
'' );
UPDATE `dede_addonarticle` SET body = REPLACE ( body,
'<tr>',
'' );
UPDATE `dede_archives` SET title= REPLACE ( title,
'大洋新聞 - ',
'' );
UPDATE `dede_addonarticle` SET body = REPLACE ( body,
'../../../../../../',
'http://special.dayoo.com/meal/' );
mysql replace
用法1.replace intoreplace into table (id,name) values(‘1‘,‘aa‘),(‘2‘,‘bb‘)
此語句的作用是向表table中插入兩條記錄。
2.replace(object, search,replace)
把object中出現search的全部替換為replaceselect replace(‘www.163.com‘,‘w‘,‘Ww‘)--->WwW wWw.163.com
例:把表table中的name字段中的 aa替換為bbupdate table set name=replace(name,‘aa‘,‘bb‘)