اگلارکج ایس ال کیو

ਐਂਜੁਲਰਜ਼ ਐਸਕਿਊਐਲ ਐਂਜੁਲਰਜ਼ ਮਿਡਲਵੇਅਰ ਵਿੱਚ ਕਾਫੀ ਲਾਭਦਾਇਕ ਹੈ। ਸਿਰਫ ਯਕੀਨੀ ਕਰੋ ਕਿ ਡਾਟਾ JSON ਫਾਰਮੈਟ ਵਿੱਚ ਹੈ

ਐਂਜੁਲਰਜ਼ ਐਸਕਿਊਐਲ ਚਲਾਉਣ ਵਾਲੇ ਪਹਿਲਾਂ ਤੋਂ ਡਾਟਾ ਲੈਣਾ

اگلارکج مثال

<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("customers_mysql.php")
  .then(function (response) {$scope.names = response.data.records;});
});
</script>

亲自试一试

ਐਸਕਿਊਐਲ ਚਲਾਉਣ ਵਾਲੇ ਏਸਪੀਐਨਈਟ ਸਰਵਰ ਤੋਂ ਡਾਟਾ ਲੈਣਾ

اگلارکج مثال

<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("customers_sql.aspx")
  .then(function (response) {$scope.names = response.data.records;});
});
</script>

亲自试一试

服务器代码示例

以下部分列出了用于获取 SQL 数据的服务器代码。

• 使用 PHP 和 MySQL。返回 JSON。
• 使用 PHP 和 MS Access。返回 JSON。
• 使用 ASP.NET、VB 和 MS Access。返回 JSON。
• 使用 ASP.NET、Razor 和 SQL Lite。返回 JSON。

跨站点 HTTP 请求

从不同服务器（除请求页面外的其他服务器）请求数据称为跨站点 HTTP 请求。

跨站点请求在网络上很常见。许多页面从不同的服务器加载 CSS，图像和脚本。

出于安全原因，现代浏览器中的脚本发出的跨站点 HTTP 请求被限制为同一站点。

在我们的 PHP 示例中，已添加以下行以允许跨站点访问。

header("Access-Control-Allow-Origin: *");

1. 服务器代码 PHP 和 MySQL

<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-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

<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=ISO-8859-1");
$conn = new COM("ADODB.Connection");
$conn->open("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.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 Namespace="System.IO"%>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<%
Response.AppendHeader("Access-Control-Allow-Origin", "*")
Response.AppendHeader("Content-type", "application/json")
Dim conn As OleDbConnection
Dim objAdapter As OleDbDataAdapter
Dim objTable As DataTable
Dim objRow As DataRow
Dim objDataSet As New DataSet()
Dim outp
Dim c
conn = New OledbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=Northwind.mdb")
objAdapter = New OledbDataAdapter("SELECT CompanyName, City, Country FROM Customers", conn)
objAdapter.Fill(objDataSet, "myTable")
objTable=objDataSet.Tables("myTable")
outp = ""
c = chr(34)
for each x in objTable.Rows
if 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 & "}"
next
outp ="{" & c & "records" & c & ":[" & outp & "]}"
response.write(outp)
conn.close
%>

4. 服务器代码 ASP.NET、Razor C# 和 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 آرون in کوئری){
اگر آؤٹپ != "") {آؤٹپ = آؤٹپ + ","}
آؤٹپ = آؤٹپ + "{" + سی + "نام"    + سی + ":" + سی + آرون.کمپنی نیم + سی + ","
آؤٹپ = آؤٹپ +       سی + "شہر"    + سی + ":" + سی + آرون.شہر        + سی + ","
آؤٹپ = آؤٹپ +       سی + "کونٹری" + سی + ":" + سی + آرون.کونٹری     + سی + "}"
}
آؤٹپ ="{" + سی + "رکورڈز" + سی + ":[" + آؤٹپ + "]}"
@آؤٹپ