jquery处理XML的实例

最新推荐文章于 2019-05-13 08:33:26 发布

码农代表

最新推荐文章于 2019-05-13 08:33:26 发布

阅读量2.4k

点赞数

分类专栏： web前台js框架文章标签： xml jquery mysql function action user

本文链接：https://blog.csdn.net/qiuyujiaoqiuyulong/article/details/6311179

版权

web前台js框架专栏收录该内容

5 篇文章 0 订阅

订阅专栏

<!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>

</head>

<body>

<strong>
$message[user]
</strong>

: $message[msg]
<br>

<strong>
$message[user]
</strong>

: $message[msg]
<br>

<strong>
$message[user]
</strong>

: $message[msg]
<br>

<strong>
$message[user]
</strong>

: $message[msg]
<br>
</p>

</div>

</body>

</html>

<?php
// 配置信息：
// 1,数据库连接的具体信息
// 2,我们要存储的消息的数目
// 3,用户进到聊天室的时候消息显示的数目
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "root";
$dbname = "chat";
$store_num = 10;
$display_num = 10;

// 错误报告
error_reporting(E_ALL);

// 头部信息
header("Content-type: text/xml");
header("Cache-Control: no-cache");

//连接mysql
$dbconn = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname,$dbconn);

//为容易操作请求数据,我们为请求中的每个参数设置一个变量,每个变量将把请求中的参数值作为其自己的值
//foreach语句遍历所有的POST数据,并且为每个参数创建一个变量,并且给它赋值
foreach($_POST as $key => $value){
$$key = mysql_real_escape_string($value, $dbconn);
}

//屏敝任何错误提示,判断action是否等于 postmsg
if(@$action == "postmsg"){
//插入数据
mysql_query("INSERT INTO messages (`user`,`msg`,`time`)
VALUES ('$name','$message',".time().")",$dbconn);
//删除数据(因为我们默认值存储10条数据)
mysql_query("DELETE FROM messages WHERE id <= ".
(mysql_insert_id($dbconn)-$store_num),$dbconn);
}

//查询数据
$messages = mysql_query("SELECT user,msg
FROM messages
WHERE time>$time
ORDER BY id ASC
LIMIT $display_num",$dbconn);
//是否有新记录
if(mysql_num_rows($messages) == 0) $status_code = 2;
else $status_code = 1;

//返回xml数据结构
echo "<?xml version=/"1.0/"?>/n";
echo "<response>/n";
echo "/t<status>$status_code</status>/n";
echo "/t<time>".time()."</time>/n";
if($status_code == 1){ //如果有记录
while($message = mysql_fetch_array($messages)){
$message['msg'] = htmlspecialchars(stripslashes($message['msg']));
echo "/t<message>/n";
echo "/t/t<author>$message[user]</author>/n";
echo "/t/t<text>$message[msg]</text>/n";
echo "/t</message>/n";
}
}
echo "</response>";

?>

所生成的XML文件!!

<?xml version="1.0" encoding="UTF-8"?>
<response>
<status>1</status>
<time>1170323512</time>
<message>
<author>张三</author>
<text>沙发!</text>
</message>
<message>
<author>李四</author>
<text>板凳!</text>
</message>
</response>