json 实现客户端和服务器端的数据交互

最新推荐文章于 2022-06-01 12:17:41 发布

loosboo

最新推荐文章于 2022-06-01 12:17:41 发布

阅读量2.9k

点赞数

文章标签： json 服务器 xmlhttprequest database mysql null

本文链接：https://blog.csdn.net/loosboo/article/details/1966676

版权

<?
/**
* json application
* @author:    loosboo
* @email:    loosboo@163.com
* @date:    2007.12.25
* @reference:   http://tech.ddvip.com/2007-08/118771525832600.html
*
*/
/*
--
-- 表的结构 `feeds`
--

CREATE TABLE `feeds` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(50) NOT NULL,
`title` varchar(100) NOT NULL,
`viewed` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- 导出表中的数据 `feeds`
--

INSERT INTO `feeds` VALUES (1, 'www.blah.com/story1.html', 'JSON is sweeping AJAX world', '0');
INSERT INTO `feeds` VALUES (2, 'www.blah.com/story2.html', 'JSON is great', '0');
*/

$hostname = "localhost";
$database = "ajax_db";
$username = "root";
$password = "123";

$sql="select * from feeds";
$rows = array();
mysql_connect(localhost, $username, $password);
mysql_select_db($database) or die("Unable to select database");
$result = mysql_query($sql);
while($row = mysql_fetch_object($result))
{
    $rows[] = $row;
}
$return = json_encode($rows);
echo $return;
mysql_close();
?>

<!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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>json application</title>
<script language="javascript">
var xmlHttp = "";
try
{
    xmlHttp = new ActiveXObject("MSXML2.XMLHTTP.5.0");
}
catch(e)
{
    xmlHttp = new XMLHttpRequest();
}
xmlHttp.open("get","getData.php",true);
xmlHttp.onreadystatechange = function(){
    if(xmlHttp.readystate==4&&xmlHttp.status==200)
    {
        var sResponse = eval(xmlHttp.responseText);
        var sContent = "";
        for(var i=0;i<sResponse.length;i++)
        {
            sContent = sContent + sResponse[i].url+"/n/r";
            sContent = sContent + sResponse[i].title+"/n/r/n/r";
        }
        showData.innerText = sContent;
    }
}
xmlHttp.send(null);
</script>
</head>

<body>
<h5>get data by json!</h5>
<div id="showData"></div>
</body>
</html>