Relaying information from PHP Script/MySQL

[KT-Radio]

Don't know what this forums like, hoping it's as friendly as some of the forums i've come across, but hey i'm Kyle
Right, I'm going to explain into as much detail as possible what I want to achieve here...

I Have VB6.0 Pro Edition, I Have multiple sites, one of which is what I'm needing help with.

I run an internet radio station (http://www.kt-radio.co.cc/). I Have a specific server for each of
a) Front end website (Public)
b) DJ Panel, which is where the staff login and fetch notices, requests, messages, pm's etc.

I basically want to relay different parts of the website (all written in php with a MySQL Database) into a VB executable so DJ's can download it and use the DJ Panel without a browser as it can get frustrating.

Different features I want to include are;

- Login (Using the existing login's)
- Message Box
- Set DJ Message
- SHOUTcast Server Status
- Staff Chat (Basically a shoutbox)
- Notifications (Haven't got this feature)

All of the above, Barr the notifications already exist on a website.

I Can Message you with any ftp login or URLS you might need.
I Have a limited knowledge with stuff like this, i can build simple VB apps, and write simple PHP, but bringing them both together :shoot:.

PM Me if you'd rather help through E-Mail or BlackBerry Messenger.


Thankyou!

Kyle

[KT-Radio]

P.S: I'm hopeless with chaging messing with MySQL. Installed it with a base script and built ontop of it (Bit of a Cheat )

[dglienna]

Anything posted here will be picked up by bots by Monday, so I'd remove it NOW, and hope they haven't picked up on it. We can PM you, only with a current USER ID!

[KT-Radio]

ahh sorry about that, I'm on it.

[KT-Radio]

Don't suppose you'd be able to help out on this dglienna...?

[dglienna]

Not really. I'd suggest starting with VB.Net or VS2010 and C#. While VB6 might be able to cobble together various band-aids and scripts, I'd scrap the idea of using VB6.

[KT-Radio]

Ah right, downloaded vb2010 last night, havent had chance to play around with it yet though... bit scared of eveni installing C# never even thought about learning it.

Thanks

[dglienna]

Might be easier if you are GOOD at VB6, as it's a bit different. If not, then VB.Net is the way to learn...

[KT-Radio]

Wouldn't say I'm "Good" as such.. But I have 'above limited knowledge' . And I have a bit of an expansion to what I was asking that might make it easier to interpret..

<?php
$ip = "IP ADDRESS HERE";
$port = "PORT";
$fp = @fsockopen($ip,$port,$errno,$errstr,1);
if (!$fp) {
$title = "Connection timed out or the server is offline ";
} else {
fputs($fp, "GET /7.html HTTP/1.0\r\nUser-Agent: Mozilla\r\n\r\n");
while (!feof($fp)) {
$info = fgets($fp);
}
$info = str_replace('</body></html>', "", $info);
$split = explode(',', $info);
if (empty($split[6])) {
$title = "No song is currently playing ";
} else {
$count = count($split);
$i = "6";
while($i<=$count) {
if ($i > 6) {
$title .= ", " . $split[$i];
} else {
$title .= $split[$i];
}
$i++;
}
}
}
$title = substr($title, 0, -2);
print $title;
?>

Thats what I wasnt to relay to the VB project, with alot of other code of a similar format. I just don't know what to view it with.

EDIT: I know I need a reader of sorts, but I have never had to deal with a MySQL query with vb before, Only time I edit MySQL querys is when I am writing it in notepad for php. The output of this query, in PHP will display in text, is their a way I can feed that text through to a label of sorts? Need it as a variable really but I don't have a clue :-#

[WoF]

Still I don't quite understand what you want to achieve.
Do you want to rewrite the above code to VB6?
Or do you want a variable in VB which holds the above program code? Or the output of it?

[KT-Radio]

Still I don't quite understand what you want to achieve.
Do you want to rewrite the above code to VB6?
Or do you want a variable in VB which holds the above program code? Or the output of it?

I'll try have another shot at it lol.
'SHOUTcast DNAS Stats' are hosted on a seperate webserver (Not owned by me).
I Have the PHP code for these stats, which relay the stats to my DJ Panel.
I Want the stats from shoutcast dnas, to relay into the VB app (Somehow...)

I can't upload anything as the file limit is quiet small. So I can't upload a screenshot of the stats.

The code i posted in the previous post is the the "Song now Playing" stat.
If someone could tell me how to use this PHP code in VB I would greatly appreciate it!

And thankyou for getting back to me mate

EDIT:

Do you want to rewrite the above code to VB6?

I think this could be what I want to achieve yes, but what component would I use?
Thanks

[dglienna]

Depends on the browser, and/or the language you use...

[KT-Radio]

Depends on the browser, and/or the language you use...

My project supports FireFox and Internet Explorer. 2 different forms for each, when you load the project, it asks you which one you want to use, and their the most popular for people tuning in

Thanks

EDIT: I want to try and stay away from the internet tools though, I have so many problems with them both:/

[WoF]

Many things you do in this PHP script are to be done more complicated in VB6, but I think all in all everything could be converted to pure VB6 code.

As I understood you want a stand-alone application which is NOT a webbrowser.
Otherwise, VB6 has a WebBrowser control which might be capable to run PHP, although I have to admit my experience with this control is rather limited.

[KT-Radio]

Many things you do in this PHP script are to be done more complicated in VB6, but I think all in all everything could be converted to pure VB6 code.

As I understood you want a stand-alone application which is NOT a webbrowser.
Otherwise, VB6 has a WebBrowser control which might be capable to run PHP, although I have to admit my experience with this control is rather limited.

Yeah It would be alot better to do it in code than using the WebBrowser control as, In my oppinion, it is crap.
If you could point me in the right direction on how to convert it to vb6 code, or how to convert it into Visual studio 2010 code,I would be much greatful.
I sat up for hours last night trying to work it out, but had no luck.

Cheers