Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to check if an xml rss has data set?

Status
Not open for further replies.

Edward07

Programmer
Apr 13, 2007
49
NL
In my project i added a timer that frequently checks a remote xml. What i want this new timer some how check if the rss feed is giving any result out. If it gives data out i for example reload webbrowser controle.If it doesn't give any data out i do nothing. (I don't need to output xml content)Could any one show me how i can make such check.Thanks

Note:The url to check for its xml data is like this:
'

Code:
Private Sub Form_Load()
       
     Timer2.Interval = 7000 ' <-- 10 seconds
    Timer2.Enabled = True
End Sub

Private Sub Timer2_Timer()
Static lngMin As Long

    lngMin = lngMin + 1
    
    'every 2nd timer tick reload the listview
    If lngMin Mod 2 Then
        checkForNewData
    End If

End Sub

Private Sub checkForNewData()
'Here i need to check for new data . If new data is avalible then
'reload the webbrowser.

'i need some how check if the following php code outputs any xml data set or not?
'[URL unfurl="true"]http://localhost//datastatus.php?sessionkey=b429632c627bcf6bd4840561690e3c49[/URL]


End Sub

datastatus.php

Code:
<?php
header("Cache-Control: no-cache, must-revalidate");
	header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

$sessionkey=$_GET['sessionkey'];

$server   = "localhost"; // MySQL hostname
$username = "root"; // MySQL username
$password = "root"; // MySQL password
$dbname   = "db"; // MySQL db name

$db = mysql_connect($server, $username, $password) or die(mysql_error());
      mysql_select_db($dbname) or die(mysql_error());

// this is necessary, otherwise it won't work: 
header('Content-type: application/xml'); 
// you need to return the error as xml as well 
$res = mysql_query("SELECT w,h FROM datastatus WHERE who_sessid ='$sessionkey' ") or die('<error>'.mysql_error().'</error>');
// display the root node of the xml, and start looping over the elements: 
echo '<playlist>'; 
while($row = mysql_fetch_assoc($res)){ 
  echo '<song>'; 
  echo '<artist>'.$row['w'].'</artist>'; 
  echo '<name>'.$row['h'].'</name>'; 
  echo '</song>'; 
} 
echo '</playlist>';  


?>
 
Well, if you always refresh your control, you don't need to check and see if anything has happened, do you? Perhaps we can try to pull this entire discussion into one thread........
 
bob this questin belongs to diffrent project that i work.I am using data avilibitly as flag to trigger diffrent events within my vb6 applicaiton. So i need to know how to check data avilibitly some how.
 
Oh, ok. But why are you doing this? The same question: why can't you simply trigger those events every time your timer goes off, instead of trying to check whether your data has changed first? I'm not saying that you're doing it all wrong, but you should eliminate simple solutions as unworkable before going on to more complicated ones.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top