js ID aus Tabelle ermitteln

[black79]

Du solltest erstmal versuchen das du Daten nur holst wenn es was neues gibt . zb ein Script was die ganze Zeit auf der db schaut .
So ungefähr

Code:

function testen(){
    $.ajax({
        type: "GET",
        url: "check_auf_neue_daten.php",
        cache: false,
        success: function(response){
            if(response==true){
                aktualiesiere();
            }
        }
    });
}
setInterval(function() {
testen();
}, 5000);

Dann meinen Code aktualisieren

Code:

$(document).ready(function(){
function aktualiesiere(){
    var maxid = 0;
    var last = null;
    var sammeln='';
    var imglink,imglink1,imglink3;
    $.get("./alarmdb.xml", function(data) {
      for ( let elem of data.getElementsByTagName('data') ){
         id = elem.getElementsByTagName('id')[0].firstChild.nodeValue;
         adress = elem.getElementsByTagName('kreis')[0].firstChild.nodeValue;
         group = elem.getElementsByTagName('gruppe')[0].firstChild.nodeValue;
         komune = elem.getElementsByTagName('kommune')[0].firstChild.nodeValue;
         hinweiss = elem.getElementsByTagName('hinweis')[0].firstChild.nodeValue;
         wache = elem.getElementsByTagName('wache')[0].firstChild.nodeValue;
         mesage= elem.getElementsByTagName('message')[0].firstChild.nodeValue;
         beteichnung= elem.getElementsByTagName('bezeichnung')[0].firstChild.nodeValue;
         datum=elem.getElementsByTagName('datum')[0].firstChild.nodeValue;
         adress = elem.getElementsByTagName('adresse')[0].firstChild.nodeValue;
         text = elem.getElementsByTagName('flags')[0].firstChild.nodeValue;
         backf= elem.getElementsByTagName('background_n')[0].firstChild.nodeValue;


            if (group=='UNWETTER') {
                  col='dark';
            }else{
                 col='hell';
            }

                    if (text=='0') { imglink = 'web_images/server_5.png'}
                    if (text=='1048576') { imglink = 'web_images/Alarm_9.png'}
                    if (text=='537919488') { imglink = 'web_images/Alarm_9.png'}
                    if (text=='536870912') { imglink = 'web_images/server_5.png'}

                    if (adress[7]=='a') { imglink1 = 'web_images/Alarm_14.png'}
                    if (adress[7]=='b') { imglink1 = 'web_images/limit.png'}
                    if (adress[7]=='c') { imglink1 = 'web_images/Alarm_12.png'}
                    if (adress[7]=='d') { imglink1 = 'web_images/Alarm_7.png'}

                    if (group=='RETTUNG') { imglink3 = 'web_images/rettung_3.png'}
                    if (group=='NAVI') { imglink3 = 'web_images/Alarm_16.png'}
                    if (group=='SIRENE') { imglink3 = 'web_images/Alarm_11.png'}
                    if (group=='SERVICE') { imglink3 = 'web_images/Alarm_6.png'}
                    if (group=='EINZELRUF') { imglink3 = 'web_images/Alarm_8.png'}
                    if (group=='FAHRZEUG') { imglink3 = 'web_images/feuerwehr_1.png'}
                    if (group=='TORSTEUERUNG') { imglink3 = 'web_images/einstellungen.png'}
                    if (group=='DATAFILE') { imglink3 = 'web_images/file.png'}
                    if (group=='WETTER') { imglink3 = 'web_images/regen.png'}
                    if (group=='SWISSPHONE') { imglink3 = 'web_images/herunterladen.png'}
                    if (group=='MESSAGE') { imglink3 = 'web_images/email.png'}
                    if (group=='SYSTEM') { imglink3 = 'web_images/settings.png'}
                    if (group=='KRANKENTRANSPORT') { imglink3 = 'web_images/krankentransport_1.png'}
                    if (group=='FEUERWEHR') { imglink3 = 'web_images/feuerloescher.png'}
                    if (group=='PROBE') { imglink3 = 'web_images/Alarm_12.png'}
                    if (group=='MULTIMASTER') { imglink3 = 'web_images/warnen.png'}
                    if (group=='HVO') { imglink3 = 'web_images/weste.png'}
                    if (group=='ARZT') { imglink3 = 'web_images/arzt.png'}
                    if (group=='DEBUG') { imglink3 = 'web_images/debug.png'}
                   
               
                   
        sammeln+=`<tr>    
            <td class="${col}"> ${adress}</td>
            <td class="${col}"> <img src="${imglink}"></td>
            <td class="${col}"> ${datum}</td>
            <td class="${col}"> ${adress}</td>
            <td class="${col}">  <img src="${imglink1}"></td>
            <td class="${col}"> ${beteichnung}</td>
            <td class="${col}">  <img src="${imglink3}"></td>
            <td class="${col}">  ${komune}</td>
            <td class="${col}">  ${hinweiss}</td>
            <td class="${col}"> ${wache}</td>
            <td class="${col}">  ${id}</td>
            <td class="${col}"> <img data-id="${id}"  class="momo" src="web_images/post.png"></td>
            <td class="${col}"> <img data-id="${id}"  class="loeschen" src="web_images/loeschen_2.png"></td>
           <!-- <td class="${col}">  ${mesage}</td></tr>-->
             `;

        }
        $('#scrollContent_unerledigt').html(sammeln);
        weiter();

    });    

    }
});

So sollte es ungefähr dann gehen , so spart man sich menge Datenvolumen wenn man nur was jolt wenn es sein muss

 hallo, habe angefangen deinen code zu übernehmen :-)

 hier im nodepad++ "siehe bild"  wird der text unten schwarz? da stimmt was nicht oder?