View previous topic :: View next topic |
Author |
Message |
Andy_Fletcher Contributor
Joined: 10 Jun 2003 Posts: 90 Location: Somerset, United Kingdom
|
Posted: Thu Jan 31, 2008 3:26 pm Post subject: Working with PHP Scripts and VDS... |
|
|
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 |
|
Back to top |
|
|
jules Professional Member
Joined: 14 Sep 2001 Posts: 1043 Location: Cumbria, UK
|
Posted: Thu Jan 31, 2008 8:55 pm Post subject: |
|
|
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 |
|
|
Andy_Fletcher Contributor
Joined: 10 Jun 2003 Posts: 90 Location: Somerset, United Kingdom
|
Posted: Thu Jan 31, 2008 9:47 pm Post subject: |
|
|
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 |
|
|
DaveR Valued Contributor
Joined: 03 Sep 2005 Posts: 413 Location: Australia
|
Posted: Fri Feb 01, 2008 12:36 pm Post subject: |
|
|
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 |
|
|
Rubes_sw Valued Contributor
Joined: 11 Jun 2001 Posts: 625 Location: Northern Ireland
|
Posted: Fri Feb 01, 2008 8:01 pm Post subject: |
|
|
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 |
|
|
Skit3000 Admin Team
Joined: 11 May 2002 Posts: 2166 Location: The Netherlands
|
Posted: Sat Feb 02, 2008 3:02 pm Post subject: |
|
|
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.
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 |
|
|
Andy_Fletcher Contributor
Joined: 10 Jun 2003 Posts: 90 Location: Somerset, United Kingdom
|
Posted: Fri Feb 08, 2008 8:08 pm Post subject: |
|
|
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 |
|
|
|