PHP&JavaScript控制系列:客户端数据存储(二)
时间:2007-02-17 来源:PHP爱好者
PHP & Javascript控制系列:客户端数据存储(二)
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
作者/来源:limodou
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
PHP & Javascript控制系列:客户端数据存储(二)
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
作者:Luis Argerich, Alejandro Mitrou 译者:limodou
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
行动!
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
请使用mysql创建一个测试数据库(mysqladmin create testbase),然后创建一个表:
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
create table testeable (
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
timestamp datetime,
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
message text
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
);
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
这是主文件:
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
注意,我们有了装入帧,显示帧和一个名叫“form”的新的帧,这是我们用来向聊天室发送数据的表单。
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
注意一下简单的“display”函数,在这里你可以根据你的想法使用颜色、动态颜色、用户信息,html表格,
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
图像,等等。
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
显示帧文件为:
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
我们保证过的,它会很短的 :-)
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
接下来就是装入帧文件:
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
session_start();
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 在这儿我们使用了session
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
if(!isset($timestamp)) {
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
//如果没有timestamp(时间戳)我们把它定义为0
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$timestamp=0;
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
}
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$dab=mysql_connect("localhost", "user", "password");
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 在这里使用你自已的值mysql_select_db( "testbase",$dab);
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 查询信息不会被客户端看见$query= "select * from testeable where timestamp>'$timestamp'";
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$result=mysql_query($query,$dab);
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$msgs=array();
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 在循环中,我们将对话信息存在一个数组中,并且得到最大的时间戳while($res=mysql_fetch_array($result)) {
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$msgs[]=$res[ "message"];
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
if($res["timestamp"]>$timestamp) {
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$timestamp=$res["timestamp"]; }
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
}
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
session_register( "timestamp");
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 注册时间戳
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
echo '
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
php爱好 者站 http://www.phpfans.net php基础|php进阶|php模板.
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
作者/来源:limodou
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
PHP & Javascript控制系列:客户端数据存储(二)
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
作者:Luis Argerich, Alejandro Mitrou 译者:limodou
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
行动!
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
请使用mysql创建一个测试数据库(mysqladmin create testbase),然后创建一个表:
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
create table testeable (
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
timestamp datetime,
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
message text
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
);
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
这是主文件:
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
注意,我们有了装入帧,显示帧和一个名叫“form”的新的帧,这是我们用来向聊天室发送数据的表单。
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
注意一下简单的“display”函数,在这里你可以根据你的想法使用颜色、动态颜色、用户信息,html表格,
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
图像,等等。
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
显示帧文件为:
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
我们保证过的,它会很短的 :-)
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
接下来就是装入帧文件:
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
--------------------------------------------------------------------------------
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
session_start();
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 在这儿我们使用了session
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
if(!isset($timestamp)) {
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
//如果没有timestamp(时间戳)我们把它定义为0
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$timestamp=0;
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
}
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$dab=mysql_connect("localhost", "user", "password");
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 在这里使用你自已的值mysql_select_db( "testbase",$dab);
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 查询信息不会被客户端看见$query= "select * from testeable where timestamp>'$timestamp'";
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$result=mysql_query($query,$dab);
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$msgs=array();
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 在循环中,我们将对话信息存在一个数组中,并且得到最大的时间戳while($res=mysql_fetch_array($result)) {
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$msgs[]=$res[ "message"];
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
if($res["timestamp"]>$timestamp) {
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
$timestamp=$res["timestamp"]; }
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
}
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
session_register( "timestamp");
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
// 注册时间戳
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
echo '
www.c hinaitpower.comlFbkXTsR50q3GMkMEctY52tu8m
php爱好 者站 http://www.phpfans.net php基础|php进阶|php模板.
相关阅读 更多 +