0 Replies Latest reply on Mar 17, 2010 1:07 PM by kcriswell

    Help accessing database using FX.php

    kcriswell

      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>