The things I need added to my site are a live counter, infinite scrolling, a "dead" button on the table, and a form in which users submit a page's url from another site and certain data from that page goes into my database and displayed on my site.
1. The Form
What I will be displaying on the site are hits from Amazon’s mTurk. https://www.mturk.com/mturk/findhits?match=false They will be displaying on a bootstrap table. mturkhitstream.com/pasthits.php ← The site. What I will need the form to do is when someone submits this url of the hit, certain data will go into my mysql database. The form will have 3 fields; the url field, the time field, and the category field. http://i.imgur.com/kZw3BX4.png
Let’s say user wants to submit this hit posted by the requester, Jon Brelig. They should NOT enter the url of the search result page. They should submit the hit’s page like this https://www.mturk.com/mturk/preview?groupId=279O8JIA0RYNGKYOPHD0CBMMTWN050 He/she will go to the form, paste the above link in the url field, choose a category and put a time. (The time field is not mandatory). From the url, the data that should go into my database from this page is the title of the hit, the requester, the reward amount, the qualifications required, and the link that the person submitted. The data will then get displayed on the table. If you look at the table, there is a button for link. When a person clicks the button, it should take them to the link submitted. So basically, we’re just displaying the links as a button. What we also need to be done is, on the far right of my table there’s is a dead button. If someone notices that a hit is dead or expired, he/she will hit the dead button and it should get crossed out so everyone will know it’s no longer available. The change has to be permanent. When someone hits the dead button, the text has to be crossed out and not go back to the default when the page is refreshed. Doing this with only jquery will not work. The change won’t be permanent.If you click the dead button now, you see that the text gets crossed out but if you refresh, it isnt anymore. Also, the last hit submitted into the database should be the first hit displaying on the table.
2.The Counter For every hit posted, there is a reward amount. I would like a live counter displaying the daily total amount. When a new hit is submitted into the database, this reward amount should get added to the daily total and changed automatically. It should reset daily at 12 AM PACIFIC TIME (2 am central time/1 am eastern time).
3.Infinite Scrolling The last thing I would like added to the table page is infinite scrolling. When someone scrolls to the bottom of the page, more hits should load.
If you have any questions, please feel free to ask.
You will create example code that can do all of what I am asking, share it on dropbox, and I will add it to my code. If necessary, I'll provide the table's html and css code.