我有這段代碼，它會重新加載mysql連接并在html表中顯示結果集。我想每60秒刷新一次此頁面，以便在頁面中顯示新數據，當前手動刷新有效，但需要使其自動化。我正在使用瀏覽器刷新，但不確定如何每60秒進行設置，或者是否有其他方法可以執行此操作我正在使用瀏覽器刷新<script src="{process.env.BROWSER_REFRESH_URL}"></script> 和if (process.send) { process.send('online'); }我的代碼如下：const http = require('http');const mysql = require('mysql');const pool = mysql.createPool({ host: 'localhost', user: 'root', password: '', database: 'alerts', charset: 'utf8'});var reo ='<html><head><title>POWER CUT ALERT</title></head><body><h1>POWER CUT ALERT</h1>{${table}} <script src="{process.env.BROWSER_REFRESH_URL}"></script> </body></html>';function setResHtml(sql, cb){ pool.getConnection((err, con)=>{ if(err) throw err; con.query(sql, (err, res, cols)=>{ if(err) throw err; var table =''; //to store html table //create html table with data from res. for(var i=0; i<res.length; i++){ table +='<tr><td>'+ (i+1) +'</td><td>'+ res[i].timestamp +'</td><td>'+ res[i].device_id +'</td></tr>'; } table ='<table border="1"><tr><th>Nr.</th><th>Timestamp</th><th>IMEI NO</th></tr>'+ table +'</table>'; con.release(); //Done with mysql connection con.destroy(); return cb(table); }); });}let sql ='SELECT * from alerts';const server = http.createServer((req, res)=>{ setResHtml(sql, resql=>{ var reo2 = reo.replace('{${table}}', resql); res.writeHead(200, {'Content-Type':'text/html; charset=utf-8'}); res.write(reo2, 'utf-8'); res.end(); if (process.send) { process.send('online'); } });});server.listen(8080, ()=>{ console.log('Server running at //localhost:8080/');});
如何每60秒刷新頁面以重新加載mysql查詢
狐的傳說
2021-05-14 18:13:17
