AngularJS SQL
在前面章节中的代码也可以用于读取数据库中的数据。
使用 PHP 从 MySQL 中获取数据
AngularJS 实例
<!DOCTYPE html><html><head><meta charset="utf-8"><script src="http://apps.bdimg.com/libs/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.Name }}</td> <td>{{ x.Country }}</td> </tr></table> </div> <script>var app = angular.module('myApp', []);app.controller('customersCtrl', function($scope, $http) { $http.get("/try/angularjs/data/Customers_MySQL.php") .success(function (response) {$scope.names = response.records;});});</script></body></html>运行结果:
Alfreds Futterkiste Germany Ana Trujillo Emparedados y helados Mexico Antonio Moreno Taquería Mexico Around the Horn UK B's Beverages UK Berglunds snabbköp Sweden Blauer See Delikatessen Germany Blondel père et fils France Bólido Comidas preparadas Spain Bon app' France Bottom-Dollar Marketse Canada Cactus Comidas para llevar Argentina Centro comercial Moctezuma Mexico Chop-suey Chinese Switzerland Comércio Mineiro Brazil
ASP.NET 中执行 SQL 获取数据
AngularJS 实例
<!DOCTYPE html><html><head><meta charset="utf-8"><script src="http://apps.bdimg.com/libs/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.Name }}</td> <td>{{ x.Country }}</td></tr></table></div><script>var app = angular.module('myApp', []);app.controller('customersCtrl', function($scope, $http) { $http.get("http://panyName + c + ","outp = outp + c + "City" + c + ":" + c + @row.City + c + ","outp = outp + c + "Country" + c + ":" + c + @row.Country + c + "}"}outp ="{" + c + "records" + c + ":[" + outp + "]}"@outp以上就是AngularJS SQL资料的整理,后续继续补充,希望能帮助学习的朋友。