\u0995\u09cc\u09a3\u09bf\u0995 \u09ac\u09be Angular \u099c\u09be\u09ad\u09be \u09b8\u09cd\u0995\u09cd\u09b0\u09bf\u09aa\u09cd\u099f SQL
\nRiaz-ul-haque Mian (CSE)
\nPHP \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0 \u098f\u09b0 Running MySQL \u09a1\u09be\u099f\u09be \u09ab\u09c7\u099a \u0995\u09b0\u09be\u09a8\u09cb :
\n\u0995\u09cc\u09a3\u09bf\u0995 \u09ac\u09be Angular \u099c\u09be\u09ad\u09be \u09b8\u09cd\u0995\u09cd\u09b0\u09bf\u09aa\u09cd\u099f SQL \u098f\u09b0 \u0989\u09a6\u09be\u09b9\u09b0\u09a3 :
\n<div ng-app=”” ng-controller=”customersController”><\/p>\n
<table>
\n<tr ng-repeat=”x in names”>
\n<td>{{ x.Name }}<\/td>
\n<td>{{ x.Country }}<\/td>
\n<\/tr>
\n<\/table><\/p>\n
<\/div><\/p>\n
<script>
\nfunction customersController($scope,$http) {
\nvar site = “http:\/\/www.justetc.com”;
\nvar page = “\/website\/Customers_MySQL.php”;
\n$http.get(site + page)
\n.success(function(response) {$scope.names = response;});
\n}
\n<\/script><\/p>\n
<\/p>\n
ASP.NET \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0 \u098f\u09b0 Running SQL \u09a1\u09be\u099f\u09be \u09ab\u09c7\u099a \u0995\u09b0\u09be\u09a8\u09cb :<\/p>\n
\u0989\u09a6\u09be\u09b9\u09b0\u09a3 :
\n<div ng-app=”” ng-controller=”customersController”><\/p>\n
<table>
\n<tr ng-repeat=”x in names”>
\n<td>{{ x.Name }}<\/td>
\n<td>{{ x.Country }}<\/td>
\n<\/tr>
\n<\/table><\/p>\n
<\/div><\/p>\n
<script>
\nfunction customersController($scope,$http) {
\nvar site = “http:\/\/www.justetc.com”;
\nvar page = “\/website\/Customers_SQL.aspx”;
\n$http.get(site + page)
\n.success(function(response) {$scope.names = response;});
\n}
\n<\/script>
\n\u098f\u09a4\u0995\u09cd\u09b7\u09a3 \u0986\u09ae\u09b0\u09be \u099c\u09be\u09ad\u09be \u09b8\u09cd\u0995\u09cd\u09b0\u09bf\u09aa\u09cd\u099f \u098f\u09b0 \u0989\u09a7\u09be\u09b0\u09a3 \u09a6\u09c7\u0996\u09c7\u099b\u09bf \u098f\u09ac\u09be\u09b0 \u09a6\u09c7\u0996\u09ac \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0 code \u098f\u09b0 \u0989\u09a7\u09be\u09b0\u09a3
\nSQL \u09a1\u09be\u099f\u09be Fatch \u0995\u09b0\u09be\u09a8\u09cb\u09b0 server code \u098f\u09b0 \u0989\u09a7\u09be\u09b0\u09a3 – \u09a8\u09bf\u099a\u09c7 \u099a\u09be\u09b0\u099f\u09bf \u0989\u09a7\u09be\u09b0\u09a3 \u09a6\u09c7\u09df\u09be \u09b9\u09b2\u09cb
\n1. PHP \u098f\u09ac\u0982 MYSQL \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 (\u0989\u09a7\u09be\u09b0\u09a3 \u099f\u09bf \u09b2\u0995\u09cd\u09b7 \u0995\u09b0\u09c1\u09a8)
\nphp
\nheader(“Access-Control-Allow-Origin: *”);
\nheader(“Content-Type: application\/json; charset=UTF-8”);<\/p>\n
$conn = new mysqli(“myServer”, “myUser”, “myPassword”, “Northwind”);<\/p>\n
$result = $conn->query(“SELECT CompanyName, City, Country FROM Customers”);<\/p>\n
$outp = “[“;
\nwhile($rs = $result->fetch_array(MYSQLI_ASSOC)) {
\nif ($outp != “[“) {$outp .= “,”;}
\n$outp .= ‘{“Name”:”‘ . $rs[“CompanyName”] . ‘”,’;
\n$outp .= ‘”City”:”‘ . $rs[“City”] . ‘”,’;
\n$outp .= ‘”Country”:”‘. $rs[“Country”] . ‘”}’;
\n}
\n$outp .=”]”;<\/p>\n
$conn->close();<\/p>\n
echo($outp);
\n?>
\n2. PHP \u098f\u09ac\u0982 \u09ae\u09be\u0987\u0995\u09cd\u09b0\u09cb\u09b8\u09ab\u099f \u098f\u0995\u09cd\u09b8\u09c7\u09b8 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 (\u0989\u09a7\u09be\u09b0\u09a3 \u099f\u09bf \u09b2\u0995\u09cd\u09b7 \u0995\u09b0\u09c1\u09a8)
\n<?php
\nheader(“Access-Control-Allow-Origin: *”);
\nheader(“Content-Type: application\/json; charset=ISO-8859-1”);<\/p>\n
$conn = new COM(“ADODB.Connection”);
\n$conn->open(“PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb”);<\/p>\n
$rs = $conn->execute(“SELECT CompanyName, City, Country FROM Customers”);<\/p>\n
$outp = “[“;
\nwhile (!$rs->EOF) {
\nif ($outp != “[“) {$outp .= “,”;}
\n$outp .= ‘{“Name”:”‘ . $rs[“CompanyName”] . ‘”,’;
\n$outp .= ‘”City”:”‘ . $rs[“City”] . ‘”,’;
\n$outp .= ‘”Country”:”‘. $rs[“Country”] . ‘”}’;
\n$rs->MoveNext();
\n}
\n$outp .= “]”;<\/p>\n
$conn->close();<\/p>\n
echo ($outp);
\n?>
\n3. ASP.NET , \u09ad\u09bf\u099c\u09cd\u09af\u09c1\u09df\u09be\u09b2 \u09ac\u09c7\u09b8\u09bf\u0995 \u098f\u09ac\u0982 \u09ae\u09be\u0987\u0995\u09cd\u09b0\u09cb\u09b8\u09ab\u099f \u098f\u0995\u09cd\u09b8\u09c7\u09b8 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 (\u0989\u09a7\u09be\u09b0\u09a3 \u099f\u09bf \u09b2\u0995\u09cd\u09b7 \u0995\u09b0\u09c1\u09a8)
\n<%@ Import Namespace=”System.IO”%>
\n<%@ Import Namespace=”System.Data”%>
\n<%@ Import Namespace=”System.Data.OleDb”%>
\n<%
\nResponse.AppendHeader(“Access-Control-Allow-Origin”, “*”)
\nResponse.AppendHeader(“Content-type”, “application\/json”)
\nDim conn As OleDbConnection
\nDim objAdapter As OleDbDataAdapter
\nDim objTable As DataTable
\nDim objRow As DataRow
\nDim objDataSet As New DataSet()
\nDim outp
\nDim c
\nconn = New OledbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;data source=Northwind.mdb”)
\nobjAdapter = New OledbDataAdapter(“SELECT CompanyName, City, Country FROM Customers”, conn)
\nobjAdapter.Fill(objDataSet, “myTable”)
\nobjTable=objDataSet.Tables(“myTable”)<\/p>\n
outp = “[”
\nc = chr(34)
\nfor each x in objTable.Rows
\nif outp <> “[” then outp = outp & “,”
\noutp = outp & “{” & c & “Name” & c & “:” & c & x(“CompanyName”) & c & “,”
\noutp = outp & c & “City” & c & “:” & c & x(“City”) & c & “,”
\noutp = outp & c & “Country” & c & “:” & c & x(“Country”) & c & “}”
\nnext<\/p>\n
outp = outp & “]”
\nresponse.write(outp)
\nconn.close
\n%><\/p>\n
4. ASP.NET , \u09ad\u09bf\u099c\u09cd\u09af\u09c1\u09df\u09be\u09b2 \u09ac\u09c7\u09b8\u09bf\u0995 Razor \u098f\u09ac\u0982 SQL Lite\u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 (\u0989\u09a7\u09be\u09b0\u09a3 \u099f\u09bf \u09b2\u0995\u09cd\u09b7 \u0995\u09b0\u09c1\u09a8)
\n@{
\nResponse.AppendHeader(“Access-Control-Allow-Origin”, “*”)
\nResponse.AppendHeader(“Content-type”, “application\/json”)
\nvar db = Database.Open(“Northwind”);
\nvar query = db.Query(“SELECT CompanyName, City, Country FROM Customers”);
\nvar outp =”[”
\n}
\n@foreach(var row in query)
\n{
\nif outp <> “[” then outp = outp + “,”
\noutp = outp + “{” + c + “Name” + c + “:” + c + @row.CompanyName + c + “,”
\noutp = outp + c + “City” + c + “:” + c + @row.City + c + “,”
\noutp = outp + c + “Country” + c + “:” + c + @row.Country + c + “}”
\n}
\noutp = outp + “]”
\n@outp<\/p>\n","protected":false},"excerpt":{"rendered":"
\u0995\u09cc\u09a3\u09bf\u0995 \u09ac\u09be Angular \u099c\u09be\u09ad\u09be \u09b8\u09cd\u0995\u09cd\u09b0\u09bf\u09aa\u09cd\u099f SQL Riaz-ul-haque Mian (CSE) PHP \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0 \u098f\u09b0 Running MySQL \u09a1\u09be\u099f\u09be \u09ab\u09c7\u099a \u0995\u09b0\u09be\u09a8\u09cb : \u0995\u09cc\u09a3\u09bf\u0995 \u09ac\u09be Angular \u099c\u09be\u09ad\u09be \u09b8\u09cd\u0995\u09cd\u09b0\u09bf\u09aa\u09cd\u099f SQL \u098f\u09b0 \u0989\u09a6\u09be\u09b9\u09b0\u09a3 : <div ng-app=”” ng-controller=”customersController”> <table> <tr ng-repeat=”x in names”> <td>{{ x.Name }}<\/td> <td>{{ x.Country }}<\/td> <\/tr> <\/table> <\/div> <script> function customersController($scope,$http) { var site = “http:\/\/www.justetc.com”; var page = … <\/p>\n