国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

使用JavaScript從PHP頁面中提取更多信息
P粉445714413
P粉445714413 2023-08-13 12:27:33
0
1
701
為了在不必不斷重新加載頁面的情況下自動更新頁面的某個部分,我已經在平臺上實現(xiàn)了這段代碼。如果只是想更新一個數(shù)據(jù)片段,一切都正常工作,實際上php頁面包含了多個查詢,用于填充不同的部分。我如何報告所有查詢的數(shù)據(jù)結果? 這是index.php中的JS代碼: <pre class="brush:js;toolbar:false;">function nLettere() { var xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { const myObj = JSON.parse(this.responseText); document.getElementById("nLettere").innerHTML = this.responseText; } }; xhttp.open("GET", "script/caricaNumeri.php", true); xhttp.send(); } setInterval(function(){ nLettere(); }, 1); </pre> 這是向數(shù)據(jù)庫發(fā)送查詢的PHP頁面: <pre class="brush:php;toolbar:false;"><?php include '../config.php'; // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $query = "SELECT COUNT(id) AS totale FROM indirizzi"; $risultato = $conn->query($query); if ($risultato->num_rows > 0) { // output data of each row while($row = $risultato->fetch_assoc()) { $numero = $row["totale"]; } } else { $numero = "Ancora nessuna per ora!"; } $query = "SELECT COUNT(stato) AS daConsegnare FROM indirizzi WHERE stato = ''"; $risultato = $conn->query($query); if ($risultato->num_rows > 0) { // output data of each row while($row = $risultato->fetch_assoc()) { $daConsegnare = $row["daConsegnare"]; } } else { $daConsegnare = "Ancora nessuna per ora!"; } ?> </pre> 目前這段代碼只適用于一個數(shù)據(jù)片段,即第一個查詢的結果。但我還需要導入第二個查詢的結果等等...
P粉445714413
P粉445714413

全部回復(1)
P粉642919823

要使用不同查詢的數(shù)據(jù)更新頁面的多個部分,您可以相應地修改JavaScript代碼和PHP代碼。以下是您可以執(zhí)行的操作:

修改您的PHP腳本(caricaNumeri.php),以返回包含兩個查詢結果的JSON對象:

php

<?php

include '../config.php';

// 檢查連接
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$response = array();

$query = "SELECT COUNT(id) AS totale FROM indirizzi";
$risultato = $conn->query($query);
if ($risultato->num_rows > 0) {
    // 輸出每一行的數(shù)據(jù)
    while($row = $risultato->fetch_assoc()) {
        $response["totale"] = $row["totale"];
    }
} else {
    $response["totale"] = "Ancora nessuna per ora!";
}

$query = "SELECT COUNT(stato) AS daConsegnare FROM indirizzi WHERE stato = ''";
$risultato = $conn->query($query);
if ($risultato->num_rows > 0) {
    // 輸出每一行的數(shù)據(jù)
    while($row = $risultato->fetch_assoc()) {
        $response["daConsegnare"] = $row["daConsegnare"];
    }
} else {
    $response["daConsegnare"] = "Ancora nessuna per ora!";
}

echo json_encode($response);

?>

修改您的JavaScript代碼以處理PHP腳本返回的多個數(shù)據(jù)片段:

javascript

function caricaNumeri() {
    var xhttp = new XMLHttpRequest();
    xhttp.onreadystatechange = function() {
        if (this.readyState == 4 && this.status == 200) {
            const data = JSON.parse(this.responseText);
            document.getElementById("nLettere").innerHTML = data.totale;
            document.getElementById("daConsegnare").innerHTML = data.daConsegnare;
        }
    };
    xhttp.open("GET", "script/caricaNumeri.php", true);
    xhttp.send();
}

setInterval(function(){
    caricaNumeri();
}, 1000); // 每秒更新一次(根據(jù)需要進行調整)

更新您的HTML,包括第二個數(shù)據(jù)的占位符:

html

<div id="nLettere"></div>
<div id="daConsegnare"></div>

現(xiàn)在,當您運行caricaNumeri函數(shù)時,它將從服務器獲取兩個數(shù)據(jù)片段并更新頁面的相應部分。請根據(jù)您希望數(shù)據(jù)更新的頻率調整間隔時間(setInterval)。

最新下載
更多>
網站特效
網站源碼
網站素材
前端模板