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);
这是向数据库发送查询的PHP页面:
<?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!";
}
?>
目前这段代码只适用于一个数据片段,即第一个查询的结果。但我还需要导入第二个查询的结果等等... Copyright 2014-2026 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号