Find Jobs
Hire Freelancers

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!
项目 ID: 6677523

关于此项目

7提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
7威客以平均价$65 USD来参与此工作竞价
用户头像
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
$157 USD 在1天之内
4.9 (1099条评论)
8.9
8.9
用户头像
Hi.. I am willing to work on this.. I put some questions on public clarification board as well.. I am ready to work on this right now.. thanks
$100 USD 在2天之内
5.0 (257条评论)
7.2
7.2
用户头像
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
$60 USD 在2天之内
5.0 (36条评论)
5.6
5.6
用户头像
Hi. Thank you for posting this project. I read you prj description fully. I can start to do it right now and it'll take 24 hours to complete.
$30 USD 在1天之内
5.0 (63条评论)
5.2
5.2
用户头像
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
$30 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

SPAIN的国旗
Alicante, Spain
4.9
6
付款方式已验证
会员自10月 6, 2011起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。