mian — 2013-06-23T00:50:57-04:00 — #1
Hello site point forums.
I am designing a website for one of my customer in which database and programming is involved.
There is a control panel in which there are three different forms connected to three different tables ... the customer logs in and enter some values in those forms and these values are then stored in data base now the problem is to display these stored values on index page in timely manner.
like after every 15 minutes or after every hour the values which were stored can automatically updated on the website main page in timely manner?
can any one help me with this?
shaydez — 2013-06-23T11:25:02-04:00 — #2
What's throwing me off is your Timely manner.. i don't understand what timing your expecting, are you saying usability wise or programming?
To fill out 3 forms and populate them into a table should not take any time at all adding to the database and to post it every 15 minutes on the website you can do 2 things run a JQuery AJAX request every 15 minutes or run a cron job.
It really depends on your application structure is where the real question is.
My recommendation is come up with a workflow of your application and create a logic from there, before you start asking questions (not to sound rude lol )
mian — 2013-06-23T17:56:19-04:00 — #3
Thank you sir for you kind answer. i will focus on workflow of application if any problem occurs i will ask again ..
atdev — 2013-06-24T00:27:14-04:00 — #4
It seems as if perhaps you don't want to query the database for every time your index page loads.
In this case you can use caching where you write the results of the database query and the page to a file. This is then loaded most of the time and you can check the file time and only refresh the cache after 15 minutes or whatever time you wish to rewrite the file content.
I hope this helps.