May 9th, 2007, 11:36 AM
|
|
Contributing User
|
|
Join Date: Apr 2005
Posts: 207
Time spent in forums: 20 h 3 m 51 sec
Reputation Power: 4
|
|
How to check if an xml has data set in vb6?
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:
'http://localhost//datastatus.php?sessionkey=b429632c627bcf6bd4840561 690e3c49
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 or not?
'http://localhost//datastatus.php?sessionkey=b429632c627bcf6bd4840561 690e3c49
End Sub
datastatus.php
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>';
?>
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
