Custom Web Publishing

Hi again! Another easy one for expert! I can change the sort order of the summary.php page by changing the « Ascent » parameter to « Descent ». The problem is that records are sort correctly by date (most recent to last), but inside a date section, the are sort by least recent first. In other word, all records that share the same modification date appear in the reverse order. I guess I should implement a timestamp field in my DB. But I need help to sort with two fields at the same time in order to get this working properly... Any clue on the php code I should add in the summary.php file? Martin

Hey y'all, I've a got a relativey simple database working online with API for PHP. I have a connection file, which creates the FileMaker object, fairly basic stuff - but the problem is the username and password are embbeded in this file. I would like to query the database from another server, I can use cURL to post on the username and password from the other server to the FM Server, but its not very secure. Does anyone have any pointers how I can achieve passing credentials from another machine to the FileMaker server without compromising security. I'm trying to use FileMakers API for PHP without the use of plugins if possible. I was considering SOAP but not s…

Hi Guys, I'm planning on sharing some users data from a sql database within a FileMaker solution I'm building. All of my tables for this solution are in FM and I've been able to access the data on the layouts relatively easily with the API for PHP. However I now need to access this external sql db, if I create a ESS connection to the datasource and attach that dataset to a FM layout, can I use the api for php to query this data? I've not used ess, Im on FM Server 11. I really don't want to do import/export, would be interested to see if anyone has achieved this? Thanks

Hello, I am working on a solution for my boss. He wants to be able to take all of the data from a large SQL Server 7 database, put it into one FileMaker file (for ease of viewing) and be able to load it all onto a USB stick so he can take it to go. Ordinarily, ODBC shadow tables would be the way to go, but we have no external access (from outside the building) to our network/databases for security reasons. I have written a PHP script which iterates over each table in the database, retrieves all the records, and uses the FM PHP API to stuff it all into like tables in a FileMaker database. It works, but in my test case, I have only a handful of tables over 50,000…

I feel I am cheating a little bit asking this question on this forum that does not involve FileMaker but I trust you and your responses. I am doing some volunteer work and we are looking to move our web site from Google to another site that will allow us easily to do somethings we have not done or had to struggle to do. Multiple Bloggers (user enters their own) Articlles Video Easy to change layouts Events Changing images Coding can be used to customize It would be nice to have form capability. Not required This is for a group I am involved with concerning Anti-Human Trafficking.The website is the window into the organization and important to get it right (an…

I would like to perform a search on a DB served and created on a FM11 Searcher using the PHP site setup tools. This web site I would simply like to search the field “NT” for values of say 120. I expected something simple like: http://lgdfm3.ncifcrf.gov/bic/BIC%20Circos%20Database%20Table/recordlist.php?NT=120 But alas I seem to have too high expectations and it seems like I will have to build a form php page to perform a search via a URL?

Let’s see if I can explain this in a coherent manner. I am displaying fields in a table view of records in a php webpage. I need to hyperlink the values in the table with calculated values using other field values. Is this possible? And example of part of the code is: ... <?php $recnum = 1; foreach ($records as $fmrecord) { $record = new RecordHighlighter($fmrecord, $cgi); $rowclass = ($recnum % 2 == 0) ? …

I have a client with a solution they have been using for many years which uses Custom Privileges for Record Access to control which records users can view and edit, which has worked well for them. They now want to give users access via the web so I'm working on a PHP website for them. One potential stumbling block is how the custom privileges are implemented - the OnFirstWindowOpen script sets some globals based on their user record, which are then referenced by the custom privileges record access calculation. For example they have a field in their Users table for the "account group" the salespeople belong to, on on startup this is set into a global field. The calc fo…

Hi Is it possible to publish a filemaker 11 database on a linux host and allow other users to use it like in windows, I was going to use it for a club record system but if not will think again. If yes is there a dummy's guide. Thanks

Hi Guys, I'm trying to load FileMaker results from a find query in a session variable so I dont need to do the query again when I want to use the same results. However when I print_r the Session variable - I get the reults but all wrapped around __PHP_Incomplete_Class Object . I've been told that I need to include the class before I write the session, but Ive included the FileMaker.php class and I still get the same __PHP_Incomplete_Class Object returned. any ideas Thanks

Sorry if I'm missing something here... Our website PHP server has just been upgraded to 5.3.x We have used FMStudioPro to help us connect the website to an FM database for the last few years however we are now getting multiple messages similar to: Deprecated: Assigning the return value of new by reference is deprecated in ../FileMaker.php on line 138 Deprecated: Assigning the return value of new by reference is deprecated in ../FileMaker/Implementation/FileMakerImpl.php on line 98 Etc... I know that these are just warning messages which I can turn off in php.ini, however was wondering if there is a newer version of the Filemaker PHP API. The fi…

Hi to all. i have a php page that gives me all company names. I what to have all of the branches in a table in the bottom of the page. this is the php code. thanks dani <html> <?php // Include FileMaker API require_once ('FileMaker.php'); include ("conect.php"); $record = $fm->getRecordById('web Main', $_GET['recid']); if (FileMaker::isError($record)) { echo "<body>Error: " . $record->getMessage(). "</body>"; exit; } ?> <head> <title><?php echo $record->getField('Company Name'); ?></title> <!-- declare charset as UTF-8 --> <meta http-equiv="content…

Hi, We're new to File Maker, so we're still unsure the best way to handle this. We run a spa and we have our employees follow our guests during their week with us. Our employees carry i-pads and record certain data and images on our File Maker Pro 12 database. We also have an online PHP/MySQL website with database that all of our employees can use remotely. What we hope to achieve is that when our employees record certain data on their i-pads, the File Maker software communicates that data to a PHP script on our remote website (via XML, POST, etc), and our PHP scripts on the remote website handles the data from there. Any advise is appreciated. Thanks,…

Hi All. Very humbled by fm so far. Converted a Bento database/template to fm which seemed easy enough. After uploading the file to our fm hosting service and attempting to log in (for IWB use), we received the 'classic layout required' error message. Is anyone familiar with what has to be done to convert a typical Bento-generated layout to FM 'Classic Layout'? -Couldn't find any options or documentation on this anywhere. I would prefer not to have to recreate the entire layout. Help so appreciated!

Hi, I have a large database in FM12. I need to provide scalability and future proof the development in the middle term, without loosing the fast adaptability and development of FM. I was thinking in using MySQL as back-end and keep using FileMaker as front-end, ensuring RAD when needed. Is there any way to do this without the need to reprogram or recreate the DB in MySQL and/or reprogram the FM DB? The idea is to find a simple path for this task, if there is any. Thanks

I am trying to echo a filemaker text field into a php page. Inside the text field are additional php echo commands that I want to use to customize the presented text for the current user. The echo of the large text field works, but the echo commands that are inserted in the larger text field are presented literally and not executed. Can anyone help me with this? Thanks.

I have this: $findCommand->addFindCriterion("Date of Birth","8/12/1982"); and I get this: Error: Date value does not meet validation entry options I am running out of ideas as to what the problem is. Server is remotely hosted V12 Cheers Brian

Dear All, Unfortunately I stuck in a solution, that, how can we copy a image stored in a container field into a folder, I am able to display the image in the web page using. But whenever I am trying to copy the displayed image into one of the folder in webserver. It is giving no result. So, please help me in this task. I am in hurry, Please let me know, if anybody know that. Thanks in advance....

Greetings, I am trying to show portal records from a related table with the PHP API, however it doesn't seem tob e working. The layout is created with the portal and showing data within FMPro, however the next piece of code doesn't return any rows: <?php // Tabs superiores de las pruebas $findCommand =& $fm->newFindCommand('Pruebas'); $findCommand->addFindCriterion('UID_Evento', $_GET['uidevento']); $result = $findCommand->execute(); // Get array of found records $records = $result->getRecords(); // Print out found records // Setup row count variable to alternate row background color $tab = 1; foreach ($records as $r…

Good day. I work as a tech writer for a mid-sized manufacturing company. I write and maintain our manufacturing procedures in an intranet, using .ASP files. These web pages are not using any ASP functionality for now (for some reason) but since all of the links are as "ASP", I think I might as well go with that engine. We have been using Filemaker Pro (11) for recording various aspects of the manufacturing process, and I want to be able to access (input into) the database through our intranet web files. Many of our PCs have been upgraded to Windows 7, but many haven’t done so yet. I have been using Microsoft Expression Web lately, but I have Dreamweaver CS5…

I have stored lots of files in container field. Is it possible to download files (such as PDF)stored in container field using PHH API?

Hello, We are trying to make a FMP 11 combination to display a list of records that are only open status. We made a php site with the php site assistant. Now we want to add to the lsit the option to only show the open records (open in meaning the status is open) When we try to add this : $newPerformScript = $fm->newPerformScriptCommand('FMLijst', 'FMLijst'); $result = $newPerformScript->execute(); when we add this (layout is FMLijst, and scripts is called FMLijst. The list stays long. There only 4 records with the status open. We want to have the control thats why we want to do with a script. What do we do…

Hey all, I have been tasked with a little bit of a problem. PHP is not my primary language, so I'm getting up to speed, and I know little of FileMaker. I understand I need the FileMaker.php and related folder containing the API. I have verified the permissions on Filemaker. i.e. Extended privileges, FMPHP assigned, etc. I have db name, username, password, db server I wanted a simple script that tells me yes/no I am connected to a database. Something like: 1. setup connection (with FileMaker.php require once) 2. Echo yes/no, I am connected to the database, show error info if "no" I searched the forums, and google and have not found some…

I am a new hand in PHP API. I want to play sound files on the web from container fields (say Sound_A) of filemake database. I only know the use of echo $fm->getContainerData($_GET['path']) which displays an image on the web. Does it work on audio or video files as well?

Hello, I need to share a few databases and I understand the concept of the Filemaker Network and have already set it to share. But, I can't seem to be able to access these files from the outside (of the network). I have the IP, but I think it has to do with the router and/or modem. Has anyone any experience setting up a router or modem so that someone from the outside (of the network) can access these files? Thank you.

I've never worked with an SSL Web Server/site before. We've got the SSL setup with Apache on Mac OS X, now just trying to get the web site which uses the FM PHP API to work. Having never done this before can anyone who has fill me on what steps are necessary to get the web site communicating with the Web Publishing Engine? thanks, Steve

I'm building a web-based intranet portal that will include the ability to open FileMaker databases using the fmp7 scheme (fmp7://serverIP/database). Is there anyway to trigger a script on the target database via this mechanism? On the current FM-based portal, I have a couple of buttons that take users to different parts of the same database, and I'd like to replicate that functionality from the web-based one if at all possible. Thanks in advance, Kevin

Hi ! Sorry for my english, I come from Switzerland and I search help for a connexion between my Windev Mobile 17 application and my Database FM Pro 12 advanced hosting in my FM server 12 (not advanced). I would make this connexion with FM Web Publishing PhP because FM isn't a native database for Windev. Two scripts for a connexion between a MYSQL Database and a Windev application exist but I want to adapt these scripts in FM language to make this connexion. I hope that you've understand what I search and that you can help me Thank you and sincerly, Bastien_CH wd-bd.php wd-injection-sql.php

I am moving a few solutions from XSLT to PHP, but need some example code to get started. I have moved a couple solutions where I include an access.php file on each page, but in this solution I would like to request the user provide a user/pass... I know I could create my own form to capture the credentials, but I was wondering if anyone had some code for doing it via HTTP Auth (preferably digest).

I am developing a database in FMP 12 because the content is rather dynamic and I plan to use many desktop capabilities of FMP. However, the whole idea is to publish it on the web. This question is about whether my strategy - as described below - is wise. I plan to master FMP to a degree and build a layout (using Classic theme) that emulates the final web page design as much as possible. I plan also to build a web page in a Mac program called Freeway, something I know how to do. If this were a PHP/mySQL project, I would need someone to do some heavyweight coding to build elements. My supposition is that I can find a FM hosting company (probably ODITech…

I'm having a problem where the result of the find commands I execute using the PHP API returns just one record over and over again. This has happened both in the tutorial questionnaire and in my own custom web application. For example, the questionnaire asks "On a scale from 1 to 5, how much did you learn from this tutorial?" The page provides 5 radio buttons to choose from, but they are all labeled 5. Similarly, when I query use my web application to query a database of publications by title, the result returned is the information for the same publication repeatedly. Here's a block of code: $find_command = $fm->newFindCommand('Info for website'); $find…

Just a week away! Please note the NEW ROOM: Flicker 1-2 -------------------------------------------------------------------------------------------- CWP USER GROUP AT FILEMAKER DEVCON 2012 For the sixth straight year, people doing Custom Web Publishing are getting together at the beginning of the FileMaker Developer Conference to share projects, tips and ideas. This year's DevCon has only one (only one!) regular session that addresses CWP, so come get your CWP groove on at this year's CWP User Group meeting. DATE: Monday, July 16 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Flicker 1-2 <<= New Room This will be a friendly, i…

I've done some PHP development but I'm far from expert. Right now I'm attempting to setup a file were instead of going straight to the data file for the table occurrences and layouts I'm creating a new file where I want to create all TOs and Layouts specific for PHP. Everything seems to be working except for one (kinda major issues) no data displays. is this even possible. I've attempted some additional testing and data stored in a local table and layout loads right way in PHP. So can a 2 files system be used in this way for PHP?

Hello everyone, We have our database webhosted by Foxtail Tech, but we will occasionally need to access the database in locations with no internet access (gasp!). If I were to download a back-up of our database, and place it in Dropbox, would another single user be able to access that file as a read-only file? We would not be making any data-entry or edits to the Dropbox file, it would be solely used as reference material (so there should not be any file conflicts). Does anyone know why this solution may or may or may not work? I know that Dropbox is not a sustainable solution for sharing a FMP db, and that is not what we are doing. We do have a dedicated webhost, …

Hi Guys, We're in a windows environment and I have a login screen which users authenticate against a filemaker account. I was wondering whether anyone has integrated Active directory and single sign on in a php environment, and how they did it. The servers and clients are all in a Windows. Thanks

FileMaker Server Advanced 12 Windows 7 PHP 5.3.x If you use getLayout you'll get a wrong result concerning the field data. The field list is an associative array with right keys and wrong contents. Each element contains the data of the last field of this layout. Knows anyone any workaround? It is important to me to get more data than the name of each field (layoutObject->listFields). Thanx Dr. Surf

Hi Folks I'm creating an export function for users, where they can choose (over an website) a layout and then appears a list with all fields inside this layout. The user now chooses which fields he would have in the export. The problem is the listing of the fields seems to be random. Is it possible to influence this order? An example: I have a layout with data of clients like name, phone, adress, email etc. So I get these fields with the getFields() function. But I like to have them in a certain order, so when i get the single fields out of the array in the order of: Name, Adress, Phone, Mail etc. Thank you very much for your help!

I have a script on my server that sends bulk emails using the ScriptMaster Plug-in. I currently have a schedule that runs this script every 10 minutes (checked for messages to be sent, and then sends them). The script is set to run with full access privileges. In the interest of cleaner log files and to give the user more control, I wanted to give them button that would simply open URL to a php page that would run the script, but it doesn't seem to be working. <?php include("FileMaker.php"); include("../includes/functions.php"); $fm = db_connect(); //note: it doesn't matter which layout is used $layout = "phpEmailBulk"; $script = "SERVER - s…

I have a single form that asks a person to answer questions (name etc) and upload a file to the server using <input name="PDFname" type="file" /> Works Beautifully- when the information and file are uploaded successfully the user gets the message echo ($file['name']. ' was successfully uploaded to the server' I don't know how to get the name of the uploaded file into Filemaker. Any suggestions are welcome! I think it should be simple. From my reading I think I have to join the information $_FILES['file']['name'] from the $_FILES array with this // get the submitted record data $recorddata = $cgi->get('recorddata'); if (isset…

I am looking for specific FMP help on connecting FMP to Web db systems like forms, and polls. That provide API keys and have enabled the API method. This has NO php element at all. I simply am trying to find info on what currently exists out there as I can't find very much at all ! The FMP database will not be served, it will only be run from time to time and then it will bring in the data thats outstanding at that time. Any help most welcome. g

Hi all I'd really appreciate some help - I have no more ideas how to solve this. I had a php layout showing individual records and four associated portals - all working fine - from FM layoutA. I then created FM layoutB and a corresponding php layout, showing the same individual records but some new portals (for which I created new fields in FM). The records show, but I am completely unable to get these new portals to show through PHP - it returns an 'Unknown Error'. The php layout (and code) are fine. If I substitute a fieldname for one of the old portals it works. Permissions are not the issue - I've tried with admin level access. The table inst…

CWP USER GROUP AT FILEMAKER DEVCON 2012 For the sixth straight year, people doing Custom Web Publishing are getting together at the beginning of the FileMaker Developer Conference to share projects, tips and ideas. This year's DevCon has only one (only one!) regular session that addresses CWP, so come get your CWP groove on at this year's CWP User Group meeting. DATE: Monday, July 16 TIME: 4:00 - 6:00 p.m. (before the 6:30 keynote) ROOM: Splash 1-4 This will be a friendly, informal chance to share some of what we have been doing with FileMaker and CWP. All web-related tools and technologies are relevant. This year we may see some FM12 media streami…

Is there any way to update ones twitter status from within filemaker?

I have a site which uses FileMaker accounts to access the site and everything is working well. I now need to give users the ability to be able to change their passwords via the site. I know there's no native method for this and FileMaker Inc recommend that "By default, web users cannot change their account passwords from a web browser. You can enable this feature for a database using the Change Password script step, which allows web users to change their passwords from browser.". I can use newPerformScriptCommand to perform a script that has the Change Password script step - I'm just not sure how to pass the value for the "current password" and "new password" which w…

Dear All, Please help me... Whenever i am trying to connect to a layout of FileMaker Pro 12 Advanced using FMPHP. I am getting the following error. I am using FileMaker Server 12 Advanced and FileMaker Pro 12 Advanced. The error is: Communication Error: (22) The requested URL returned error: 401 - This can be due to an invalid username or password, or if the FMPHP privilege is not enabled for that user. Everything is enable in Priviledge sets options. The same thing is executable on FMS 11 advanced and FM Pro 11 Advanced. But here it is giving the error. I am using these lines of codes: $fetchData=$fm->newFindCommand('List_View'); *$r…

Dear All, Please help me in getting the information regarding FM API for FileMaker Pro 12 Advanced and FMS 12 Adv. Has it been changed for FM 12. Because I am unable to connect with the database. If it is changed, please let me know about the URL from where I can download it. Thanks in advance...

This one's got me stumped. In my database, I have a text field that I use as a flag. When a user requests the record (currently done via IWP), their name is set into the field to prevent other users from entering the same record at the same time. This has been working well for the last couple years. However, now I am trying to do the same thing via CWP. Here is a snippet of the code I'm using. Please note that this page is called via AJAX, so I can't get feedback about things by just using echo. As such, I wrote and included a little WriteToLog page that can spit out any text I need to a text file. include_once( "WriteToLog.php" ); $user = $_POS…

Hello, im new to the world of filemaker and would like some help/tips with my setup. FMS is running on a windows box and i would like to be able to connect to that with the Filemaker PHP API from another external webserver (debian, apache2). As i understand it i need to enable the webmodule on the filemaker server and this needs IIS for some reason? How do i go about doing this? IIS is allready installed on the same server as filemaker, but when i run the setup, it tries to connect to that server for some reason but is unable to. If any kind soul could put me on the right track i would be forever greatfull as there is not alot of information on this parti…

I need to add IMAP support to my install of PHP 5.3.6 installed by FileMaker Server. I found these step-by-step instructions: http://www.september28.co.uk/blog/2011/11/24/php-imap-support-in-mac-os-x-lion-without-recompiling-php/ I think I can follow those steps but I barely understand the process and I'm wondering what changes (if any) need to be made to those steps given that my install of PHP is in a non-standard location (because it was installed by FileMaker Server)... The php.ini file is here: /Library/FileMaker Server/Web Publishing/publishing-engine/php/lion/lib/php.ini Can someone make this easier for me?;-)

Dear All, I would like to perform the task to store and retrieve the videos into and from FileMaker through Webcams (online Video streaming), like CCTV camera in the office or school like that. Please help me in achieving this task. Thanks in advance...

I got my php server and fms12 working find. PHP server returns <?php echo "hello world" ?> just fine and filemaker server 12 is running with clients no problem. I can't seem to get the FMS12 to respond to my code. I keep getting fetal errors. My config: Win2003; FMS12; IIS&PHP; FMS12 enabled CWP w PHP; Yes, Extended Security set to allow Php connections. Below is the test file I want to connect to: $server=192.168.0.1; $file= a.fmp12; $layout= php; // this is the layout that has the fields $field="id"; $user="admin",$password="" the above is not the code I ran, but i am hoping i can get a sample because my code is producing the fo…

Hello, I am working on FileMaker web site, I like to add new feature to password resetting for our clients, This is how it should works and it works now. How it works, Operator will create user account for client and send the login details via email(using FileMaker pro app) Client will use this login details to login to system via web browser. (this is table based login) How it should work: In case client can not login to system there should be alternative option that user can reset password . i am trying to add security question in middle of this operation. does any one have experienced this ? or any other better idea ? Thanks for your time…

Hello, I am ready to install FM server advanced on a Windows 2003 server with Moodle, Hesk, and Wordpress already running and configured from this server. My question is when I install FMS will it destroy my current PHP setup with the existing applications? Should I choose run PHP from and existing configuration. I do not want to ruin my current server configuration.. Thanks for you help...

hello everyone, we are looking into having our database hosted on the web. before i do that, i want to figure out how the scripts we have will function. we have scripted buttons that allow you to click to automatically open skype and dial the number. we also have scripted buttons that create emails with attachments in the user's default email client (outlook). Will having the database hosted on the web mess any of those scripts up? Or will it behave as usual when the db is opened as a remote file? i'd appreciate any advice.

Hi guys, I'm fairly new to FM and I have a few questions to ask. I'm developing a small database for the company I work at and I was wondering what's the best solution I should come up with. This database has been (and is still being) written in FMpro11 advanced and should be used by 4/5 persons. Shall each person who uses the database buy a license as well? Maybe a FMpro11 license per person is enough? Which is the most convenient way to share my database with my collaborators? I guess it should be hosted online to get "optimum syncing", am I right? (I see a lot of referencing to IWP and other ways to share your database but it's a bit of a mess and I'm confus…

Hi... I want to host my filemaker database with a selected host company...but i was advice to incorporate my database with php so that it would be accessible via web browsers/....i don't want to rebuild the database...any suggestion what i can do.... If i host the database without having it written with php...would users not be able to view the database via web browser... Thanks

Im working on the filemaker server 11 on windows server 2003. Now i have planned to develop the php scripts and need to install it.. Before im going to install the php, I would like to know the recommended and minimum required IIS version for filemaker server 11 for the windows os "windows server 2003" Please advice me someone.. Many thanks in advance....

We are thinking about moving our FMP db to being web hosted; currently we are just using it on our local machines. Problem is that one of our users does a lot of travel to areas where there is (gasp!) NO Internet. So, we want to be able to use the Database offline, and then upload the changes when we have internet access again. I've been looking into GoZync to sync the versions uploaded to the server, but haven't been able to get any responses from SeedCode about how this will work, and specifically if it works without FilemakerGo (which we don't use). Does anyone have any other ideas about how to approach a solution like this? Or anyone have experience with GoZync t…

Hi everyone, I find myself in a bit of a predicament with the Filemaker PHP API. I'm running some rather complex Filemaker scripts via the PHP API and need to be able to communicate a message back to PHP depending on various circumstances. It's imperative that I actually retrieve this 'string' back, since it's not necessarily a Filemaker Error, just a set of conditions that have not been satisfied. I'm aware that you can't use an exit script step to send a Script Result back, and have tried a few alternatives mentioned on the forums about using a Global Field whose value would be passed back... However, in many cases, the script is checking up to 5 differen…

Using 'store only a reference', I have put some files (references) into container fields. Some of the documents are on the local machine, some are on a mapped drive on a remote server. Access via Filemaker Go works fine. Access via Filemaker Pro is inconsistent. On some machines it works, on others nothing happens when you double click the field. Mac/Windows both work and don't work. Local Machine, LAN, WAN or remote server works and doesn't work. Any suggestions?

We have a solution that has been working well for a couple years now. It's related to students submitting scholarship applications, the use is kind of 'seasonal' not hit year around. This year we've noticed an issue with some fields only being partially complete. It's not just one field it happens across many fields. Example, "PO Box 123" we only get "PO" or "North City" we get "North" since we only get the first word, I checked to make sure Filemaker wasn't doing anything on the back end with a Trim and nothing. It really seems to be coming from form submission. Also it doesn't happen on every record. It seems to be a bit random. Is anyone aware …

Hi All. I have recently created a script which should be passed an IP address of the users FM DB Server location, then the script will connect to that server with the given username, password, IP Address and DB Name. However, no matter what I pass as the IP, it never throws an error. Is there some form of error handling within the FileMaker PHP API for connection errors? Thanks in advance!

Hello all, Just curious, has anyone integrated CodeIgnitor (or one of the other PHP Frameworks) with the FileMaker Api for PHP? I'll be working on a new project and wouldnt mind using a framework like this to see what its like, I know there is some more of integration between the fx class, but I havent seen anyone use the API for PHP with these frameworks. Thanks Jalz

Hello everyone. I've struggled with slow responsiveness between PHP and Filemaker for ages now, and I think I've finally found out why. Scripts run infinitely faster than the PHP Filemaker API for record creation. Using the PHP API, it takes 29 seconds to create 50 records. I can create 250 records in a script in under 1 second. So, obviously, I'm in the process of porting all my PHP API calls to use Filemaker scripts. But, there is one problem. How do you get a response from the Filemaker script back to PHP? e.g. Creating a new user. User enters his email and password into a PHP form, then the PHP calls a Filemaker script to create a new user. But, if the …

I am wanting to publish an innovative Games database for teachers, not too complex but eventually well used by many users around the world. I am confused as to how many connections I can have with FM, FM Advanced, FM Server and FM Server Advanced. I see 250 limit for Server and unlimited for Server advanced, but is that local area connections or IWP? Could Filemaker effectively handle an online web database with a thousand connections, of course with high-grade hardware and optic fibre upload speed? Thanks so much for the heads up.

Hi everyone, Intermediate FM and PHP developer here. I've got a PHP document called contacts.php. It sends user input via PHP POST to another PHP document called contacts_submit.php, which then sends the posted data to my FileMaker database. This works just fine, except when an ampersand (&) is included in any of the users' inputs. For example: I have a field called ApplicantOrganization. If on contacts.php, they enter: then that input is saved into my database exactly as entered, no problem. If, however, they enter: then my database receives: (I've tested PHP POST in isolation, and ampersands are sent just fine from one PHP documen…

I have setup through the PHP site assistant to be able to fill out a questionnaire online and the info submitted is entered into a new record, then the same info is emailed to me. About a month ago this process was working perfectly and now I was going back in to finish one last thing and come to realize that when I hit submit it sends me blank emails. But when I go into my database the information is there in it's own record. And when I run the SMTP Email Script from within the database it will then email me the all the information in the record. I have created new forms, pasted in old code that were back when it was working and nothing seems to get it back to the point …

I am experienced with both FileMaker and PHP, but I am new to the FileMaker PHP API, and I'm trying to find the easiest/best way to implement a sort of web service. I have a FileMaker script that currently does most of what I need, but I need to run it via the PHP API. A remote server submits a single http request with several variables to the FM web server, including an ID number. These values are stored in global fields in a FileMaker table. A FileMaker script then retrieves these values from the global fields, and searches the table for an existing record with the same ID number. If there is no record with the same ID, a new record is created and populat…

Hi, I'm building an application that receives user-submitted data from a php form, then emails a receipt to the user and a report to an address outside the organization. The emails get sent by a script called from php on the form's submit page. For one of the emails, some content and the recipient's address are stored in a related table in a separate file. Both the application doing the emailing and the separate file with the addresses are on Filemaker Server 11 and both are enabled for php via the guest account. The problem is that any data, including the recipient address, that lives in the related file does not seem to show up when the script is calle…

I have a situation where users see projects they are assigned to. Multiple users can be assigned to multiple projects so I'm using a join table. Currently, using web publishing users are able to see all their assigned projects in a list view that gives basic details of the project. I do this by using a search for their user on a join table layout. To see specific project details they click a link and the website takes them to a detail page which is found by doing a search on a project layout for the specified project. To go to the next project they have to go back to the initial search results screen (join table layout) and then click the next project. The use…

Hello Everybody, I'm in the process of purchasing FM Server and setting up custom web publishing via PHP or XML. As I understand there are three engines that can be on three different machines: 1. The database server (which I am about to purchase), 2.) the web publishing Engine and 3.) the web server. I am hosting our website via godaddy, so would it be possible to have the database stored on the server while I use godaddy as Web server? Even after reading the FM Server and PHP publishing manual I'm still pretty unclear of how the setup would work. Can my ( to be purchased) server function as all three engines? Thanks in advance, Andy

anyone can help me figure up my problem?? i not understand how to use filemaker pro for database and i want uses that database in PHP assistance (filemaker server). or how? please help me..... :hmm:

Hey guys, I'm struggling with getting PHP to trigger an FMP script. I can do everything i want to do through PHP, but I want to leverage the FMP back end. Therefore, I want to trigger a find locally, rather than using PHP, etc. I created a runscript.php page and when I run it, I get the following error: Notice: Only variable references should be returned by reference in C:\Program Files (x86)\FileMaker\FileMaker Server\Web Publishing\publishing-engine\php\FileMaker\Command.php on line 126 Here is my simple code. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <?php session_start(); require_on…

Hi Guys, I originally wrote something like this for work, but I took it home, re-wrote it to work for anybody as long as they setup the config file. It is still in very early BETA stages, but I would love your opinions, recommendations and critisism on it. Here is the download link: https://github.com/DarkMantisCS/FileMaker-PHP-API--Easy-to-Use- The idea is that you don't have to keep creating instances of the FM PHP API, you just create one instance of the FMDB class and you can call all of the custom functions from within there. I know there is no documentation on there atm which may make it difficult for you to actually interporate it exactly b…

Hi Guys, I've got a database which has an external account, called allStaff. This external account is based on active directory and works with FM Clients as expected. I have added the php extended option to this account. My question, is, with PHP I want to connect to this account, authenticate that the user exists and redirect to a page. I know how to do this with a normal filemaker account with a username and password, but am interested to hear from anyone that has done it using active directory OR FileMakers external account. Cheers Jalz

hi forum, Scenario: I have 9 FileMaker files, each of 1 table, related to each other. I have made custom web publishing through PHP. Problem: Performance is very slow over net. Can you all suggest the exact problem?

Dear All, I am working on a project for a photography agency. I have to use SuperContainer to achieve the same task. Displaying image using SuperContainer URL is completed, but I am unable to perform slide show. Actually I want that whenever I click on image on web page which is displaying from SuperContainer URL. The resultant image should be there in slide show. I am working with 8 records at a time but and whenever I click one of the image, the slide show should be started. For example : please visit - http://www.highslide.com

Hello Forum! I have this doubt, may I develop a whole solution using only PHP instead of Filemaker??? Don't get me wrong I been using filemaker the last 10 years and I feel very comfortable with the application but sometimes I think Filemaker needs to be more robust, for the other hand I am new to PHP, I've heard that is very solid and well used for web development, So this is my question why to use an intermediate application like filemaker and it's PHP API for web development if we could go directly with PHP only??? I ask this specific point here in the forum to get a better idea and to know which way to take. Sincerely BluiSh

Hi All, I previously used php 5.2.4 for all the php and filemaker interaction. But when i run the same code in php 5.3.5 server i got lots of errors. My code is --> require_once('FileMaker.php'); $hostname = "localhost"; $username = "user"; $password = "pass"; //DATABASE $database = "test"; $obj = new FileMaker($database, $hostname, $username, $password); if(FileMaker::isError($obj)){ echo 'Error1:'.$obj->getErrorString(); } //For adding a new record and setfield $newRecord = $obj->createRecord('web_tag');//here downloadData is the Layout Name if(FileMaker::isError($newRecord)){ echo 'Error2:'.$newReco…

I have a Filemaker and PHP connection set up.When I try to login to the PHP application i get an error with error code 22 and error description as 'Unknown Error'. The Filemaker version is Filemaker Server 11 and the Client version is Filemaker 9. Does anybody know about this error and how to resolve it?

I have a database that we use on our school district for teacher evaluations. Since we have over 500 teachers, I am hoping we can save on the cost of purchasing FileMaker by creating a PHP web front end to the database. I have everything setup in FileMaker, including authenticating to our AD/OD servers (external authentication). I created the Full Site using the FileMaker PHP Site Assistant, and it is working, EXCEPT… When I click the Edit Record, and make a modification, then click the SAVE RECORD button, I get this error Error: 509 - Field requires a valid value I have even creating a new layout with only 3 fields on it (all editable TEXT fields…

hi guys.... how can i send a picture from webpage to a a image field via fm script. Scenario: when i choose a picture and submit the webpage then, with using fm script how can i insert picture in to a image field. pls. reply as soon as possible.

I would like to use the Autofill feature that is built into browsers. In Safari if you go to a form field that has a name tag like the following: <input type="text" name="FirstName" /> When you start typing your name, Safari will ask you if you want to Autofill the rest of your info. If you choose Autofill it will fill in all the fields that your computer knows (Last name, address, email, phone). The problem is that in my PHP code the name tag has code for connecting to FileMaker, like the following: <input type="text" name="<?php echo getFieldFormName('hh_pt_name_first', 0, $record);?>" value="<?php echo $record->getField('hh_pt_n…

Hi Everyone, We have had a CWP solution running for several months on a WIN 2003 Server. We recently upgraded both the server, OS and FileMaker Server software. On the new machine the FileMaker files seem to be running much better than before, but unfortunately the CWP pages now seem to load in minutes rather than seconds. We moved the php files directly from the old to the new server and have also tried loading "fresh" copies of the php files. Because the CWP files are basically useless on the new machine, we have had to keep the old machine running so our clients websites would still function. Here are the configurations for the two machines: OLD …

hi guys please help me in fm script.... I have created a php file in which i wanted to insert record through fm script... when i submit the web page ..a new record is inserted but variables containing the values in php are not fetched in filemaker script. So, how can i fetch the values that has been posted from webpage in filemaker script. reply soon..it's urgent..

Hi Guys, I have only started working with FileMaker for the last 2 months or so, and I didn't like the way that the API is very procedural driven, so I decided to make a class which would help me. I have got a function which I have made which interacts with the FM PHP API (Official) which I am trying to get sorted. The idea to the whole class is to save time writing each function over and over again, but basically I have got this function which I am having problems with which is to get the FileMaker Layout Fields and Values of those fields and put them into an array. Here is my code: /** * Selects data from a FileMaker Layout from the g…

Dear All, I am working on a project of FMAPI. While working on it, I faced a problem while scanning a folder of the the MAMP server. I am working on a client machine. For example: http://203.129.217.111:8888/KK", this is my server address, and my address is localhost/KK. Whenever I am trying to scan the folder KK of the server, I am getting the error "[function.opendir]: failed to open dir: not implemented" Please suggest me an exact way to resolve this problem. Today is my b'day, and offer me a gift a solution to resolve this problem.. Thanks in advance to you all...

Hi, Does anybody know about online shopping cart solution based on FileMaker and FM PHP API? Can we integrate, customize it with our existing FileMaker database? There are many web solutions with MySQL + PHP, using it involves developing a functionality with ESS to link FileMaker and MySQL database. Thanks.

Greetings, I am trying to revise the generic Filemaker API generated site so that it will be limited to finding and editing one record after a user logs in. The record is found using the user’s login ID which is a field in the database. I have a successful API site build using the full site template. The workflow would be: User log in Clicks a link to display the Browserecord API page Clicks the edit button to edit using the API Edit page and can save Log out What are the steps to revise the API generated site to do this? I would like to create a link on the API Home page to look up the user record and display it on the Browserecord page. It seems th API c…

I'm struggling with making a form I am working with sticky. I have everything working just as I'd like and submitting to Filemaker, I just need to make the radio buttons sticky. I am missing something, in the syntax and it has me stumped. I anyone can point me in the right direction it would be greatly appreciated. This line works. $html .= '<td width="25%" align="center"><input type="radio" name="regcheckin" value="Poor" /> </td>'; This line does not work. $html .= '<td width="25%" align="center"><input type="radio" name="regcheckin" value="Poor"' if ($_POST['regcheckin'] == 'Poor') echo'checked="checked"…

Hello FM Forum, I am new to FileMaker & FileMaker PHP API. I am however a longtime PHP/SQL user. I have a FM Server installed on my network as well as a Linux webserver with PHP. On the webserver I have dozens of PHP applications that access as many datasources including MySQL, MS-SQL, FoxPro, Access, and Oracle. I am surely expecting to have a need to access the FM data at some point. Right now I am teaching myself. I have come upon a problem where I need some expert advice. I have an FM application in which I have created a "Header" layout. Inside of the "Header" layout I have created a "SubRecords". The standard one-to-many kind of relationship. Each he…

Hi, Not sure if this is in the correct place but I am trying to get the foreignID for a mysql table that is used in Filemaker. We have a FM set up that uses mySQL as it data source. We have created a php page that searches the same database. I am trying to work out how I can have a link from the PHP to go to the correct record in FileMaker. The way i thought of doing it was using the snapshot link. If you open one up in a text editor it is simple xml. My idea was to get the php to generate a snapshot file .fpsl and open that file to take me to the correct record. What I am struggling with is setting the correct parameters in the file. The for…

Hi I have a - Centos Linux Server where php is running fine. (10.1.1.240 - Window Server 2008 where Filemaker Server 11 is installed (10.1.1.201) - Database name is bookstore.fp7 What would be the database connection in php? Thank you

I'm a bit baffled by a strange occurrence with my PHP setup. I've got FileMaker Server 10 installed on a Windows Server 2007 machine, and I'm connecting via PHP to it with a Windows machine running Apache (development and testing environment) and a Snow Leopard Mac Mini Server (used for actual PHP publishing to the outside world), Everything has been working fine for a few weeks, when all of a sudden I get thrown Error 22 messages. This happened simultaneously for three different databases, all published via FileMaker Server 10, and all with their own separate PHP code. It also happened simultaneously for both web servers described above. This would suggest tha…

I have a pretty simple php page that creates a new record in a table using the GET parameters in the URL to populate the field values as such: $request = $fm->newAddCommand('WebReplies'); $request->setField('to', $_GET['to']); $request->setField('from', $_GET['from']); $request->setField('msg', $_GET['msg']); $request->setField('userfield', $_GET['userfield']); $request->setField('date', $_GET['date']); $result = $request->execute(); This works well - one of the fields that is being set is then used as a match field in a relationship, and there are a numbe…

I am having difficulty getting value lists to display on my website using the getValueList function. I have followed the formats I found in various forums and blogs. I can get the arrays that are intermediates in the calculation to prints but I cannot get the final results. I have tried two different methods listed below neither giving success. I have also tried to get value lists generated from field summaries and from customized lists. Neither works. What am I missing? The code follows below. I read in a forum that the get getValueList broke in Filemaker 10 and was replaced by getValueListTwoFields. I tried this and it was no better. I am currently using Filemaker…

Hi everyone, I am coming over from the php odbc world. I am hoping that the API will help me to overcome some of the limitations I have been encountering. The most important one being the 256 character return limit. So my filemaker friend recommended the API and even shared some resources with me. I have 2 servers to replicate my working environment - a filemaker advanced server 10 and a windows 2003 server running iis. In addition my friend attended the developers conference in San Diego and brought back some demo files that one of the presenters gave out. Everything from the demo works great! The only problem is when I tried to copy over a snapshot o…

Hello all I'm proud to officially announce my FileMaker & Custom Web Publishing blog: F 'n' web - FileMaker 'n' the web: lessons learned http://blog.jsfmp.com I’ve been developing websites with FileMaker and PHP since 2005 (& with CDML long before that). My first PHP sites were built with FX.php and now I tend to use the FileMaker API for PHP more often. Over time I’ve added more and more tools to my toolkit, especially JavaScript (mainly jQuery) and CSS, and I love keeping up on new trends in web design and development. I've learned some interesting things along the way and wanted to share them. The blog actually launched two mo…

Hello there, I have created some CWP pages for my company and it has been doing great. Recently my boss wants me to changed some of the fields into an optional dropdown menu. I tried to create a value list in FileMaker and the did it this way in PHP: $layoutObject = $fm->getLayout('form_api'); $noheads = $layoutObject->getValueList('nohead'); foreach ( $noheads as $nohead ){ $_SESSION['nohead'] .= "<option>".$nohead."</option>"; } This works perfectly for the valuelists that show all values of a field but when it comes to valuelists that show only related value, it always return the result of the first record. So I modified it and …

Hello, I got tasked with a project utilizing FileMaker.. and my knowledge and experience with FileMaker is *very* limited (so this is also a learning experience for me). There's a FileMaker server located on a box on this non-profits networking (they insist on hosting the database themselves.. no big deal). They then created an website using some CMS (no clue which or what.. maybe home brew because it's pretty ugly in some aspects of the coding). They want to access the FileMaker database from the remote website which is hosted by another company. So far via all my research and reading, I figured out they didn't have the FileMaker.php in the PHP.ini incl…