新换了个名声还不错的虚拟主机，的确asp的效率还是可以的，但是随便上什么php程序，那个执行之慢，简直无法忍受。
drupal只能用5.x，用6.x的，管理菜单十次有九点九次都打不开，都是500错误。
当初还选了mysql数据库，真不知道用来做什么了？勉强开个dp试试吧！
访问速度也是时快时慢，看来我么本地的网络也不好。

  if(preg_match("/^\d*$/",   "4312"))
{
echo   "全数字
";
}

if(preg_match("/^[a-z]*$/i",   "fdsFDfd"))
{
echo   "全字母
";
}

if(preg_match("/^[a-z\d]*$/i",   "fd4fd34"))
{
echo   "有数字有字母
";
}

来自：http://www.yatan.com/group/topic.php?tid=21091

匹配所有中文字符的正则表达式是/[一-龥]/u，php代码如下。
要保存为utf-8编码

preg_match_all('/[一-龥]/u', '龥大家好一s々 Ⅳ ４ Ｎ ぁ Ψ Ж ㄩ ā 몸234adsf', $matchs);
print_r($matchs);

运行结果如下：

Array
(
[0] => Array
(
[0] => 龥
[1] => 大
[2] => 家
[3] => 好
[4] => 一
)

)
下面是匹配所有不包含某个字符串的正则表达式:

^(?!.*?word).*$

http://www.juyimeng.com/regular-expression-match-all-chinese-characters.html

准备用php＋sqlite做个小东西，原计划用sqlite3，不过需要PDO扩展支持，不是很方便。而sqlite2是PHP5默认支持的，很多php虚拟机应该能够支持。现在只是学习，性能不是必须考虑的东西，方便第一！

现准备收集一些php_sqlite的资料。

函数(来自官方文档，直接复制没加修改)：

sqlite_array_query — Execute a query against a given database and returns an array
sqlite_busy_timeout — Set busy timeout duration, or disable busy handlers
sqlite_changes — Returns the number of rows that were changed by the most recent SQL statement
sqlite_close — Closes an open SQLite database
sqlite_column — Fetches a column from the current row of a result set
sqlite_create_aggregate — Register an aggregating UDF for use in SQL statements
sqlite_create_function — Registers a "regular" User Defined Function for use in SQL statements
sqlite_current — Fetches the current row from a result set as an array
sqlite_error_string — Returns the textual description of an error code
sqlite_escape_string — Escapes a string for use as a query parameter
sqlite_exec — Executes a result-less query against a given database
sqlite_factory — Opens a SQLite database and returns a SQLiteDatabase object
sqlite_fetch_all — Fetches all rows from a result set as an array of arrays
sqlite_fetch_array — Fetches the next row from a result set as an array
sqlite_fetch_column_types — Return an array of column types from a particular table
sqlite_fetch_object — Fetches the next row from a result set as an object
sqlite_fetch_single — Fetches the first column of a result set as a string
sqlite_fetch_string — Alias of sqlite_fetch_single
sqlite_field_name — Returns the name of a particular field
sqlite_has_more — Finds whether or not more rows are available
sqlite_has_prev — Returns whether or not a previous row is available
sqlite_key — Returns the current row index
sqlite_last_error — Returns the error code of the last error for a database
sqlite_last_insert_rowid — Returns the rowid of the most recently inserted row
sqlite_libencoding — Returns the encoding of the linked SQLite library
sqlite_libversion — Returns the version of the linked SQLite library
sqlite_next — Seek to the next row number
sqlite_num_fields — Returns the number of fields in a result set
sqlite_num_rows — Returns the number of rows in a buffered result set
sqlite_open — Opens a SQLite database and create the database if it does not exist
sqlite_popen — Opens a persistent handle to an SQLite database and create the database if it does not exist
sqlite_prev — Seek to the previous row number of a result set
sqlite_query — Executes a query against a given database and returns a result handle
sqlite_rewind — Seek to the first row number
sqlite_seek — Seek to a particular row number of a buffered result set
sqlite_single_query — Executes a query and returns either an array for one single column or the value of the first row
sqlite_udf_decode_binary — Decode binary data passed as parameters to an UDF
sqlite_udf_encode_binary — Encode binary data before returning it from an UDF
sqlite_unbuffered_query — Execute a query that does not prefetch and buffer all data
sqlite_valid — Returns whether more rows are available
记录于此，准备逐渐翻译学习

网上注册时经常发现在输入用户名后就可以立即知道该用户名是否可用,自己简单做了个,php+sqlite的,很简单可以演示一下原理
注册文件zc.html

数据库操作文件zc.php

beginTransaction();
$sth = $dbh->prepare("Select * FROM user where username='".$name."'");
$sth->execute();
if ($result = $sth->fetch(PDO::FETCH_OBJ)){
echo "NO";
}else{
echo "OK";
}
?>