PHP script

Ronnie Dackus · **Posted:** April 17th, 2006, 9:30 am

Hello,

I'm trying to get data from our server with a variable from Opus. It checks the field "memo" on our server with the variable "user" set in opus.

I use this PHP-script :

Code:

<?php 

$user = $HTTP_POST_VARS['user']; 

$DBhost = "localhost"; 
$DBuser = "lxxxx"; 
$DBpass = "xxxxx"; 
$DBName = "lxxxx"; 

$connect = mysql_connect($DBhost,$DBuser,$DBpass); 
$db = mysql_select_db($DBName,$connect); 
$query = "SELECT * FROM klanten WHERE memo='$user'";  
$result = mysql_query($query, $connect); 

$row = mysql_fetch_array($result ); 
$data = "&first=".$row['first']."&last=".$row['last']."&address=".$row['address']."&position=".$row['position']."&aanhef=".$row['aanhef']."&memo=".$row['memo']; 
echo $data 
?>

I set the source to string "memo" and variable to "user", in the destination I set the fields "first" and "last" but no data is returned.

If there is somebody that can help it woul'd be great...

Thanks

Ronnie

Duncan Lilly · **Posted:** April 17th, 2006, 12:03 pm

If you are using the Variable option on the Post Web Data, the data is passed as a POST variable called 'data'. Your script needs to look for

Code:

$user = $HTTP_POST_VARS['data'];

From the help:
When you send this information to a Server, the contents of the variable are sent to the server with the string name data. Therefore, the cgi-script that processes the data should be looking for the name data – see Using Name-Value Pairs in the Post Web Data action for more information.

Ronnie Dackus · **Posted:** April 17th, 2006, 12:29 pm

Thanks Ducan,

That did the job work.

cheers

Ronnie

Ronnie Dackus · **Posted:** April 17th, 2006, 7:21 pm

It has to be Duncan.....

cheers

Ronnie

Digital Workshop

PHP script

Who is online