2008年10月_book2016

12月 11月 10月 09月

原创 backup mysql database and ftp to another computer

#!/bin/sh# mysql data backup by Jason# by scud http://www.lcshow.com# 2008-01-23## use mysqldump#BakDir=/backup/mysqlLogFile=/backup/mysql/mysqlbak.logDATE=`date +%Y%m%d`echo " " >> $LogFileecho " " >

2008-10-22 13:38:00 700

原创 delete all files but do not delete any directory

#!/bin/bashmyfunc(){ for x in $(ls) do if [ -f "$x" ];then echo "$x is file"; rm -rf "$x"; elif [ -L "$x" ];th

2008-10-21 17:34:00 634

原创 Use javascript to detect the type of the file

function checkfilename(f){ var fname=f.upfile.value; //正规表达式判断文件类型 var patrn=/^.*/.zip$/; if (!patrn.exec(fname)) { alert("请选取zip文件"); return false; } else return t

2008-10-17 11:33:00 733

原创 Get the parameter of webservice xml

{//test1模块处理 Pattern pattern = Pattern.compile(".*?"); Matcher matcher = pattern.matcher(xmlDataFromServer); if(matcher.find()) { //System.out.

2008-10-17 10:21:00 619

原创 Get the directory of one php file

$nowdir=$_SERVER["SCRIPT_FILENAME"]; //echo $nowdir.""; /** * The below regulartion will only support windows system, * because in windows system if you use $_SERVER[

2008-10-17 10:18:00 711

转载 the comment of zend develepment environment

zend下面的注释 /**[Enter]就出来了。而且你连打[Enter]行前自动加*。 /** * Enter description here... * * @var unknown_type */////////////////////////////////////注释在PHPDoc中分为文档注释和非文档注释　　　　3.1 文档注释　　文档注释实际上是一些特殊形式的多行注

2008-10-14 18:15:00 656

原创 install visualsvn

1. 访问http://subversion.tigris.org/getting.html#windows2. 下载visualsvn并安装3. 增加repository,并命名，比如命名为nangua4. 增加user比如jevons/jevons<v:shapetype id="_x0000_t7

2008-10-14 13:24:00 662

原创 look the files size in linux system

[root@dzsw mall]# du -sh * | sort -n1.3M i4581.8M img2.0M c8002.0M pic2.2M sheying2.3M N962.4M img23.1M languages3.8M templates5.7M CVS5.8M admin7.1G forum8.0K a

2008-10-13 14:50:00 609

转载 sql左联右联的通俗解释

给个通俗的解释吧. 例表a aid adate 1 a1 2 a2 3 a3 表b bid bdate 1 b1 2 b2 4 b4 两个表a,b相连接,要取出id相同的字段 select * from a inner join b on a.aid = b.bid这是仅取出匹配的数据. 此时的取出的是: 1 a1 b1 2 a2 b2

2008-10-13 10:02:00 741

原创 mysql5.0 support regular expression

I test regular expression in mysql5.0.It work ,the test sentance is below:SELECT fo/nfo REGEXP ^fo$;

2008-10-13 10:00:00 518

原创 use regular expression in the oracle sqlplus

SQL> select Customer_id from CUSTOMER_PUBLIC_INFO where regexp_like(customer_id,BJBJ[^123456789]*1$);CUSTOMER_ID----------------------------------------BJBJ00000001oracle 数据库目前内建了符合posix 标准的正则表达式。

2008-10-12 15:41:00 679

转载 the database tables and fields of ecshop

ECSHOP数据库结构参数表序言本次信息整理只为了从事ECSHOP 二次开发人员方便之举，因此研究ECSHOP 官方数据结构，如若与官方产生冲突，敬请谅解！此版本属于V2.1.15 此信息属于网上一位朋友注释！另外ECSHOP V2.5 的表结构信息我正在整理中现在先把这份发布上来！QQ:381326730表结构分析ecs_account_log // 用户账目日志表ecs_activity //

2008-10-10 16:37:00 857

原创 how to test the real character number if the string include chinese character,notice one chinese character only calculater one b

int first(unsigned char ch){if(ch>=0xb0&&ch return 1;else return 0;}int second(unsigned char ch){ if(ch>=0xa1&&ch return 1;else return 0;}int check(const char* p){int i=0;for(i=0;i if(first(p[i]

2008-10-09 23:13:00 679

原创 Use different port to test different website in apache

Listen 81Listen 82Listen 83Listen 84Listen 85 ServerAdmin webmaster@66778.cn DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs/asetup" ServerName www.asetup.cn

2008-10-06 17:37:00 626

转载 how to know whether one string is english string

//Clear all cache by below code function sure_en($query_keyword){ $ret_flag=false; preg_match_all(/^([A-Za-z0-9]*?)$/i, $query_keyword, $match); $icount=count($match[1]); if($icount>0) $

2008-10-01 22:17:00 590

原创 Get the data of today only use c language

#include void CTestDlg::OnOK() {time_t rawtime; struct tm * timeinfo; time ( &rawtime ); timeinfo = localtime ( &rawtime ); char nowtime[200];sprintf (nowtime, "%4d_%02d_%02d",1900+timeinfo->tm_year

2008-10-01 21:35:00 649

原创 Use windows socket to download http page

1)Because we need use windows socket to get http page,we need initialise win socketAt the beginning of our application,we should do below: int err; WORD wVersion; WSADATA WSAData; wVer

2008-10-01 17:08:00 1333

原创 How to navigate every url to www.csdn.net

if(dispidMember == DISPID_BEFORENAVIGATE2) { BSTR bstrUrlName; HRESULT hr = m_spWebBrowser2->get_LocationURL(&bstrUrlName);

2008-10-01 12:05:00 923

原创 how to get url and hostname and url text in one page

STDMETHODIMP CIEHlprObj::Invoke(DISPID dispidMember, REFIID riid, LCID lcid, WORD wFlags, DISPPARAMS* pDispParams, VARIANT* pvarResult, EX

2008-10-01 11:25:00 881

原创 how to test IEHelper.DLL

1.compile one IEHelper.dll program2.copy the dll into C:/windows/system323.input dos cmd :C:/WINDOWS/system32>regsvr32 IEHelper.dll4.close all ie explore browser5.open a new ie explore browser,your

2008-10-01 11:23:00 701