1.在数据库bookstore创建表user
create table user(
id int(8) not null auto_increment,
username varchar(50) not null,
userpwd varchar(50) not null,
isadmin int(8) ,
primary key(id)
);
2.显示e-loginlist.html
<script src="https://cdn.staticfile.org/vue/2.4.2/vue.min.js"></script>
<script src="https://cdn.staticfile.org/vue-resource/1.5.1/vue-resource.min.js"></script>
<div id="form">
<button v-on:click="getdata">提取</button>
<li v-for="site in sites">
{{site}}
</li>
</div>
<script>
var vm=new Vue({
el:'#form',
data: {
sites:[],
count:0
},
methods:{
getdata:function(){
this.$http.post('e-loginlist.php',{proc:''},{emulateJSON:true}).then(function(res){
this.count=res.body.length;
this.sites=res.body;
},function(res){
console.log('失败');
})
}
}
})
</script>
3.取数据e-loginlist.php
<?php
header('Content-Type:text/json;charset=utf-8');
//$proc =$_POST['proc'];
$mysqli = new mysqli("localhost", "root", "123456", "bookstore"); //连接MySQL数据库
if (mysqli_connect_errno()) { //检查连接错误
printf("连接失败: %s<br>", mysqli_connect_error());
exit();
}
$result = $mysqli->query("SELECT * FROM user"); //执行查询语句获取结果集
echo json_encode($result->fetch_all(1));
$result->close(); //关闭结果集释放内存
$mysqli->close(); //关闭与数据库服务器的连接
?>