21,886
社区成员
发帖
与我相关
我的任务
分享
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<script src="https://cdn.bootcss.com/angular.js/1.4.6/angular.min.js"></script>
<style>
table, th , td {
border: 1px solid grey;
border-collapse: collapse;
padding: 5px;
}
table tr:nth-child(odd) {
background-color: #f1f1f1;
}
table tr:nth-child(even) {
background-color: #ffffff;
}
</style>
</head>
<body>
<div ng-app="myApp" ng-controller="customersCtrl">
<table>
<tr ng-repeat="x in names">
<td>{{ x.Id }}</td>
<td>{{ x.Title }}</td>
<td>{{ x.Contents }}</td>
<td>{{ x.InputDate }}</td>
</tr>
</table>
</div>
<form name="form1" action="m.php" method="post">
<table>
<tr>
<td></td>
<td>标题:<input type="text" name="title" id="title"></td>
<td>内容:<textarea rows="3" cols="30" name="contents" id="contents">
这里是新闻内容
</textarea></td>
<td>日期:<input type="text" name="inputdate" id="inputdate"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="提交"></td>
<td></td>
<td></td>
</tr>
</table>
</form>
<script>
var app = angular.module('myApp', []);
app.controller('customersCtrl', function($scope, $http) {
$http.get("Select_SQL.php")
.success(function (response) {$scope.names = response.records;});
});
</script>
</body>
</html>
<?php
$servername="localhost";
$username="root";
$password="root";
$dbname="infogather";
//创建连接
$conn=mysqli_connect($servername,$username,$password,$dbname);
//检查是否连接
if(!$conn){
die("连接失败:".mysqli_connect_error());
echo("数据库链接不上");
}
$sql="select * from news1";
$result=mysqli_query($conn, $sql);
$outp = "";
while($sr = mysqli_fetch_assoc($result)) {
if($outp != "") {$outp .= ",";};
$outp .= '{"Id":"'.$sr["Id"].'",';
$outp .= '"Title":"'.$sr["Title"].'",';
$outp .= '"Contents":"'.$sr["Contents"].'",';
$outp .= '"InputDate":"'.$sr["InputDate"].'"}';
//$outp="{'id:':'1','Title':'2','Contents':'3', 'InputDate':'4'}";
}
$outp ='{"records":['.$outp.']}';
mysqli_close($conn);
echo($outp);
?>
$outp ='{"records":['.$outp.']}';
这里只能用双引号呀,否则怎么能连接字符串呢?{"records":[{"Id":"1","Title":"2","Contents":"3", "InputDate":"4"},{"Id":"32","Title":"322","Contents":"323", "InputDate":"324"}]}
php的输出不混用单引号/双引号就可以了