I really need help and advice on implementation. There is an administrative panel with a single table, with the output of the last 60 lines from the MySQL database. The database receives every few seconds from 1-10 records, and 1 cell can be updated in each record. In the admin panel there are 3 managers who work among themselves. Actually questions

  1. How to implement data update in real time, taking into account the check for cell updates of the last 60 lines, so that each new row or cell row update is allocated for a few seconds (to visually see the changes)?
  2. What technologies implement the line selection function for each manager, i.e. when a new line appears, one of the managers can click on the "accepted" button, and the rest will have a small block next to the line and the manager's name (I intended to do node.js and socket.io, but I don’t know how to combine with php) no need to save to table, they will be stored in session

Thank you in advance

  • one
    Enough here and ajax - Manitikyl
  • @Manitikyl, but tell me how to properly organize the verification of the values ​​of changes in a particular column from the last displayed lines? - kosh
  • Build an object where the keys are any id entries on the screen. run through the array of incoming data, if id in the object is not present - this is a new line, add it somewhere (just not yet in this object). If there is a line - verify the data, if changed, reflect this fact. then remove this key from the object. When the input data array has ended, look at the object - all the keys that remain in it are those lines that were not in the new data - they can be removed from the screen - Mike
  • @Mike sort of understood, thanks - kosh

0