jQuery实时刷新显示数据

来源：互联网发布：淘宝店铺怎样上传宝贝编辑：程序博客网时间：2024/04/29 09:51

创建数据表：demo

---- 表的结构 `demo`--CREATE TABLE IF NOT EXISTS `demo` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(20) COLLATE utf8_bin NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=5 ;---- 转存表中的数据 `demo`--INSERT INTO `demo` (`id`, `name`) VALUES(1, '雷军'),(2, '马化腾'),(3, '李彦宏'),(4, '马云');

服务器文件：demo.php

<?php$mysqli = new mysqli("localhost","root","","test");$mysqli->set_charset('utf8');$query = 'SELECT * FROM demo';$result = $mysqli->query($query);$arr = $result->fetch_all(MYSQLI_ASSOC);$info = json_encode($arr);echo $json = '{"success":true,"info":'.$info.'}';

显示数据网页: fresh.html

<html><head>    <meta charset='utf-8'>    <title>hello</title></head><body><script src="http://lib.sinaapp.com/js/jquery/1.9.1/jquery-1.9.1.min.js"></script><script>    function check(){        $.ajax({            type:"GET",            url:"./demo.php",            dataType:"json",            success:function(data){                if(data.success){                    var count = data.info.length;                        for(i=0;i<count;i++){                            var dom = "<tr align='center' id='"+data.info[i].id+"'><td>"+data.info[i].id+"</td><td>"+data.info[i].name+"</td></tr>";                            var tag = '#'+data.info[i].id;                            if(!$(tag).length){                                $("#info").append(dom);                            }                        }                }else{                    alert('error');                }            },            error:function(res){                alert(res.status);            }        });    }    window.setInterval(check, 1000); //每秒执行一次</script><body>    <div style='width:600px;margin:0 auto;'>        <table border='1' width="600px">            <thead>                <tr><th>id</th><th>name</th></tr>            </thead>            <tbody id='info'>                <tr align='center' id='111'><td>111</td><td>测试</td></tr>            </tbody>        </table>    </div></body></html>

0 0