在前面章节中的代码也可以用于读取数据库中的数据。使用 PHP 从 MySQL 中获取数据AngularJS 实例div ng-appmyApp ng-controllercustomersCtrltabletr ng-repeatx in namestd{{ x.Name }}/tdtd{{ x.Country }}/td/tr/table/divscriptvar app angular.module(myApp, []);app.controller(customersCtrl, function($scope, $http) {$http.get(https://www.runoob.com/try/angularjs/data/Customers_MySQL.php).success(function (response) {$scope.names response.records;});});/script尝试一下 »ASP.NET 中执行 SQL 获取数据AngularJS 实例div ng-appmyApp ng-controllercustomersCtrltabletr ng-repeatx in namestd{{ x.Name }}/tdtd{{ x.Country }}/td/tr/table/divscriptvar app angular.module(myApp, []);app.controller(customersCtrl, function($scope, $http) {$http.get(https://www.runoob.com/try/angularjs/data/Customers_SQL.aspx).success(function (response) {$scope.names response.records;});});/script服务端代码以下列出了几种服务端代码类型使用 PHP 和 MySQL。返回 JSON。使用 PHP 和 MS Access。返回 JSON。使用 ASP.NET, VB, 及 MS Access。 返回 JSON。使用 ASP.NET, Razor, 及 SQL Lite。 返回 JSON。跨域 HTTP 请求如果你需要从不同的服务器不同域名上获取数据就需要使用跨域 HTTP 请求。跨域请求在网页上非常常见。很多网页从不同服务器上载入 CSS, 图片Js脚本等。在现代浏览器中为了数据的安全所有请求被严格限制在同一域名下如果需要调用不同站点的数据需要通过跨域来解决。以下的 PHP 代码运行使用的网站进行跨域访问。header(Access-Control-Allow-Origin: *);更多跨域访问解决方案可参阅PHP Ajax 跨域问题最佳解决方案。1. PHP 和 MySql 代码实例?phpheader(Access-Control-Allow-Origin: *);header(Content-Type: application/json; charsetUTF-8);$conn new mysqli(myServer, myUser, myPassword, Northwind);$result $conn-query(SELECT CompanyName, City, Country FROM Customers);$outp ;while($rs $result-fetch_array(MYSQLI_ASSOC)) {if ($outp ! ) {$outp . ,;}$outp . {Name: . $rs[CompanyName] . ,;$outp . City: . $rs[City] . ,;$outp . Country:. $rs[Country] . };}$outp {records:[.$outp.]};$conn-close();echo($outp);?2. PHP 和 MS Access 代码实例?phpheader(Access-Control-Allow-Origin: *);header(Content-Type: application/json; charsetISO-8859-1);$conn new COM(ADODB.Connection);$conn-open(PROVIDERMicrosoft.Jet.OLEDB.4.0;Data SourceNorthwind.mdb);$rs $conn-execute(SELECT CompanyName, City, Country FROM Customers);$outp ;while (!$rs-EOF) {if ($outp ! ) {$outp . ,;}$outp . {Name: . $rs[CompanyName] . ,;$outp . City: . $rs[City] . ,;$outp . Country:. $rs[Country] . };$rs-MoveNext();}$outp {records:[.$outp.]};$conn-close();echo ($outp);?3. ASP.NET, VB 和 MS Access 代码实例% Import NamespaceSystem.IO%% Import NamespaceSystem.Data%% Import NamespaceSystem.Data.OleDb%%Response.AppendHeader(Access-Control-Allow-Origin, *)Response.AppendHeader(Content-type, application/json)Dim conn As OleDbConnectionDim objAdapter As OleDbDataAdapterDim objTable As DataTableDim objRow As DataRowDim objDataSet As New DataSet()Dim outpDim cconn New OledbConnection(ProviderMicrosoft.Jet.OLEDB.4.0;data sourceNorthwind.mdb)objAdapter New OledbDataAdapter(SELECT CompanyName, City, Country FROM Customers, conn)objAdapter.Fill(objDataSet, myTable)objTableobjDataSet.Tables(myTable)outp c chr(34)for each x in objTable.Rowsif outp then outp outp ,outp outp { c Name c : c x(CompanyName) c ,outp outp c City c : c x(City) c ,outp outp c Country c : c x(Country) c }nextoutp { c records c :[ outp ]}response.write(outp)conn.close%4. ASP.NET, VB Razor 和 SQL Lite 代码实例{Response.AppendHeader(Access-Control-Allow-Origin, *)Response.AppendHeader(Content-type, application/json)var db Database.Open(Northwind);var query db.Query(SELECT CompanyName, City, Country FROM Customers);var outp var c chr(34)}foreach(var row in query){if outp then outp outp ,outp outp { c Name c : c row.CompanyName 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
HoRain云--AngularJS SQL
在前面章节中的代码也可以用于读取数据库中的数据。使用 PHP 从 MySQL 中获取数据AngularJS 实例div ng-appmyApp ng-controllercustomersCtrltabletr ng-repeatx in namestd{{ x.Name }}/tdtd{{ x.Country }}/td/tr/table/divscriptvar app angular.module(myApp, []);app.controller(customersCtrl, function($scope, $http) {$http.get(https://www.runoob.com/try/angularjs/data/Customers_MySQL.php).success(function (response) {$scope.names response.records;});});/script尝试一下 »ASP.NET 中执行 SQL 获取数据AngularJS 实例div ng-appmyApp ng-controllercustomersCtrltabletr ng-repeatx in namestd{{ x.Name }}/tdtd{{ x.Country }}/td/tr/table/divscriptvar app angular.module(myApp, []);app.controller(customersCtrl, function($scope, $http) {$http.get(https://www.runoob.com/try/angularjs/data/Customers_SQL.aspx).success(function (response) {$scope.names response.records;});});/script服务端代码以下列出了几种服务端代码类型使用 PHP 和 MySQL。返回 JSON。使用 PHP 和 MS Access。返回 JSON。使用 ASP.NET, VB, 及 MS Access。 返回 JSON。使用 ASP.NET, Razor, 及 SQL Lite。 返回 JSON。跨域 HTTP 请求如果你需要从不同的服务器不同域名上获取数据就需要使用跨域 HTTP 请求。跨域请求在网页上非常常见。很多网页从不同服务器上载入 CSS, 图片Js脚本等。在现代浏览器中为了数据的安全所有请求被严格限制在同一域名下如果需要调用不同站点的数据需要通过跨域来解决。以下的 PHP 代码运行使用的网站进行跨域访问。header(Access-Control-Allow-Origin: *);更多跨域访问解决方案可参阅PHP Ajax 跨域问题最佳解决方案。1. PHP 和 MySql 代码实例?phpheader(Access-Control-Allow-Origin: *);header(Content-Type: application/json; charsetUTF-8);$conn new mysqli(myServer, myUser, myPassword, Northwind);$result $conn-query(SELECT CompanyName, City, Country FROM Customers);$outp ;while($rs $result-fetch_array(MYSQLI_ASSOC)) {if ($outp ! ) {$outp . ,;}$outp . {Name: . $rs[CompanyName] . ,;$outp . City: . $rs[City] . ,;$outp . Country:. $rs[Country] . };}$outp {records:[.$outp.]};$conn-close();echo($outp);?2. PHP 和 MS Access 代码实例?phpheader(Access-Control-Allow-Origin: *);header(Content-Type: application/json; charsetISO-8859-1);$conn new COM(ADODB.Connection);$conn-open(PROVIDERMicrosoft.Jet.OLEDB.4.0;Data SourceNorthwind.mdb);$rs $conn-execute(SELECT CompanyName, City, Country FROM Customers);$outp ;while (!$rs-EOF) {if ($outp ! ) {$outp . ,;}$outp . {Name: . $rs[CompanyName] . ,;$outp . City: . $rs[City] . ,;$outp . Country:. $rs[Country] . };$rs-MoveNext();}$outp {records:[.$outp.]};$conn-close();echo ($outp);?3. ASP.NET, VB 和 MS Access 代码实例% Import NamespaceSystem.IO%% Import NamespaceSystem.Data%% Import NamespaceSystem.Data.OleDb%%Response.AppendHeader(Access-Control-Allow-Origin, *)Response.AppendHeader(Content-type, application/json)Dim conn As OleDbConnectionDim objAdapter As OleDbDataAdapterDim objTable As DataTableDim objRow As DataRowDim objDataSet As New DataSet()Dim outpDim cconn New OledbConnection(ProviderMicrosoft.Jet.OLEDB.4.0;data sourceNorthwind.mdb)objAdapter New OledbDataAdapter(SELECT CompanyName, City, Country FROM Customers, conn)objAdapter.Fill(objDataSet, myTable)objTableobjDataSet.Tables(myTable)outp c chr(34)for each x in objTable.Rowsif outp then outp outp ,outp outp { c Name c : c x(CompanyName) c ,outp outp c City c : c x(City) c ,outp outp c Country c : c x(Country) c }nextoutp { c records c :[ outp ]}response.write(outp)conn.close%4. ASP.NET, VB Razor 和 SQL Lite 代码实例{Response.AppendHeader(Access-Control-Allow-Origin, *)Response.AppendHeader(Content-type, application/json)var db Database.Open(Northwind);var query db.Query(SELECT CompanyName, City, Country FROM Customers);var outp var c chr(34)}foreach(var row in query){if outp then outp outp ,outp outp { c Name c : c row.CompanyName 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
