HTML - Auto Refresh Add To Database For Radio City 96.7 Liverpool
Hi there.
Just to give a background of where this will be used, it is for Radio City in Liverpool (UK radio station of the year 2007). So big stuff! It will be used for what we already have in use, which is using frontpage, the person answering phones for the sport football phone-in, we key in the caller name, where they are from and what they want to talk about into a frontpage auto refresh we have, which refreshes every couple of seconds in the main on air studio. So we key in the details, it refreshes in the studio and can see what caller is there. What we would like to do now is to have someway of auto adding the data into a database on auto refresh when it detects new information ahs been keyed in, and it adds each field into microsoft access. So this keeps a database of callers that have gone onto the show for future usage. Is there any kind of way this is possible even just adding the caller into a new frontpage page automatically, maybe not access? Access would be easier, but is it possible at all? I was thinking along the lines of "on refresh, detect new info, detect fields, add new info into database". Hope you can help for this major project for such a major station! thanks, Ryan. Similar TutorialsThis is my first time posting here and was needing some help regarding auto refresh in html. I have a web page on our local network for my work that uploads screen shots of security cameras around the different locations. I have the page set to auto refresh and when it does refresh to redirect to another page that has a different set of cameras on it. The redirect works but the problem is after leaving this page up and running for several hours it will get stuck after a redirect and will keep trying to load the page for hours and wont redirect. It usually gets stuck on grabbing one of the images of the cameras, and then has problems displaying the image which then causes the page to sit and try to load for hours with no redirect. I was just wondering if there is anything that i can do for this? I am new to html and dont know much so any help will be greatly appreciated. Dpat is there any way that you can refresh one image on an html web page without haveing to refresh the whole page? Is this the correct code to use to auto-refresh a web page? It is not working for me. Is there something I'm missing? <META HTTP-EQUIV="Refresh" CONTENT="60; URL=http://website.com/"> Thank you. Hello I just started an online radio, with stats, but my problem, i want only the stats to reset, not the whole site, cause everytime the whole site refreshes, the radio refreshes to. Here is a pic: here is the php "radio_stats.php" source: HTML Code: <html> <head> <body bgcolor="e9e6f4"> <font color="navyblue"><?php // Shoutcast Server Stats // Parses shoutcasts xml to make an effective stats thing for any website // Coded by Daniel Brown. Edited by Nick Coates [SharpeHosting.com] [SharpeNews] KEEP THIS INTACT!!! // Please refer to the readme file for use. include('config_radio.php'); //you may edit this path to fit your server environment otherwise leave it alone $scfp = fsockopen("$scip", $scport, &$errno, &$errstr, 10); if(!$scfp) { $scsuccs=1; echo''.$scdef.' Habbo Hotel Radio Is Currently Offline'; } if($scsuccs!=1){ fputs($scfp,"GET /admin.cgi?pass=$scpass&mode=viewxml HTTP/1.0\r\nUser-Agent: SHOUTcast Song Status (Mozilla Compatible)\r\n\r\n"); while(!feof($scfp)) { $page .= fgets($scfp, 1000); } ###################################################################################################################### /////////////////////////part 1 \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ //define xml elements $loop = array("STREAMSTATUS", "BITRATE", "SERVERTITLE", "CURRENTLISTENERS"); $y=0; while($loop[$y]!=''){ $pageed = ereg_replace(".*<$loop[$y]>", "", $page); $scphp = strtolower($loop[$y]); $$scphp = ereg_replace("</$loop[$y]>.*", "", $pageed); if($loop[$y]==SERVERGENRE || $loop[$y]==SERVERTITLE || $loop[$y]==SONGTITLE || $loop[$y]==SERVERTITLE) $$scphp = urldecode($$scphp); // uncomment the next line to see all variables //echo'$'.$scphp.' = '.$$scphp.'<br>'; $y++; } //end intro xml elements ###################################################################################################################### ###################################################################################################################### /////////////////////////part 2\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ //get song info and history $pageed = ereg_replace(".*<SONGHISTORY>", "", $page); $pageed = ereg_replace("<SONGHISTORY>.*", "", $pageed); $songatime = explode("<SONG>", $pageed); $r=1; while($songatime[$r]!=""){ $t=$r-1; $playedat[$t] = ereg_replace(".*<PLAYEDAT>", "", $songatime[$r]); $playedat[$t] = ereg_replace("</PLAYEDAT>.*", "", $playedat[$t]); $song[$t] = ereg_replace(".*<TITLE>", "", $songatime[$r]); $song[$t] = ereg_replace("</TITLE>.*", "", $song[$t]); $song[$t] = urldecode($song[$t]); $dj[$t] = ereg_replace(".*<SERVERTITLE>", "", $page); $dj[$t] = ereg_replace("</SERVERTITLE>.*", "", $pageed); $r++; } //end song info fclose($scfp); } //display stats if($streamstatus == "1"){ //you may edit the html below, make sure to keep variable intact echo' <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <META HTTP-EQUIV="REFRESH" CONTENT="120"> <link rel=stylesheet href="" type="text/css"> <title>'.$scdef.'</title> </head> <body text="" bgcolor="e9e6f4"> <p> <font color="black"><font face="verdana" size="1"><b>DJ:</b> '.$servertitle.'</font></p> <font color="black"><font face="verdana" size="1"><b>Lytte </b> '.$currentlisteners.' / 200</font></p> <font face="verdana" size="1" color="black"><b> Sang:</b> '.$song[0].'</font></p> <b> <font face="verdana" size="1"> Siste Sang:</font></b> <font color="black"><font face="verdana" size="1"> '.$song[1].' </font> </body> </html>'; } if($streamstatus == "0") { //you may edit the html below, make sure to keep variable intact echo' <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <link rel=stylesheet href="" type="text/css"> <title>HabbXtra Radio er offline!</title> </head> <body text="" bgcolor=""><STYLE type=text/css> UNKNOWN { FONT-SIZE: 10px; COLOR: #black; FONT-FAMILY: verdana } BODY { BACKGROUND-COLOR: e9e6f4 } A:link { COLOR: ; TEXT-DECORATION: none } A:visited { COLOR: #363636; TEXT-DECORATION: none } A:hover { COLOR: #363636; TEXT-DECORATION: underline } A:active { TEXT-DECORATION: none } BODY { FONT-SIZE: 10px; COLOR: e9e6f4; FONT-FAMILY: verdana } TD { FONT-SIZE: 10px; COLOR: e9e6f4; FONT-FAMILY: verdana } TH { FONT-SIZE: 10px; COLOR: e9e6f4; FONT-FAMILY: verdana } .style5 {font-size: 14px} </STYLE> <div><center><img src="offline.gif"></img></center></div> </body> </html>'; } ?></font> </body> My html source can you see at: http://habbxtra.net/hjem.php Thanks Good morning... I have a bunch of links that open pdf files publish on a server. These files are overwritten with the latest data every 30 minutes... the challenges i have is to open the latest and greatest when i click on the link..... I do have a meta refresh code in the head of my page, it look like this: <head> <meta http-equiv="Cache-Control" content="no-cache"> each one of my links look like this: <a href="http://myweb.com/report/reportinpdf.pdf"; >Report name herer</a> Any ideas on making sure that i open the latest and greatest instead of whatever is in the cookies....???? (i am assuming that is why the files is not updating...) Thanks in advance... Seabass Hi All, I want to refresh the contents of IFrame without refreshing the whole page.....How is it possible... Hello I have a web page where I display 2 frames The bottom frame is a link to REPORT SERVICE Every day at 5 am server does RESTART and then I get an error (split screen is open 24 hours) How do I do REFRESH automatically after receiving an error? Thanks in advance I have this problem, Put the script on my page. in this script the people vote but When they return to the site the text of this form again at 1 and not recognized the vote.As I keep the voting when users refresh the page <form name="HOME"> <input type="text" value="1" name="CASA"> <input onclick="document.HOME.CASA.value = Number(HOME.CASA.value)+1;" type="button" value="Vote"> </form> As I keep the voting when users refresh the page i developing a web application one of page has following code Code: <frameset rows="12%,70%,12%" border="0" > <frame src="Frame/header.html" scrolling="no"> <frameset cols="28%,*" border="0" > <frame src="Frame/Menu.html" scrolling="no" > <frame src="Frame/content.html" name="ShowContentArea" scrolling="auto"> </frameset> <frame src="Frame/footer.html" scrolling="no"> </frameset> now for the second frameset , my problem is as below menu.html contains a dynamic tree structure , clicking on which m contents are displayed in content.html Now there is one more link to add a menu item in menu.html, if i click on that link the respective form to add menu item is displyaed After submission of the form the menu item is added to database but not reflected in menu.html as a another menu item . But if i refresh the whole page that menu item is get displayed That means i just want to set the refresh value of the whole page after adding a new item !!!!!!! but i tried a lot but failed , thats whay i need ur help , please help me guyes Thanks I really need help on this this is the original code : - Code: <html> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1250"> <meta name="generator" content="Andy Moo http://locationdetection.mobi/"> <title>TEST1</title> </head> <body> <div id="geo" class="geolocation_data"></div> <?php include 'geojavascript.php'; ?> </body> </html> I would like to add ajax auto refresh.. to refresh the div link which is something like this : - Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <script src="http://ajax.googleapis.com/ajax/ libs/jquery/1.3.0/jquery.min.js"></script> <script> var auto_refresh = setInterval( function() { $('#geo').fadeOut('slow').load('geojavascript.php').fadeIn("slow"); }, 20000); </script> <meta http-equiv="content-type" content="text/html; charset=windows-1250"> <meta name="generator" content="Andy Moo http://locationdetection.mobi/"> <title>Locator</title> </head> <body> <div id="geo" class="geolocation_data"></div> <?php include 'geojavascript.php'; ?> </body> </html> But, there is something wrong here... instead of refreshing the div.. it refresh html page only.. not the div data.. anyone.. please help me on this ? thanks in advance guys... I want to refresh the page after clicking submit button with interval of 10 seconds. How can I do that? I'm working on an HTML page that is going to be an iFrame on another page. The innerHTML of the iFrame page is set to automatically refresh every 20 seconds. The problem is that when that page refreshes, it "flashes" a white background for about 2 seconds before loading the background and content. How can I prevent that from happening every time it refreshes? Here is the page that has the problem: http://www.mattscss.com/rtb/template Here is the page that has the above link as an iFrame: http://www.mattscss.com/wzmr/wzmr_wmp.htm -------------------------------------------------------------------------------- Hey How can i wrote a program that refresh a web page and checks if a certain string is in the page ? Hello guys, first time posted, long time watcher! Really wanted a little bit of advice on something i'm trying to do at work. We use a web based helpdesk system to log our technical support calls, but it kicks us out every 10 mins if we leave our desk for something and have to go through the long process of logging in again. I was woundering if i created a frame set in another window and kept refresh the home base of the helpdesk system every say 1 min it would keep the connection up. Is this possible? Dave My IE is configured to automatically find the most rexent page, so when I address a website I see the current page. However, Safari and Firefox do not seem to have this optiion. So, when users address my website with those browsers they have to push the refresh button to be sure they are seeing my site's latest page. Yet when I use those browsers to access websites other than my own, I seem to get the latest page. This suggests that there may be a way to include in a page file a code that forces refresh. I know that there is a code ("no archive") that does the job where a search engine is involved, but how do I handle this problems where my URL is being directly addressed? Hi Does anyone know of a way to make webpages instantly refresh themselves when they are viewed. I'm changing content daily and having bother with people not being able to see all the new stuff as they are loading yesterday's page from their cache. Any help would be greatly appreciated. my webpage is divided by div. i face a problem which is, i want to open a link which will refresh the whole page instead of refresh the div. i'm not familiar using div, need help from someone plz..... thanks in advance... hello every one, i am a new with HTML. i am need to create a html page which gets refresh periodically so i did this... <head> <meta http-equiv="refresh" content="1" /> <meta http-equiv="expires" content="0" /> </head> <p><img src="/path" width="320" height="240" border="0" alt="my cam pic" /></p> It works fine , but when it gets refresh on IE or on mobile browserat the time of refersh page goes blank .. i just want to refersh image with out going it blank .. i mean it should display previous image till it gets next one and yes not looking for java or any other script.. can it be possible .. i want it in plain HTML script please help thanks in advance Is there a code that randomly shows one of e.g. three pictures that changes everytime you refresh the page? And/Or, something that changes the image fading from one into the other on a continuous loop. Thanks. Hi everybody... I'm trying to create a simple html page, with these functionalities... - the page is divided into 2 parts (10%, 90%) horizontally - in the top there is a field to write an URL, and an OK button, to load the url to the bottom part - after that the program searches for a string. if the string is on the webpage, sends an emailt to a specified email address, if the string isn't on the loaded page, after a while (5 minutes) reloades the bottom part (the url in the top part), and searches for the string again... Does somebody have an idea, how to start? Please help me, I'm not a great html coder, I need some instructions... |