Live grid with ajax
My theoretical sales staff uses a shared web-based list to track new leads. This is built off of a MySql db, using php to print a table with form controls for each row. Updates are old-school posts on static pages. So to keep everything updated, header refreshes are required.
Each row is colored based on the contact type and priority, both of which can be changed by viewing the sales record. There is a button on the row to mark the sale as processed - this takes it out of the list.
I'd like to scrap the static model and make something ajaxy.
The table needs to be dynamic, so that when any of my 20 sales people update a contact type or priority, it is immediately (or close to immediate) updated on all browsers viewing the table. When a sale is processed it should be reflected in real time for anyone viewing the table.
Am I still looking at page refreshes, or is there a way to handle this with Ajax (without murdering my database)?
Each row is colored based on the contact type and priority, both of which can be changed by viewing the sales record. There is a button on the row to mark the sale as processed - this takes it out of the list.
I'd like to scrap the static model and make something ajaxy.
The table needs to be dynamic, so that when any of my 20 sales people update a contact type or priority, it is immediately (or close to immediate) updated on all browsers viewing the table. When a sale is processed it should be reflected in real time for anyone viewing the table.
Am I still looking at page refreshes, or is there a way to handle this with Ajax (without murdering my database)?
