亚洲AV无码一区二区三区在线,亚洲国产精品va在线播放,亚洲综合激情五月色一区

AJAX技术检��用户名是否已被一�?

Mon, 23 Apr 2007 11:10:00 GMT

吴涛�?/a> 2007-04-23 19:10 发表评论

javascript生成上传囑փ�预览功能

Mon, 23 Apr 2007 11:09:00 GMT

javascript生成上传囑փ�预览功能

type=file name=photo1>

width=66 name=preview1>

吴涛�?/a> 2007-04-23 19:09 发表评论

Mon, 16 Apr 2007 11:38:00 GMT

//utf-8->gb2312函数�Q�本�E�序没有用到�Q�仅供参�?br>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)."
";
    $ar[$k] = iconv("UCS-2","GB2312",pack("n",substr($v,2,-1)));
}
}
return join(" ",$ar);
}
//下面是�{换功�?br>$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函数的��?br>        $update="update dede_archives set title='".$con."' where ID=".$fields[0];
        //echo $update;
        mysql_query($update);
        echo $fields[0]."OK"."
";
}
?>

吴涛�?/a> 2007-04-16 19:38 发表评论

Fri, 13 Apr 2007 08:03:00 GMT

最�q�在研究CMS�Q�在数据转换的时候需要用到mysql的replace函数�Q�这里简单介�l�一下！

比如你要��?�?tb1里面�?f1字段的abc替换为def

UPDATE tb1 SET f1=REPLACE(f1, 'abc', 'def');

REPLACE(str,from_str,to_str)
在字�W�串   str   中所有出现的字符�?nbsp; from_str   均被   to_str替换�Q�然后返回这个字�W�串�Q?nbsp;
mysql>   SELECT   REPLACE('www.mysql.com',   'w',   'Ww');
                  ->   'WwWwWw.mysql.com'
�q�个函数是多字节安全的�?br>
�C�Z��Q?br>UPDATE `dede_addonarticle` SET body = REPLACE ( body,
'',
'' );
UPDATE `dede_addonarticle` SET body = REPLACE ( body,
'',
'' );
UPDATE `dede_addonarticle` SET body = REPLACE ( body,
'',
'' );
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中插入两条记录�?br>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‘)

吴涛�?/a> 2007-04-13 16:03 发表评论

AtLeap中运用Mysql

Thu, 29 Mar 2007 11:46:00 GMT

1、环境说明：
WINDOWS2003、JDK 1.5.0_11、ANT 1.6.5、Tomcat 5.0.27、MySQL4.1.10a�Q?br />先设�|�好环境变量�Q?br />
2、数据库讄��
#database.jar=${mysql.jar}
#database.jar.name=${mysql.jar.name}
#database.dir=${mysql.dir}
#database.version=${mysql.version}
#database.type=mysql
#database.name=${webapp.name}_db
#database.host=localhost
#database.port=3306
#database.driver_class=com.mysql.jdbc.Driver
#database.url=jdbc:${database.type}://${database.host}:${database.port}/${database.name}?characterEncoding=utf-8&useUnicode=true&autoReconnect=true
#database.username=test
#database.password=test
#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

改�ؓ�Q?br />database.jar=${mysql.jar}
database.jar.name=${mysql.jar.name}
database.dir=${mysql.dir}
database.version=${mysql.version}
database.type=mysql
database.name=${webapp.name}_db
database.host=localhost
database.port=3306
database.driver_class=com.mysql.jdbc.Driver
database.url=jdbc:${database.type}://${database.host}:${database.port}/${database.name}?characterEncoding=utf-8&useUnicode=true&autoReconnect=true
database.username=数据库用户名
database.password=数据库密�?br />hibernate.dialect=org.hibernate.dialect.MySQLDialect

在数据库初始化的�q�程中，提示${hibernate.transaction.factory_class}�Q�我��在properties.xml中将

改�ؓ

��可以通过�Q?/font>

3、服务器讄��
1)
# Jetty is embeded into AtLeap distribitive
appserver.type=jetty5
appserver.http.port=8080
# in order to enable support HTTPS please reconfigure jettyplus.xml
appserver.https.port=8443
# the memory sizes
jetty.initialmemory=128m
jetty.maxmemory=256m

改�ؓ�Q?br /># Jetty is embeded into AtLeap distribitive
# appserver.type=jetty5
# appserver.http.port=8080
# in order to enable support HTTPS please reconfigure jettyplus.xml
# appserver.https.port=8443
# the memory sizes
# # jetty.initialmemory=128m
jetty.maxmemory=256m

2)
# Please specify tomcat5 or tomcat5.5
#appserver.type=tomcat5.5
#appserver.http.port=8080
#appserver.https.port=8443

#tomcat.manager.host=${appserver.host}
#tomcat.manager.port=${appserver.http.port}
#tomcat.manager.url=http://${tomcat.manager.host}:${tomcat.manager.port}/manager
#tomcat.manager.username=manager
#tomcat.manager.password=manager

改�ؓ�Q?br /># Please specify tomcat5 or tomcat5.5
appserver.type=tomcat
appserver.http.port=8080
appserver.https.port=8443

tomcat.manager.host=${appserver.host}
tomcat.manager.port=${appserver.http.port}
tomcat.manager.url=http://${tomcat.manager.host}:${tomcat.manager.port}/manager
tomcat.manager.username=manager
tomcat.manager.password=manager

4、部�|�设�|?br /># Usually you do not need to specify below properties
#tomcat.home=C:/TOOLS/java/jakarta-tomcat-5.5.7
#tomcat.app.base=${tomcat.home}/webapps
#tomcat.service.name=Catalina
#tomcat.work.dir=${tomcat.home}/work/${tomcat.service.name}/${appserver.host}/${context.doc.base}
#tomcat.conf.dir=${tomcat.home}/conf/${tomcat.service.name}/${appserver.host}

改�ؓ�Q?br />
# Usually you do not need to specify below properties
tomcat.home=c:/tomcat
tomcat.app.base=${tomcat.home}/webapps
tomcat.service.name=Catalina
tomcat.work.dir=${tomcat.home}/work/${tomcat.service.name}/${appserver.host}/${context.doc.base}
tomcat.conf.dir=${tomcat.home}/conf/${tomcat.service.name}/${appserver.host}

回到build.xml所在的目录�Q�执行ant deploy�Q?br />
5、测试运�?br />http://localhost:8080/atleap

参考文档：Blandware AtLeap 安装说明

吴涛�?/a> 2007-03-29 19:46 发表评论

AtLeap

Thu, 29 Mar 2007 10:23:00 GMT

AtLeap是一个基于AppFuse的CMS�Q�最新版本是0.52�Q�按官方说直接运行就可以�Q�还是花了点旉��Q�用了其内置的服务器jetty�Q�开始时以�ؓ是jvm的问题，改�ؓ1.4.2�Q�问题还是一��P��仔细看了出错信息后，增加一个ANT_OPTS环境变量后，再运行就可以通过了�?br />
有朋友说配置Mysql�q�行比较�Ҏ��Q�还没有��试�Q?br />
AtLeap支持多语�a��Q�听说还获得了不��奖�Q�应该是一个不错的CMS�Q�有�I�好好看看�?br />

吴涛�?/a> 2007-03-29 18:23 发表评论

亚洲AV无码一区二区三区在线,亚洲国产精品va在线播放,亚洲综合激情五月色一区

AJAX技术检���用户名是否已被一�?

javascript生成上传囑փ�预览功能

AtLeap中运用Mysql

AtLeap

AJAX技术检��用户名是否已被一�?