Latest web development tutorials

SQL AngularJS

Kode di bagian sebelumnya juga dapat digunakan untuk membaca data dari database.

Gunakan PHP untuk mendapatkan data dari MySQL,

AngularJS contoh

< 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://www.w3big.com/try/angularjs/data/Customers_MySQL.php")
    .success(function (response) {$scope.names = response.records;});
});
< /script >

Coba »

ASP.NET mengeksekusi akses SQL data

AngularJS contoh

< 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://www.w3big.com/try/angularjs/data/Customers_SQL.aspx")
    .success(function (response) {$scope.names = response.records;});
});
< /script >

Coba »

kode sisi server

Di bawah tercantum beberapa jenis kode sisi server:

  1. PHP dan MySQL. Kembali JSON.
  2. PHP dan MS Access. Kembali JSON.
  3. Gunakan ASP.NET, VB, dan MS Access. Kembali JSON.
  4. Gunakan ASP.NET, Razor, dan SQL Lite. Kembali JSON.

permintaan HTTP lintas domain

Jika Anda perlu untuk mengambil data dari server yang berbeda (domain yang berbeda) Anda akan perlu menggunakan permintaan HTTP lintas domain.

permintaan lintas-domain pada halaman sangat umum. Banyak halaman memuat CSS, gambar, skrip Js dari server yang berbeda.

Di browser modern, untuk mengamankan data, semua permintaan yang sangat terbatas dengan nama domain yang sama, jika Anda perlu untuk memanggil data dari situs yang berbeda, Anda perlu diselesaikan melalui lintas-domain.

Berikut kode PHP untuk menjalankan akses lintas domain menggunakan website.

header ( "Access-Control-Biarkan-Asal: *");

Lebih solusi akses lintas-domain dapat ditemukan di: PHP Ajax masalah lintas-domain solusi terbaik.

1. PHP dan MySql contoh kode

<? Php
header ( "Access-Control-Biarkan-Asal: *");
header ( "Content-Type: application / json; charset = UTF-8");

$ Conn = baru mysqli ( "myServer", "myuser", "MyPassword", "Northwind");

$ Hasil = $ conn-> query ( "SELECT CompanyName, Kota, Negara FROM Pelanggan");

$ Outp = "";
sementara ($ rs = $ result-> fetch_array (MYSQLI_ASSOC)) {
if ($ outp = "!") {, "$ outp =.";}
. $ Outp = '{ "Nama": "' $ rs. [" CompanyName "] ',;."'
. $ Outp = ' "Kota": "' $ rs. [" Kota "] ',;."'
. $ Outp = ' "Negara": "' $ rs. [" Negara "] '};."'
}
$ Outp = '{ "catatan": [ "$ outp..']} ';
$ Conn-> close ();

echo ($ outp);
?>

2. contoh kode PHP dan 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 dan MS Access contoh kode

<% @ Import Namespace = "System.IO"%>
<% @ Import Namespace = "System.Data"%>
<% @ Import Namespace = "System.Data.OleDb"%>
<%
Response.AppendHeader ( "Access-Control-Biarkan-Asal", "*")
Response.AppendHeader ( "Content-type", "aplikasi / json")
Dim conn As OleDbConnection
Dim objAdapter Sebagai OleDbDataAdapter
Dim objTable Sebagai DataTable
Dim objRow Sebagai DataRow
Dim objDataSet Sebagai New DataSet ()
Dim outp
Dim c
conn = New OleDbConnection ( "Provider = Microsoft.Jet.OLEDB.4.0; sumber data = Northwind.mdb")
objAdapter = New OleDbDataAdapter ( "SELECT CompanyName, Kota, Negara FROM Pelanggan", conn)
objAdapter.Fill (objDataSet, "myTable")
objTable = objDataSet.Tables ( "myTable")

outp = ""
c = chr (34)
untuk setiap x di objTable.Rows
jika outp <> "" kemudian outp = outp & ","
outp = outp & "{" & c & "Nama" & c & ":" & c & x ( "CompanyName") & c & ","
outp = outp & c & "Kota" & c & ":" & c & x ( "Kota") & c & ","
outp = outp & c & "Negara" & c & ":" & c & x ( "Negara") & c & "}"
berikutnya

outp = "{" & c & "catatan" & c & ": [" & outp & "]}"
response.write (outp)
conn.close
%>

4. ASP.NET, VB Razor dan SQL Lite contoh kode

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