AngularJS with SQL

The code from previous chapters can also be used to read data from a database.

Fetching Data from MySQL using PHP

AngularJS Example

Executing SQL to Fetch Data in ASP.NET

AngularJS Example

Server-Side Code

Several types of server-side code are listed below:

• Using PHP and MySQL. Returns JSON.
• Using PHP and MS Access. Returns JSON.
• Using ASP.NET, VB, and MS Access. Returns JSON.
• Using ASP.NET, Razor, and SQL Lite. Returns JSON.

Cross-Domain HTTP Requests

If you need to fetch data from a different server (different domain), you need to use cross-domain HTTP requests.

Cross-domain requests are very common on the web. Many web pages load CSS, images, and JavaScript scripts from different servers.

In modern browsers, for data security, all requests are strictly limited to the same domain. If you need to call data from different sites, cross-domain solutions are required.

The following PHP code allows cross-domain access for the website.

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

For more cross-domain access solutions, refer to: PHP Ajax Cross-Domain Best Solution.

1. PHP and MySQL Code Example

<?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 and MS Access Code Example

3. ASP.NET, VB, and MS Access Code Example

<%@ 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 Example