forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


Working with PHP Scripts and VDS...

 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Miscellaneous
View previous topic :: View next topic  
Author Message
Andy_Fletcher
Contributor
Contributor


Joined: 10 Jun 2003
Posts: 90
Location: Somerset, United Kingdom

PostPosted: Thu Jan 31, 2008 3:26 pm    Post subject: Working with PHP Scripts and VDS... Reply with quote

Hi All, I have been trying to get VDSMysql to work with my new MySql Server (Upgraded from 3.... to 5... and also have VDS upload files to the database in Long Blob fields...
Sadly it is not going to happen so I have started using PHP scripts to now communicate with MySQL as it is well supported.

My Question: Can anyone show me some hand ways of communicating with PHP and getting information between VDS and the Script or even calling PHP directly.....?

Thanks for any help and perhaps we'll get some people together to discuss working with both PHP & VDS whilst solving this problem for me Wink
Back to top
View user's profile Send private message
jules
Professional Member
Professional Member


Joined: 14 Sep 2001
Posts: 1043
Location: Cumbria, UK

PostPosted: Thu Jan 31, 2008 8:55 pm    Post subject: Reply with quote

Hello Andy. I have a couple of VDS programs that update databases on a website. It's not very sophisticated. The PHP script is called with the data as part of the URL, and the script just does an echo "some response" back to the VDS program. It uses the VDS 6 list loadfile command which can take a URL as an argument.

Example: list loadfile,1,http://myweb.com/myscript.php?data1=XXX&data2=YYY

Then you just parse list 1 for the returned data.

Obviously the data needs to be URLencoded if it might contain spaces or any other invalid HTML characters. There is an @urlencode function in VDS 6 for precisely that reason.

_________________
The Tech Pro
www.tech-pro.net
Back to top
View user's profile Send private message Visit poster's website
Andy_Fletcher
Contributor
Contributor


Joined: 10 Jun 2003
Posts: 90
Location: Somerset, United Kingdom

PostPosted: Thu Jan 31, 2008 9:47 pm    Post subject: Reply with quote

jules wrote:
Hello Andy. I have a couple of VDS programs that update databases on a website. It's not very sophisticated. The PHP script is called with the data as part of the URL, and the script just does an echo "some response" back to the VDS program. It uses the VDS 6 list loadfile command which can take a URL as an argument.

Example: list loadfile,1,http://myweb.com/myscript.php?data1=XXX&data2=YYY

Then you just parse list 1 for the returned data.

Obviously the data needs to be URLencoded if it might contain spaces or any other invalid HTML characters. There is an @urlencode function in VDS 6 for precisely that reason.


Hi Jules, long time since we last spoke. How are you ?
I have only got VDS 5 so I guess I'll have to figure some other way out although I was thinking along the same lines as yourself to solve this...
Somthing like %%T = @dlgtext(browser1), List add,1,%%T
and the parse for data I want to use......
Back to top
View user's profile Send private message
DaveR
Valued Contributor
Valued Contributor


Joined: 03 Sep 2005
Posts: 413
Location: Australia

PostPosted: Fri Feb 01, 2008 12:36 pm    Post subject: Reply with quote

jules wrote:
It uses the VDS 6 list loadfile command which can take a URL as an argument.

Why is this not mentioned in the help file?

_________________
cheers

Dave
Back to top
View user's profile Send private message
Rubes_sw
Valued Contributor
Valued Contributor


Joined: 11 Jun 2001
Posts: 625
Location: Northern Ireland

PostPosted: Fri Feb 01, 2008 8:01 pm    Post subject: Reply with quote

We use VDS to commnicate heavily with PHP,

doing all sort of cool things... eg..

updating Mysql database, retrieving info, encrption etc etc....

It is even easier and faster now that vds6 can load url data directly into a list

Nathan
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Skit3000
Admin Team


Joined: 11 May 2002
Posts: 2166
Location: The Netherlands

PostPosted: Sat Feb 02, 2008 3:02 pm    Post subject: Reply with quote

DaveŽ wrote:
jules wrote:
It uses the VDS 6 list loadfile command which can take a URL as an argument.

Why is this not mentioned in the help file?


To see a list of new features, open the help file, open User Guide, What's new in Visual DialogScript 6 and then What's new. Smile

Quote:
Integrated web (HTTP) support lets you use an http:// URL most anywhere a disk filename can be used as an input file.

_________________
[ Add autocomplete functionality to your VDS IDE windows! ]
Voor Nederlandse beginners met VDS: bekijk ook eens deze tutorial!
Back to top
View user's profile Send private message
Andy_Fletcher
Contributor
Contributor


Joined: 10 Jun 2003
Posts: 90
Location: Somerset, United Kingdom

PostPosted: Fri Feb 08, 2008 8:08 pm    Post subject: Reply with quote

Rubes_sw wrote:
We use VDS to commnicate heavily with PHP,

doing all sort of cool things... eg..

updating Mysql database, retrieving info, encrption etc etc....

It is even easier and faster now that vds6 can load url data directly into a list

Nathan


Don't want to pay for an upgrade to VDS 6 at this point as I am not a going to get the best out of it and the advantages would not be fully utilised.... I did manage to get the @dlgtext(Browser) into a list and then look for a match() in the list of the output I was expecting.

What about making a call directly to PHP5iapi.dll or PHP_Mysql.ll and working with them ?

Can we do this with VDS and If so how would I go about it ?

Thanks Guys....
Andy F
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Miscellaneous All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group