Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 4 of 4
  1. #1
    Forum Member
    Join Date
    Jan 2017
    Posts
    20
    Location
    Kathmandu, Nepal
    FileMaker Pro Software
    FileMaker 14 Advanced
    OS
    Mac
    Skill Level
    Novice
    Last Post
    04-28-2017
    Local Date
    11-23-2017
    Local Time
    07:01 AM
    Last Active
    09-01-2017

    Filemaker PHP API - Creating Records

    I have my filemaker solution hosting in a filemaker server. I want to use a php script to fetch some data from my database and then create some records.

    How can I connect a php file with the filemaker solution hosted in filemaker server?

  2. #2
    Good guy doughemi's Avatar
    Join Date
    Apr 2005
    Posts
    1,280
    Location
    Middleport, NY USA
    FileMaker Pro Software
    FMPA 14
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Last Post
    11-07-2017
    Local Date
    11-23-2017
    Local Time
    08:01 AM
    Last Active
    11-23-2017
    Much more information is needed.

    What kind of data is being transferred?
    Where is the data? your website? Some other website?
    Your description does not make clear if the data is being brought into the database or sent out of it.
    What will cause the data to be transferred? Script? Some external trigger? user click?
    Give the gift of life. Register as an organ donor today!
    http://www.organdonor.gov/becomingdonor

  3. #3
    Forum Member
    Join Date
    Jan 2017
    Posts
    20
    Location
    Kathmandu, Nepal
    FileMaker Pro Software
    FileMaker 14 Advanced
    OS
    Mac
    Skill Level
    Novice
    Last Post
    04-28-2017
    Local Date
    11-23-2017
    Local Time
    07:01 AM
    Last Active
    09-01-2017
    What kind of data is being transferred?
    The data will be single record which will contain text and date fields.

    Where is the data? your website? Some other website?
    The data is in my website.

    Your description does not make clear if the data is being brought into the database or sent out of it.
    The data will be sent to the database. However, before sending the data the php script needs to check some data from the database.

    What will cause the data to be transferred? Script? Some external trigger? user click?
    It's with a cron job in the php website.

  4. #4
    Good guy doughemi's Avatar
    Join Date
    Apr 2005
    Posts
    1,280
    Location
    Middleport, NY USA
    FileMaker Pro Software
    FMPA 14
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Last Post
    11-07-2017
    Local Date
    11-23-2017
    Local Time
    08:01 AM
    Last Active
    11-23-2017
    First, download and read the FileMaker Server 14 Custom Web Publishing Guide..

    Then, prepare your database:
    1. Create a php user account and privilege set. Make sure that "Access via PHP Web Publishing" is checked in Extended Privileges. For best security, limit privileges to only those layouts and fields that you will access via php.
    2. For best performance, create layouts specifically designed for php. Include only the fields which php needs to access.
      Remember that the PHP API does everything from the context of a layout, not a table or TO.

    Get the FileMaker Class from Library/FileMaker Server/Web Publishing/FM_API_for_PHP_Standalone.zip. Install these files on your webpage server. The FileMaker folder must be in the same directory as FileMaker.php.

    Write your PHP script
    1. Establish a connection between the script and the database (pg 70 of the CWP Guide).
    2. Create a found set (pg 75).
    3. Retrieve the records in an array and save the fields in another array (pg 79).
    4. Perform necessary operations and calculations.
    5. If necessary, create records (pg 68).
    6. Set fields as required.
    Give the gift of life. Register as an organ donor today!
    http://www.organdonor.gov/becomingdonor

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating New Records in Table
    By jloswald in forum FileMaker Pro 9
    Replies: 0
    Last Post: 12-11-2009, 05:34 PM
  2. Question about creating records
    By Bortoth in forum FileMaker Pro 9
    Replies: 1
    Last Post: 07-29-2008, 10:50 AM
  3. help with creating records
    By forbade in forum FileMaker Pro 8.0
    Replies: 1
    Last Post: 04-01-2006, 04:06 AM
  4. Creating related records
    By MrEase in forum FileMaker Pro 7.0
    Replies: 0
    Last Post: 01-18-2005, 05:23 AM
  5. Creating new records
    By Taff in forum Older Versions of FileMaker Pro
    Replies: 3
    Last Post: 01-07-2003, 10:11 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.