<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                # AngularJS SQL 在前面章節中的代碼也可以用于讀取數據庫中的數據。 ## 使用 PHP 從 MySQL 中獲取數據 ## AngularJS 實例 ``` <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.w3cschool.cc"; ??? var page = "/try/angularjs/data/Customers_MySQL.php"; ??? $http.get(site + page) ??? .success(function(response) {$scope.names = response;}); } </script> ``` ## ASP.NET 中執行 SQL 獲取數據 ## AngularJS 實例 ``` <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.w3cschool.cc"; ??? var page = "/try/angularjs/data/Customers_SQL.aspx"; ??? $http.get(site + page) ??? .success(function(response) {$scope.names = response;}); } </script> ``` ## PHP 讀取 MySQL 數據代碼 ``` <?php header("Access-Control-Allow-Origin: *"); header("Content-Type: text/html; 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 .="]"; $conn->close(); echo($outp); ?> ``` ## PHP 讀取 MS Access 代碼 ``` <?php header("Access-Control-Allow-Origin: *"); header("Content-Type: text/html; 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 .= "]"; $conn->close(); echo ($outp); ?> ``` ## 服務端 ASP.NET, VB 和 MS Access 代碼 ``` <%@ Import Namespace="System.IO"%> <%@ Import Namespace="System.Data"%> <%@ Import Namespace="System.Data.OleDb"%> <% Response.AppendHeader("Access-Control-Allow-Origin", "*") 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 = outp & "]" response.write(outp) conn.close %> ``` ## 服務端 ASP.NET, VB Razor 和 SQL Lite 代碼 ``` @{ Response.AppendHeader("Access-Control-Allow-Origin", "*") var db = Database.Open("Northwind"); var query = db.Query("SELECT CompanyName, City, Country FROM Customers"); var outp ="[" } @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 = outp + "]" @outp ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看