PoorDoggie

I need a way to "refresh" php in realtime. either way would be:

1. When it detects a new field in a mysql table based on a mysql query it refreshes the page

2. It just loads up new information when it can

I thought about using a "while" thing for this, but I couldn't think of a good way to do it. Any help would be excellent!

Thanks in advance

Tom

gamex

Can you explain a little more the whole situation and what you are trying to do? I mean, is this something that you can use cron jobs for?

__________________
Joe

PoorDoggie

no. I am trying to make like a chat script for php where it will automatically update the page. Like this:

1. User writes message + submits
2. Message gets stored in DB
3. On user's friend's side the php script is constantly checking for new messages, but without messy window refreshes
4. When a new message is found, the script writes it up on the screen (or refreshes - but only when a new message is found)

and vice versa!

Thanks
Tom

Peter

that cant be done not with php anyway.

php is a server side script what you need to do is use a javascript refresh or something like that to refresh the page with the chat.

__________________
Manage your portfolio using my new Domain Portfolio Management script.
Securing Your Domain Name From Theft

adam_uk

you would nee to keep the page rehfresh every so often

PoorDoggie

thats what I didn't want really.

Is there a way I can get javascript to "send" a php function to the server, and have it return something? (i know I am probably talking dribble now! lol)

so apart from refreshing the page, there is no way to do this?

Is there any way to refresh the page neatly and quickly?

axilant

this can be done via flash. nothing is impossible.

adam_uk

i know its possible (i havent done though a freind has) to build a script with javascript that can call data from a page

so you could have pagea.php inside this youd have your javascript function insdie a timer which refreshed every 30 seconds. this would call pageb.php then javascript would present the information out in a page which means you wouldnt need to refresh pagea.php

PoorDoggie

any idea what this would be called? or how to search for tutorials on the net?

Thanks a lot!
????: NamePros.com http://www.namepros.com/showthread.php?t=79661
Tom

adam_uk

im not sure what to search for but here is an example

http://www.aspplayground.net/forum/forumid_2/tt.htm#

then click one the plus signs

im guessing the bit you need is there it lodas the data then then slign than in a time function.

i just had a quick root through there source and turnt this up

http://www.aspplayground.net//forum/js/treeRow.js

PoorDoggie

er... right.

I think, although you are very kind, I will stick with the reloading page. Or I will figure something out which is slightly easier. What you gave me, really didn't help. Infact I almost s**t myself!

Acctually thinking about it - I could have an iframe and then just reload the iframe. Or do some fancy javascript whatnot to just re-write whats in it!

Thanks for all the help!

Another question, to stimulate your tired braincells (aww... I don't mean it... seriouslly! ):
- Is there anyway of getting info out of a mysql database with javascript? I suppose if I can, then I can just reload the content in an iframe every 5 seconds or something using "iframename.document.write" javascript function. I don't know much about javascript... that is my only problem!

Thanks a lot, for all the replys I have already had, and all the ones I hope to recieve!

Tom

Peter

no you will need to use the javascript to call an external script such as a php script or any other server side script. in the iframe just point it to the php script you create to pull the chat from the db then use javascript to do the refreshing every 30 seconds or whatever.

__________________
Manage your portfolio using my new Domain Portfolio Management script.
Securing Your Domain Name From Theft

PoorDoggie

thanks filth... I suppose that is the way it will have to happen!

axilant

if you ever seen http://achaea.com look at the java applet, i have made a clone of this game via php/mysql/flash and it loads just as fast, if not faster. Flash is the way to make something this...

PoorDoggie

nice site! that looks really good, I bet yours is better though. You can do a hell of a lot more with flash. That my only problem though, is the flash. I can't do it. I probably could if I put my mind to it, but I don't know it yet.

Can anyone point me in the direction of any good tutorials?

Thanks
Tom