Latest web development tutorials

AngularJS SQL

The code in the previous section can also be used to read data from the database.

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

try it"

ASP.NET execute SQL access to data

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

try it"

Server-side code

Listed below are listed several types of server-side code:

  1. PHP and MySQL. Return JSON.
  2. PHP and MS Access. Return JSON.
  3. Use ASP.NET, VB, and MS Access. Return JSON.
  4. Use ASP.NET, Razor, and SQL Lite. Return JSON.

Cross-domain HTTP request

If you need to retrieve data from different servers (different domains) you will need to use cross-domain HTTP requests.

Cross-domain requests on the page is very common. Many pages load CSS, pictures, Js scripts from different servers.

In modern browsers, in order to secure the data, all requests are strictly limited under the same domain name, if you need to call data from different sites, you need to be resolved through cross-domain.

The following PHP code to run cross-domain access using a website.

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

More cross-domain access solutions can be found in: PHP Ajax cross-domain problem the best solution.

1. PHP and MySql code examples

<? 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 code examples and 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 and MS Access code examples

<% @ 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, VB Razor and SQL Lite code examples

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