AnsweredAssumed Answered

Is CWP with PHP the correct option

Question asked by ndveitch on Jun 29, 2017
Latest reply on Jun 29, 2017 by beverly

Hi All,

 

I have a big question to ask, we are busy adding to a current solution and need to start web integration. Our web hosting company has put a page together for us where our suppliers will log on and upload invoices. The idea we have is that the web developer has put the site together using a MySQL DB and using PHP, so my thought is to use the FM PHP API to communicate between the FM DB and the web site.

 

The idea we have is that the suppliers will log onto the website, upload their invoices and complete required fields. Then the stand alone suppliers DB we have created will then poll the website DB and when a supplier has uploaded their information, we would then pull that down to our system and the various departments can then log into the suppliers DB to do all their admin checks. Should there be any issues with the invoice, they can make a comment for the supplier which will then be pushed back to the website and the supplier can then view the comment and take any appropriate actions. Or if the invoice is ok, the department can mark it ready for payment and that notification will be sent back to the website so that supplier can see that their invoice is in the process of being paid. Once the invoice has been marked for payment, finance will pull the invoice into the main system and then the normal processing of the invoice will take place. Last thing is, when the invoice is paid, the suppliers db will be updated with status PAID and this will then be pushed to the website.

 

Now the main issue is we have no web dev skills at the moment and coming up to speed with it is taking a bit longer than I thought. We have our test DB open on our FMS15 server with the PHP extended privilege set, I used the MAMP setup that I found on the Blue Feather website, Introduction to FileMaker Custom Web Publishing (CWP) with PHP | Blue Feather - FileMaker Developer, Android, Web , and internally on the network we have been able to get communication between my local machine and the DB hosted on the FMS15 but now i am out of the office and I can't seem to access the DB. I updated the IP to the external ip, $fm = new FileMaker("Suppliers", "xxx.xxx.xxx.xxx", "PHP User", "xxxxx"); but I get this error, Communication Error: (22) The requested URL returned error: 503 Service Unavailable - This can be due to an invalid username or password, or if the FMPHP privilege is not enabled for that user. The only thing I changed was the IP address, so I know the details are correct.

 

If my understanding of FM PHP API is correct, once we can get this working, then we just need to send the php files to the web developer and he can add it to his side and we should be 50% of the way to the solution we have in mind.

 

Also do I have to open ports 8998 on the server firewall?

 

Seeing as we are still learning web dev skills, should we go the PHP route, or should we rather investigate JSON or REST? Or am I getting the technologies confused?

Outcomes