7 Replies Latest reply on Jul 3, 2014 8:43 AM by philmodjunk

    Publishing a DB - IWP, Web Direct or PHP?

    jlambert

      Title

      Publishing a DB - IWP, Web Direct or PHP?

      Post

           Hi,

           We're examining solutions to publish a Filemaker Pro 13 and a Filemaker Pro 12 database to the web so that users can access, edit and add records. It has been suggested that we use custom web publishing with PHP to accomplish this, but is there any reason why PHP should be used instead of IWP (Filemaker Pro 12) or Web Direct (Filemaker Pro 13)?

           Unfortunately none of us have any PHP experience, so if this has to be the solution it could cause quite a few headaches (and a lot of learning!).

           Any advice is greatly appreciated.

           Thanks,

           James

        • 1. Re: Publishing a DB - IWP, Web Direct or PHP?
          philmodjunk

               Presumably, the key differences are cost and capability. IWP is no longer supported in FileMaker 13 so you are setting yourself up with a technological "dead end" if you use that option and IWP is quite limited in what it can do compared to a full up FileMaker Pro client.

               WebDirect reproduces that "FileMaker Pro" interface in your browser much more faithfully, but it requires that you use FileMaker Server, a much more expensive application to purchase.

               PHP thus might avoid those issues, but also requires that this be set up by someone that is very familiar with PHP.

          • 2. Re: Publishing a DB - IWP, Web Direct or PHP?
            jlambert

                 Thanks for the reply. The customer we're setting it up for is actually already running FM Server 13 so that won't be a problem. So my question really is now narrowed down to whether there are limitations within WebDirect that there aren't with publishing via PHP? Bearing in mind all the web users will be required to do is view, edit and add records.

                 Cheers,

                 James

            • 3. Re: Publishing a DB - IWP, Web Direct or PHP?
              philmodjunk

                   I would think that simple view/edit/add tasks will be far quicker and easier to set up in WebDirect than with PHP. Please note, however, that I am not speaking from personal experience, just from my general knowledge of how these two approaches work.

                   With WebDirect, you can simply set up your FIleMaker layout and scripts like it would work for FileMaker clients and then "publish" it to the web. (There are some limitations here compared to using a FileMaker client, but are much more modest than IWP or PHP)

                   In PHP, you have to write a lot of code in HTML and PHP to accomplish the same result.

                   But please note that WebDirect was not certified to work with FireFox so this can create issues for some users.

              • 4. Re: Publishing a DB - IWP, Web Direct or PHP?
                jlambert

                     That's what I thought, for what the end users need to do it seems overkill (and an unnecessary hassle) to bring PHP into the equation, I just thought maybe I was missing the reasoning for why PHP was suggested as the way forward, but I'll put that down to the end user not being aware of FM Server 13's capabilities.

                     Thanks for your input in this, it's saved me a lot of time and effort yes

                • 5. Re: Publishing a DB - IWP, Web Direct or PHP?
                  philmodjunk
                       

                            but I'll put that down to the end user not being aware of FM Server 13's

                       When the end user provides the consultant with technical advice, you've definitely got things "___backwards". After all, you are supposed to be the expert and they are hiring you for your expertise. It can sometimes take some real tactful communication on your part to steer them to the solution that is in their best interest. (Years ago a client directed me to make my (relational filemaker pro 4 database) project "more relational". After asking a few questions to get clarification, it became obvious that he'd tossed out a buzzword without any real understanding what that term meant...)

                  • 6. Re: Publishing a DB - IWP, Web Direct or PHP?
                    jlambert

                         We suggested using IWP/WebDirect to the customer, but he had been told from another source that PHP was the way forward and insisted we went with that solution, he is after all the one that is paying for it. As none of us have any experience with PHP we wanted to know why this was the preferred method he wanted (he was going on advice from 'a computer-savvy friend', but now I have good reasoning to steer him away from the PHP solution, and let him know that WebDirect will do exactly what he needs it to and with a lot less cost involved.

                    • 7. Re: Publishing a DB - IWP, Web Direct or PHP?
                      philmodjunk

                           Exactly. And the "less cost" factor might easily be a power of ten here.