Please help me retrieving data from a PHP file!!???[Resolved]

[raladin]

Inva

[kows]

That isn't really a PHP question.. it's more of a VB question since you can't do anything to give VB the value you want. I suggest you ask it in the VB section... You're going to want to do a request for the page and read it in, parse it to get exactly what you want, and display it somewhere. I advise that you put unique markers in the PHP file around the values you want to, so that you can easily parse the file in VB and get the value you want..

IE:

<?
  $var = "test";
  echo "<marker1>" . $var . "<marker1>";
?>

Assuming that you're looking for the value between two '<marker1>'s, you can then use VB to split the file apart and get the value of $var..

Public Function parse(str As String, dil)
  str = split(str, dil)
  parse = str(1)
End Sub
 
'and then you can use it like this:
 
Private Sub Form_Load()
  parse(file_contents, "<marker1>")
End Sub

I use <marker1> just to show that you can use multiple dilimeters to get multiple values.. I don't think I'd literally use <marker1> though..

[raladin]

Inva

[raladin]

Inva

[kows]

here..

i'll try to get a better working version tomorrow, so this is pretty much the bare minimals..

[raladin]

Inva

[raladin]

Inva

[raladin]

Inva

[The Hobo]

A search of the forums could have found you an answer faster than posting this question again. Getting data from a file on a server is a commonly asked question in the VB section.

[raladin]

Inva

[The Hobo]

Originally posted by raladin
Resolved..

So mark the subject as such.

[raladin]

Inva

[The Hobo]

Uh...

Read the lessons on MySQL in the PHP book. Learn the functions mysql_connect(), mysql_select_db(), and mysql_query().

The read the MySQL book, particularly the SELECT * FROM and INSERT INTO syntax.

[raladin]

Inva