[FX.php List] Parsing FP7 XML data

[Head Honcho]

Hi Paul,

I think you're thinking too much...

The way it works is [very basically]....

The browser talks to IIS... which talks to PHP... which talks to FX...  
which does all the connecting to FMS... which gives FX the XML to  
process... which is passed back to PHP... which is giving to IIS...  
which passes it back to the browser.

So...

Forget about changing any settings in FileMaker [ports or anything  
else],
Forget about the fmi/xml/FMPXMLRESULT.xml stuff [this is handled by  
FileMaker]... and the parsing is all handled by FX.

All you need to do is ensure that the fmxml privilege set is turned on  
for the user/password setting you are using in your "calling" page.

Create a valid call to to IIS and it will "just work".

Your call should be something like.  192.168.29.252/myTestPage.php,  
assuming myTestPage.php has the correct code in it.

If I recall, there's a set of instructions for setting all this up  
that comes with the FX download, including a sample file. [I don't  
work much with FX anymore as I use FileMaker's API... but the theory  
is the same]

Why not just set that up to see what is necessary and then work on  
developing your own thing.

BTW, it shouldn't matter which webserver you are using (IIS [Win] or  
Apache [Mac]), as long as PHP is installed and working, and the fmxml  
privilege set is correct, it will "just work".

Hope this helps.

Regards

Michael Ward
--
Head Honcho
CustoMike Solutions
Member, FileMaker Business Alliance
Member, FileMaker Technical Network
FileMaker 7 Certified Developer
FileMaker 8 Certified Developer
FileMaker 9 Certified Developer
FileMaker 10 Certified Developer
10 Wandoo Crt
Wheelers Hill, 3150
ph 0414 562 501
headhoncho at customikesolutions.com



On 08/07/2009, at 9:11 PM, Paul wrote:

> Hi
>
> I have spent a good few hours trying to get FX to work, but cannot  
> get the find queries working.
>
> I have FPServer 9 Advanced on a PC.
>
> PHP is working fine.
>
> IIS is also installed; although I can stop it – with no beneficial  
> effect.
>
> IIS is 127.0.0.1 – localhost
>
> FMS is set to 192.168.29.252  and port 16000 – as IIS has copped 80.
>
> I try FX_tester.php – getting the IP and port and FP7 correct etc.  
> It does connect to the server – if I change the username or password  
> to something false it tells me that it does not connect to the  
> server. So it is connecting with    Admin and no password
>
> However I get this message – which many others get until they get FX  
> sussed and working OK.
>
> Using FileMaker URL: http://Admin:@192.168.29.252:16000/fmi/xml/FMPXMLRESULT.xml?-db=Contacts.fp7&-lay=web_list&-max=all&-findall
>
>
> Now I understand some of the code but not all. But this line tells  
> me that we are trying to create an XML file
>              192.168.29.252:16000/fmi/xml/FMPXMLRESULT.xml
>
> and then parse it.
>
> Now for a PC this is not a valid address.
>
> Maybe my thinking is wrong and this file is never supposed to be  
> created – like virtual –
>
> After the lines
> Ob_start();
>
> Curl_exec      etc
> $data = trim (ob_get_contents() );
>
> ob_end_clean();
>
>
>
> $data is not empty – it has 1108 bytes – but only fHTML formatting  
> code – no data from the database – Contacts.fp7.
>
> Same with other databases I have tried
>
> Any ideas? Guess a lot of people are using Macs – where it may be  
> straight forward and perhaps that URL is valid.
>
> Should I completely re-install without IIS???? – or do you guys have  
> IIS installed – if you are using PC. I suppose you use Apache on Mac.
>
> I would really like to use FX – but have come to a dead stop.
>
> Cheers
>
> Paul
>
> paul at mancomp.co.nz
>
>
>
>
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list