Filemaker basics

paulsim

I have a whole set of programmes using PHP to access MySQL - all using funcitons - no OOP.

I have to work out ways to get data out of Filemaker. I have Filemaker server and Apache2 - PHP - MySQL on the same computer.

I want a couple of basic lines to check that I am finding Filemaker and that I can access it OK.

For MySQL I would write $conn = mysqli_connect( etc

and check the result

Then a query such as select * from some_table

then check the output.

then I know I am connecting OK and can make a query work.

But how can I do these simple steps with filemaker to prove that I am connecting and querying it?

There are a couple of OOP systems kicking around such as FX - but I like funtions in that I find it far easier to debug and I have trouble getting my head around these class / objects - and also I read that they are slower and I am allergic to slooooow.

OK - so Filemaker is junk- but I am stuck with it and have to get the data our in the way I want it.

Any help??????

Cheers

Paulsim.

krmit

If you have server then you can grab the API for PHP documentation. From the help file:

FileMaker API for PHP Reference
If you installed the FileMaker API for PHP, you can find reference information on the web server component of your FileMaker Server deployment.
1For IIS (Windows):
<drive>:\Program Files\FileMaker\FileMaker Server\Documentation\PHP API Documentation\index.html
where <drive> is the drive on which the web server component of your FileMaker server deployment resides.
1For Apache (Mac OS): /Library/FileMaker Server/Documentation/PHP API Documentation/index.html

paulsim

krmit;10919055 wrote:
If you have server then you can grab the API for PHP documentation. From the help file:

FileMaker API for PHP Reference
If you installed the FileMaker API for PHP, you can find reference information on the web server component of your FileMaker Server deployment.
1For IIS (Windows):
<drive>:\Program Files\FileMaker\FileMaker Server\Documentation\PHP API Documentation\index.html
where <drive> is the drive on which the web server component of your FileMaker server deployment resides.
1For Apache (Mac OS): /Library/FileMaker Server/Documentation/PHP API Documentation/index.html

Thanks for that. I had not sen that good documentation was there.

Spent the day going through it.

There is a test page that one can get from the server by clicking the icon. Opening the FPServer_sample.fp7 works OK from the top link - direct to FP.

The PHP test link picks up the PHP test file which shouod open the FPServer_sample - but it does not open. I get Error 3 and Error curl3 - saying it does not open - with no real reason why.

When working with PHP MySQL I can check I have connected to the database OK using mysqli_connect(...... then if($result) echo " Connected OK"

Then I can echo the actual query.

then echo if it works using IF($result) again.

As I see it there is no way to check that you have actually connected to the database - and no way to echo the query - and the error message no 3 could be a variety of things.

Incidentally I can open FPserver_sample from a client on the same machine using open remote - but if i try to open using simlply OPEN it does not open due to sharing problem.

Any thoughts would be greatly appreciated.

Paul

krmit

paulsim;10919203 wrote:
Thanks for that. I had not sen that good documentation was there.

Spent the day going through it.

When working with PHP MySQL I can check I have connected to the database OK using mysqli_connect(...... then if($result) echo " Connected OK"

Then I can echo the actual query.

then echo if it works using IF($result) again.

As I see it there is no way to check that you have actually connected to the database - and no way to echo the query - and the error message no 3 could be a variety of things.

Incidentally I can open FPserver_sample from a client on the same machine using open remote - but if i try to open using simply OPEN it does not open due to sharing problem.

Any thoughts would be greatly appreciated.

Paul

Unfortunately I have only just started to play with PHP connecting to Filemaker so I haven't gotten any further than using the PHP Site Assistant.

Any file that is hosted on the server has to be opened via Open Remote from Filemaker.

In the file you are trying to connect to you need to have a user name and password that also has privileges to access via PHP.

You need to setup a Privilege set and make sure access via PHP is selected. I attached a screen shot. If I have time I will try setting up something on my server to see if I can be more helpful.

Another reference (http://jonathanstark.com/filemaker_api_for_php_documentation.php) - Jonathanstark has a book on using PHP and Filemaker.

Kevin