[FX.php List] Cannot get FX to connect to FMP

[Bob Patin/Longterm Solutions]

I wonder if it's a server issue; have you tried restarting the web  
server?

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
AIM: longterm1954
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

On Jul 23, 2008, at 10:12 AM, VanBuskirk, Patricia wrote:

> I am having major problems all of a sudden.  Our online forms are in  
> php
> on a designated server (Win Server 2003), using FX.php.  They started
> acting up Friday (the form just stopped when it got to the dropdown
> list, we got them working .. then again last night, we got them  
> working,
> then again this morning and I cannot get them working again.  They now
> show the entire form, but will not show the drop-down list (which pull
> from a field in FMP) and when submitted will not go to the confirm.php
> page (the physical file shows in the directory, but goes to a page not
> found error). And it does not make a record in FMP.
>
> We ran the included FM tests and all the web publishing tests come  
> back
> ok.  I have a test page that prints out the php settings, then lists  
> all
> the hosted databases available to the web (<?php  
> print_r($databaseList);
> ?>).  That works.
>
> When it gets to the following point in the form, it will not show the
> list:
>
> <select name="Contact_Bldg" tabindex="5">
>  <option selected>NOT LISTED - Type in Below</option>
>  <?php
>
> require_once('FX.php');
> require_once('server_data.php');
>
> // configure a connection to FileMaker Server Advanced
> $ordersQuery = new FX(FM_IP, FM_PORT, FM_VERSION);
> // set database and layout information
> $ordersQuery->SetDBData('WEB_Forms', 'Ref_FSU_Buildings', 'all');
> // set database username and password
> $ordersQuery->SetDBUserPass(FM_USERNAME, FM_PASSWORD);
> // retrieve all records in this database available to the current user
> $ordersQuery->AddSortParam('ListForWeb', 'ascend');
> $orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL);
> 	foreach ($orders as $contact) {
>    echo "                <option>{$contact['ListForWeb']}\n";
>
> }
> ?>
> </select>
>
> This makes me think it has something to do with FX.  I re-downloaded
> fx.php, made sure the includes folder is where it is supposed to be,
> re-verified the php.ini is pointing to that folder, made sure all the
> includes are in there ... I am out of ideas and about to pull my hair
> out!!  Anyone have any suggestions??
>
> Trish
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list