Heim > Fragen und Antworten > Hauptteil
Ich brauche Hilfe mit meiner App. Ich habe diesen Code:
realtime.php
$jogador = Jogador::getSaldoJogadorByEmail($email); $premio = Premio::getValorPremioByTipo($tipo); $participante = Participantes::getATotalParticipantesFromPA1(); $doc = new DOMDocument("1.0"); $action = $doc->createElement('action'); $action = $doc->appendChild($action); $jogador = $doc->createElement('jogador1', $jogador); $jogador = $action->appendChild($jogador); $premio = $doc->createElement('premio1', $premio); $premio = $action->appendChild($premio); $participante = $doc->createElement('participante1', $participante); $participante = $action->appendChild($participante); $output = $doc->saveXML(); header("Content-type: application/xml"); echo $output;
Ich habe diese Funktion, die einfach einen Wert zuordnet, anstatt alles aus der Datenbank zu übergeben:
static function getTotalParticipantesFromPA1(){ $db = new mysqli("localhost","******","****","participantes"); $query = "SELECT * FROM premioacumulado1"; $result = $db->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); if(mysqli_num_rows($result) > 0 ){ while($row = $result->fetch_array(MYSQLI_ASSOC)){ $id = $row['id']; $username = $row['username']; $m = "ID: " . $id . " " . "User: " . $username . "\n"; return $m; } }else{ $db->close(); return NULL; } }
Alle anderen Felder arbeiten in Echtzeit, aber dieses erhält nur einen Wert aus der Datenbank...
Wie bekomme ich alle Werte aus der Datenbank?
Bearbeitet – 22. Mai 2022
static function getTotalParticipantesFromPA1(){ $db = new mysqli("localhost","*****","*****","participantes"); $query = "SELECT * FROM premioacumulado1"; $result = $db->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); if(mysqli_num_rows($result) > 0 ){ while($row = $result->fetch_array(MYSQLI_ASSOC)){ $id = $row['id']; $username = $row['username']; $m = "ID: " . $id . " " . "User: " . $username . "\n"; } return $m; // if i put it here it only returns the last value in the data base . }else{ $db->close(); return NULL; } } static function getTotalParticipantesFromPA1(){ $db = new mysqli("localhost","*****","*****","participantes"); $query = "SELECT * FROM premioacumulado1"; $result = $db->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); if(mysqli_num_rows($result) > 0 ){ while($row = $result->fetch_array(MYSQLI_ASSOC)){ $id = $row['id']; $username = $row['username']; $m = "ID: " . $id . " " . "User: " . $username . "\n"; echo $m;// if i do a echo i get an error in the xml $participante variable(realtime.php) , maybe convert it here so it can take the result , but how ? } }else{ $db->close(); return NULL; } }
Das ist das Skript Js:
function getRealTime(){ //retrieve the DOM objects to place content var domjogador1 = document.getElementById("saldo"); var dompremiovaloracu1 = document.getElementById("valorActualPremioAcu1"); var domparticipantes1 = document.getElementById("areaParticipantesAcu1"); //send the get request to retrieve the data var request = new XMLHttpRequest(); request.open("GET", "realtimegame.php", true); request.onreadystatechange = function(){ if(request.readyState == 4 && request.status == 200){ //parse the xml document to get each data element var xmldoc = request.responseXML; var xmljogador1 = xmldoc.getElementsByTagName("jogador1")[0]; var jogador1 = xmljogador1.childNodes[0].nodeValue; var xmlpremio1 = xmldoc.getElementsByTagName("premio1")[0]; var premio1 = xmlpremio1.childNodes[0].nodeValue; var xmlparticipante1 = xmldoc.getElementsByTagName("participante1")[0]; var participante1 = xmlparticipante1.childNodes[0].nodeValue; domjogador1.innerHTML = jogador1; dompremiovaloracu1.innerHTML = premio1; domparticipantes1.innerHTML = participante1; } }; request.send(); }
P粉9472963252024-03-31 12:19:40
这是有效的函数,现在有一个更漂亮的结果:
static function getBTotalParticipantesFromPA1(){ $db = new mysqli("localhost","root","","participantes"); $query = "SELECT * FROM premioacumulado1"; $result = $db->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); $s = "
"; $data1 = array(); if(mysqli_num_rows($result) > 0 ){ do{ $data1[] = $row['username'] . " " . $row['id'] . " "; }while($row = $result->fetch_array(MYSQLI_ASSOC)); return json_encode($data1); }else{ $db->close(); return NULL; } }
我仍然想打印一些更漂亮的东西供最终用户查看。这样我就得到了每个值中的换行符,但我仍然想从输出中删除“,”...如果有人有可以更好使用的东西,那么请发布它,谢谢。