473,231 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Page Need to be Auto Refresh after every bid

2
Hi Guys,

I am new to this forum and find very interesting.

I need your help in one of the script.

I got a MySQL table bid_amount, and i want that if some new data comes in this table and where the table data is shown on webpage, that webpage need to be auto refresh.

To make it more easy to understand

See someone bids a amount on specific item and that bid amount goes in mysql and the outcome of that current update will auto refresh the webpage frontend data.

I hope you will understand what i want to do. I need a command for auto-refresh of webpage when some new data comes in MySQL table.

Please help me out and i will appreciate it.,


Thx in advance
Lezzo
Nov 28 '07 #1
3 3557
pbmods
5,821 Expert 4TB
Heya, Lezzo. Welcome to TSDN!

There is no way to do this directly; HTTP is a 'stateless' protocol, which means that the server completely forgets about the client as soon as it sends the page.

You could use AJAX and send a request out once every x seconds to see if the high bid has changed and then refresh the page if it has (or better yet, just update the current bid amount using JavaScript).
Nov 28 '07 #2
lezzo
2
Hi,

Thanks for your response, can you please provide me the ajax or javascript code which search the updated data from mysql and refresh the frontend webpage at same time.

Lezzo
Nov 28 '07 #3
pbmods
5,821 Expert 4TB
Heya, Lezzo.

You'd want to create a PHP script that fetches the highest bid for an auction and echoes it.

On the JavaScript side, send an AJAX call to that script and compare the result with the current value. If the value has changed, then you can either refresh the page or just simply update the displayed current bid.

Use setInterval() or setTimeout() to repeat the AJAX call.
Nov 28 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Lew | last post by:
Hi all, I'm trying to create a page that has a user-selectable page auto-refresh option (IE 5.5). Essentially, it's a page that contains a checkbox, when the user checks the checkbox, I'd like...
37
by: ajay | last post by:
How to make a web page getting refreshed after a given time interval automatically. HTML Code plz. Tx Ajay
3
by: francois | last post by:
I have an aspx page that needs to reload itself every x seconds. X is a parameter retrieve from the DB or the web.config file, just to point out that it will not be hardcoded. I need to refresh...
2
by: MattB | last post by:
I have a page I've migrated from HTML to asp.net that would auto-refresh every 30 seconds. I did this by putting the following in the <head> section: <meta name="refresh" content="30"> But now...
4
by: Coleen | last post by:
Hi All :-) I have a web page that I need to refresh every time the page loads. I thought that the page automatically did a refresh/postback on the Page_Load event. Isn't refreshing the page the...
7
by: Brian | last post by:
hello, I am looking for a way to auto refresh a web page that I created, but also let the user choose to stop the auto refresh. I can not figure out how to stop the auto refresh. Any help would...
4
by: Phil | last post by:
Hi. A fairly basic sort of 'direction to go in' question of the type that can be hard to find an answer to! I am using ASP.NET (framework 1.1) to present data on web pages (IIS 5.0 / IE6) from...
10
by: phforum | last post by:
Hi, I wrote a PHP page for user input the information to search the database. And the database data will update every second. I want to set the auto refresh to get the data from database every...
3
by: tinuananster | last post by:
Hi, I need to auto refresh a page after a specific time interval. When the page is accessed the first time, a request parameter is null and hence it gets redirected to a welcome page (static...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.