AngularJS SQL

AngularJS kifina kuma da dukiya da ke kula da zirga zirga da yau, kuma yana iya kula da dukiyar JSON ne kawai.

Daga daga ne ta da samu datti daga saman PHP ceke kai a hanci MySQL

AngularJS Examples

<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>

亲自试一试

Daga daga ne ta da samu datti daga saman SQL ceke kai a hanci

AngularJS Examples

<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 row in query){
if (outp != "") {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