AnsweredAssumed Answered

Help accessing database using FX.php

Question asked by kcriswell on Mar 17, 2010

Title

Help accessing database using FX.php

Your post

Filemaker Server 7

 

Windows 2003 running IIS to server php sites.

 

Already have one database up and running that users can log into and submit a repair request. (This was setup by the person before me with 0 documentation) I have copied parts of the php coding that allows for those users who have already verified they were in the system, into a new database that is suppose to become the online registration.

 

 

I am unable to get my php to go to the desired database and pull valuelist, let alone enter any new data into the database.

 

Code for database access:

 

<?php
include_once('FX/FX.php');
include_once('FX/server_data.php');


$vlists=new FX($serverIP,$webCompanionPort,'FMPro7');
$vlists->SetDBData('uSERRegistration.fp7','Registration');
$vlists->SetDBPassword('$WebPW','$WebUN');
$VLIST -> SetDBUserPass('$DBUser');
$vlistsResult=$vlists->FMView();

?>

 

Code for valuelist display:

 

<select name="selorgType" id="selorgType">

<?php
         foreach($vlistsResult['valueLists']['selOrgType'] as $key => $value){
           ?>
<?php
}
?>
</select>

 

 









Outcomes