AJAX / jQuery webpage to monitor updated data on MySQL table.
$10-30 USD
进行中
已发布超过 9 年前
$10-30 USD
货到付款
Hi!,
I need a quite "quick and simple" web page (accesed usually from localhost) to monitor rows changed at my local MySQL database.
The DB contains just 1 table with 200 rows:
Sensor_Name (CHAR(4) (primary key), values from "S001" to "S200")
Sensor_Last_State (VARCHAR(5), values "RED", "BLUE", "GREEN")
Sensor_Last_State_DateTime (DATETIME)
(There is a program that updates the "State" value of every "Sensor" in the database every 5 to 10 minutes time, updating also the "DateTime").
The project consists in writing a webpage (just one page) that:
- presents a simple table with 200 cells (20 columns x 10 rows), named from S001 to S200, showing inside every cell the 3 values (Sensor_Name, Sensor_Last_State, Sensor_Last_State_DateTime)
- this web page will autorefresh the info every 5 seconds, polling the DB and asking for the 200 rows data. It's important to avoid refreshing the whole page, only the iframe/div where the table is (please use ajax/jquery)
- every cell's background color will change with the value shown in "Sensor_Last_State". When one row changes will be pure RED (#FF0000), BLUE (#0000FF or better CYAN #00FFFF) or GREEN (#00FF00), and with every refresh will progressively fadeing into white until the next change (for example in 10 minutes time will be completely white if there is no change in that database row)
Please feel free to ask anything.
Thank you!
Hello!
With 99% completion rate, 720 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :)
I look forward to your reply.
Thanks.
Kind Regards,
Rajesh Soni
Hi I am Prathap,
I went through the task description. I can do this using ajax and jQuery. Using settimeout function we can execute the ajax at a regular interval of time to fetch data from database and display in webpages.
I have more than 3 years of experience in web development and have worked on lot of stuffs.
I hope I can successfully complete and deliver a good quality work on time.
Kindly initiate the chat to discuss further about the project.
Thanks
Prathap
we just need to add a timer that will continuously monitor that database.I already did that in a project please contact me I can do this within an hour