Custom Web Publishing

I have a column in this database, which is published via CWP, that calculates the amount of products produced annually. Could someone tell me how I could integrate Javascript to create a function to sum up all the records in each cell in a column to get a grand total figure?

Hi, I'm looking for numbers or experience on WPE limitations. I have a small, 4K script that does a find of a POST variable, and then writes a string into a field before invoking a javascript redirect. Upon loadtesting the script, I can only get up to about 200 simultaneous users before WPE founders, throwing 417 errors, and sometimes simply crashing. I'm running a two machine setup. WPE is a Dual Quad Core 2.26 Mac Pro with 8GB of RAM. The DB is a Dual 1.8 G5 MP with 2GB of RAM. Neither machine peaks out the network or CPU. WPE does end up taking up "131%" in Activity Monitor, however between all the cores, none of them show much strain. Is 200, or ev…

Hi my database is password restricted but when I create a php database (via the assistant) access is unrestricted. Do I need to edit the php home file somehow or is it a filemaker setting?

Does anyone have any thoughts on receiving "Unknown Error" from FileMaker on a commit() command? I have one page where a user can click a link and "sign up" on a slot. It works, using setField() and commit(). I have another page where a user can click on his own name to "unsign" from the slot. It does not work, also using setField() and commit(). I can't for the life of me see any difference in the commit commands. This is code from the page that does NOT work: $findCommand = $fm->newFindCommand($layoutName); $findCommand->addFindCriterion('n_SlotID', $slotID ); $result = $findCommand->execute(); $records = $result->getRecords…

I am new to PHP and filemaker, but i little bit about php, also Filemkaker in separately, But my problem When i am trying to connect the filemaker from PHP the error will appear to ask" Supportive file missing FileMaker.php" But PHP assistant tool was not generate this file. Filemaker server 10 PHP 5 How can I achive this, kindly help me.

Hi folks, I have a PHP web/iPhone interface to a table that works great for all users except one user who has an accented é diacritic in his login name. This user can log into FileMaker app directly without a problem, but the PHP site (set up more or less out of the box) seems to rejects his credentials (error 22). The PHP script itself is correctly receiving the login data, because when I echo back the variables $userName and $passWord by adding a line to the error message, they are exactly as entered. I checked the forums and knowledge base for other's problems with extended character problems. I have double checked the home.php script, and it doe…

Hi all I have embarked on using XSLT for exposing certain parts of my Filemaker database. I started out by using the Site Assistant to generating some HTML pages using XSL and got the hang of this, editing the XSL files that Site Assistant produced to get to where I wanted which was just some very basic tables with a list of records. Now I am trying to do the same thing but returning XML rather than HTML. None of the Site Assistant options return XML so I started trying to figure out how to do this. I found a few examples using the FMXMLRESULT grammar but I am using the FMRESULTSET grammar and can't get it working. I would be really grateful if someone cou…

I am moving our companies filemaker DB to an external host to speed up access from our rails app. I work remotely and can connect with filemaker and open the db. However from within the office filemaker cannot connect. I get the server not available dialog. Is there any reason that I shouldn't be able to connect? I have tried a url and the ip address and neither work... There is no firewalls on the client machines... Suggestions?

We have set up a database for estimating properties in the field. When the estimator accesses FileMaker remotely through our Server the application is incredibly slow and the screen refreshes with each field input. Any suggestions? HELP!

Hi, I have a problem with creating new records. After this command: $addCommand->setField('FieldName',$myRecord->getField('FieldName2', 0)); there are no line breakes in the field 'FieldName'. 'FieldName2' contents some line breaks and I wont to have them in the 'FieldName'. Am I doing something wrong? If someone could help me, I would be very greatfull. Rafal

We're doing it again! ANOTHER PHP / FILEMAKER SHOW-AND-TELL For the third year in a row, folks doing Custom Web Publishing with PHP are getting together at the beginning of DevCon to share projects, tips, and discussions. All web-related tools and technologies are relevant (JavaScript, AJAX, etc.). Everyone's welcome. Come join us! DATE: Thursday, August 13 TIME: 4pm - 6pm (before the 6:30 keynote) ROOM: Golden Gate 3 If you have something you'd like to share or have ideas for topics to discuss, please contact me directly. Your project doesn't need to be perfect or complete to give a demo. This will be a friendly informal chance …

Hi, I'm getting a bunch of error message trying to do the PHP tutorial in FMS9. "PHP Deprecated: Assigning the return value of new by reference" I downloaded the latest api available at FM website for FMS9. Can someone help me with that problem?

I'm sure this is simple, but for some reason I am stuck: I am trying to get records from one layout, then use the info to get the record ID from another layout. I get the records from the first layout fine, but it stops working at the second getRecords() request? Did I need to reset the DB to all records or something else....I;m not entirely used to how FM interacts with PHP. Here is my code: ... $fm = new FileMaker(FM_FILE, FM_HOST, FM_USER, FM_PASS); $test = $_POST['test']; $COPY_LOCATIONID = $test; $request = $fm->newFindCommand('COPY'); $request->addFindCriterion( 'COPY_LOCATIONID', $COPY_LOCATIONID); $result = $request->…

I have a fairly large php website that has company records that can appear on the same page but get there via different categories. Here's my problem... I can do: Record A to Page 1a to Page 2 = no problems Record B to Page 1a to Page 2 = no problems but... Record B to Page 1b to Page 2 = ERROR The issue is that the links being passed appear exactly the same and the error only occurs when I place fields in the and tags. I can comment out those tags and I don't get the error even though the same fields appear later on the page. Here is a link cut-and-pasted from Page 1a: $link = $siteURL.$record->getField('web__Contact_by_cCategoryActiveS…

There's nothing as humbling as learning something new! I'm trying to build a simple site in order to learn PHP. I've created a FM file with two fields. They are formatted as popup menus, and the second's choices are conditional upon the first. I ran the PHP Site Asst. and have a little sample site. However, the second popup's choices are not updating if the first choice is changed (I need the commit/reload). So, I poked around FM Advisor and found J. Starke's sample of how to create condtl value lists in PHP using Ajax. However, his example doesn't include editing an existing record, just submitting a new one. I can't seem to see how to load an existing rec…

(I'm a complete newbie with FM PHP publishing; please bear with me) I just created a test site with PHP Site Assistant using a fairly simple, small database, and it seems to work fine except for one thing: If I go to a record, click "Edit Record," change something, and click "Save Record," it just dumps me back on the login page, and does not save the change. If anyone can point me towards where to look for troubleshooting this, I'd be grateful.

I have a designed layout database with links and connectivity. And now i want to publish it in PHP instead of IWP. Used PHP Site assistant, Everything went well. The problem is.. I cant get the layout i designed in FM Pro.. For Example, I have customer page, product page, service page. What I got was the default, Home, Find, etc. etc. Can anyone help me? Sorry if i couldn't explain better, English is not my main language.

I'm new to FMPHP development. We have a event registration system written in PHP using the FM PHP API and it is working well for the most part. The problem is we frequently have hung PHP sessions within FileMaker Server.They will hang until we kill them. The client version shows as PHP in the Admin Console. These sessions peg the WPE machine's CPU and cause slowness for others who are trying to register so I need to get this resolved ASAP. Our config consists of 3 machines - one for our Web Server, one for our FM WPE processing (virtual Server), and one for our FM Server. I'm hoping someone has seen this behavior before and knows why it happens and how to…

I'm looking to get info and learn how to use FMP to do the soap requests, etc., that are involved in uploading files and such to sites like Amazon, eBay and the like. I don't have a good clue where to post this question so sorry if I'm wrong. I at least think I'm in the right area... Direction is ALWAYS appreciated....

Does anybody know how to get error logging with the Filemaker installed PHP to work? I am having zero luck Todd

I'm implementing a FileMaker solution online that uses php and that will be accessed from an iPhone. I have FileMaker server 9 advanced hosting the file. Is there any creative way to create a pdf from a found set, and then email that pdf by using php? I'm pretty sure I'm just going to be out of luck here, but I thought I'd ask to see if anyone has done anything like this. Thanks, Joanna

I have installed FileMaker Server and Web Publishing Engine on the same machine as the Web Server (Apache on Mac X Server) and I am using PHP. How do I restrict access to the Filemaker databases through php, so that there are only accessible locally from the Web Server only? The firewall on the server has all FileMaker related ports 5003, 160xx, 50003, 50006 closed. Yet, I am a able to connect and access the filemaker database from an external computer through php code. According to the FileMaker'sdocument "FileMaker Server Custom Web Publishing with PHP": "Configure your web server to restrict the IP addresses that can access your databases via the Web Pub…

I know importing and exporting are not web compatible script steps, but since the db is hosted on Filemaker server, is it possible to initiate a script using PHP that will transfer records from on internal table to another using the import script step? My goal is to archive the current set of records so that the users can see them on an archive page, but so they are no longer available in the live working data. If you cannot initiate a script that is not web compatible using PHP , is there another way to accomplish the goal of transferring records from on internal table to another? I hope that all makes sense. Thanks in advance. Sol

Does the PHP Assistant make it a lot easier to build web pages that access the Filemaker database than doing this via ASP.NET? Could a novice web programmer develop web pages via the PHP Assistant?

I have recently needed to start making part of a solution available to the web via XSLT. I have used IWP for ages but it has limitations for this application that meant it cannot be used. So I used the Site Assistant and got a simple record list XSL template (displaying an HTML table of data), edited it a bit and got everything working very nicely (God bless Filemaker). Anyway, after some basic use I needed to start displaying more data, some of which is commercially sensitive so I needed to start using more record-level access privileges so I did a simple limited access rule that said that if get(username) equals a creator field in the record, then the user has priv…

Using Mac OS X Leopard Server's Apache, does anyone know if it's possible to take a URL like http://domain.com/1234 and reinterpret it so that it's executed as http://domain.com/index.php?param=1234, and if so, how I would go about it? Thanks, Chuck

Hai guys, As we all know when 2 users are on same record and try editing a same field at the same time causes record locking [color:red]BUT editing a global field at the same time is not locking the record and changes made is not saved of either user, why?

So I've generated a basic web form using the FMS 9 PHP Site Assistant, and I'm pleased with the results thus far. However, I'd like to have the HTTP_REFERER header (along with HTTP_USER_AGENT and the like) be submitted along with all of the user-entered field data from the form (job_app.php). Due to the nature of the HTTP_REFERER, it should be handled on the actual processing PHP file (job_app_confirm.php). Here's the code that appears to process all of the form data from the previous page: // create the new add command $newrecordrequest = $fm->newAddCommand($layoutName); ExitOnError($newrecordrequest); // get the submitted record data …

Hi all I hope someone can provide some insight into my problem. A bit of background first. I am developing a DB for an urban search and rescue operation. We are barcoding all of our equipment and using a database to track, sign in/out, create reports etc (all that fun!). When we are in the field, we want to be able to use handheld computers with a barcode scanner to perform tasks (sign out/in, find location of tool or item). Since we work in disaster zones, we can't rely on cell signals, so we need to host our own network (we have access point hardware). Most handhelds run Windows Mobile or CE. I have been told that using SQL and IIS web server would be the be…

I am new to PHP and FMPSA, and have a solution that is working well so far (knock wood). It started as an online application - no problem; then a searchable database of those applications; still great; then an editable solution. For the most part, the editing is fine, but I have a situation where I want a user to be able to search for all of "their" records (which I can do) and then edit a single field all the way down the list of the found set. For example, they are going to view all the applications for their campus, and then check "accept" or "deny" for each record. Is there a way to allow this from a list view? Right now they have to go into each record separate…

Hello there: I'm using a fairly simple PHP form to collect registration information for meetings. Many of the fields they complete, including address, cc number, etc., are not populating associated FileMaker fields - that values being entered are blank. Some are populating properly. No pattern insofar as field type are concerned - both numeric and text populate correctly, some populate blank. Even the fields that are populating with blank values are populating a confirmation email sent out right after the createrecord function in the php script. So Address1 for example, ends up a blank value in FileMaker, but it populates the correct value in the resulting confirmati…

I am completely new to filemaker, I've been using it for about a week... so please forgive my ignorance. This is my situation... I have a database on a server made with filemaker server advanced 10. I have a html based website with a SSL subdomain which I linked to the database on my server. I need to know what I need to do in order to have a php login from my website to allow users access to the database. Hopefully someone out there can help me out. Thanks

I have a database that I am accessing by different User groups via php. This was previously an IWP solution. I have about 20 different privilege sets which restrict access for Users to the appropriate records. In IWP, the record access was prompted when the user logged in, a script was run to find only those records. All finds were controlled by buttons restricting access to those records. The privilege sets are named for the User's "site" so the previous IWP script would get the privilege set from a field value (Get(privilegeset)) and always constrain any find with that value. Is there a way to mimic those finds in PHP code? For example, if I login as one of the re…

I have decided to try to develop our screens in ASP.NET since the layouts in IWP were not working well for us. So I set it all up with an ODBC connection and seeminly I can access the database from my second server (I'm using the IWP server as my IIS server for now, while I prove out what works). So when I try to select a record or field that doesn't exist, it gives me an error that it cannot find the field or record, so I'm thinking my connection is ok. When I try to access a record that is there, I get an 'out of memory' error: ERROR [HY001] [DataDirect][ODBC SequeLink driver]Out Of Memory How do I fix this? Thanks!

Has anybody had any success and what kind of success publishing ASP with FM? I was told PHP was good, however, we use ASP and we cant have one server with both in use.

Is it possible to create a new related record through PHP without using a portal? For example, I have an existing FMP db with a Patients table and a Procedures table. A user can find an existing patient in the Patients layout and press a corresponding button that runs a script in order to create a new procedure for that patient. This script simply sets a variable to the current patient's primary key ID, then switches to the Procedures layout and sets the procedure's foreign key ID to the variable that was just set. This, in essence, creates a new record in the Procedures layout/table which is related to a specific patient. I haven't been able to figure out how to…

Hi-- I am a newbie and I don't know if I am posting in the right place so I apologize in advance if I am not where I should be. Need the most cost efficient way of sharing a database remotely with 2-5 other individuals. Each of us works from home, and we each need to make changes to the database. Also, need to make some parts of the database available to clients. Do I need to buy various licenses? Or do I just need one copy of FM10 and they can access and make changes on the web? I don't want to spend a fortune because this is a startup and we just want to provide better service to customers. Also any suggestions on a good FM web hosting would be…

I'm opening a page on my website that shows the informations of a specific record and I'd like to have a next and previous button. How do I pull it off? I notice there's no GetNextRecord() function. I'm using AJAX to show the data, so since everything is brought back by the PHP, it's hard to actually do something with javascript and mess around with arrays, like I originally tried to. Is there an easy way to do this? I spent the whole day on this yesterday trying various solutions but I couldn't pull it off. I was planning on trying with setRange today. EDIT I'm currently toying around with a possible idea with record numbers. It would break instantly if I…

I'm currently working through the admin section I talked about in my other thread and I'm having some encoding problems. I'm french canadians so I'm gonna have to use characters like é and à. FireFox can insert the characters without any problems. IE fails and doesn't insert anything. If I utf8_encode() my string, it works in flawlessly in IE but FireFox changes the characters to some other form of encoding, like é becomes é. Right now I use an IF that detects IE and UTF8_encode the string if it's IE, but it would be better to work without that. Changing the website's charset to ISO-8859-1 or UTF-8 doesn't seem to have any effect.

Is it possible to retrieve the privilege set of an account using the FileMaker object or anything else?

Hello everyone, PHP gives the following error when trying to connect to FM and perform a search: Communication Error: (22) The requested URL returned error: 404 - This can be due to an invalid username or password, or if the FMPHP privilege is not enabled for that user.(22) The php code which gives this error is: require_once('FileMaker.php'); $database = "DatabaseName"; $hostname = "192.168.1.2"; $username = "****"; $password = "****"; $connection =& new FileMaker($database, $hostname, $username, $password); $cmd =& $connection->newFindCommand('INVOICE'); $cmd->addFindCriterion('_InvoiceID', '1003'); $result = $cmd-…

Hi, I'm new in this forum, coming back the FMConf at Paris last week-end. Everything run well with a (really simple for test) FM database and API PHP Assistant navigation, list, search, sheet ... Except when I want to modify a field. I have a "-error unknown" message. Does somebody help me ? Thank you very much.

I need to put information from my database on a website, via static web pages. I will only update the date a few times thru the year. I have read the guide over and over, but I'm stuck on one basic point. I understand that I can manually export to HTML, over and over and over. Then, at my website, I can link from page to page. But I have to believe that there's a better way.... some script or something that I can use with FM, so that I'll wind up with a folder of html files, and a index.html file as the front end. Can someone please point me towards what I need? Thank you - Marion in NY

Hey Folks, thanks in advance for your help. I realize this topic may be vague, and if even if all you can give me is a "best practices" response, that will be incredibly helpful. I'm relatively new to the PHP API, but i'm a PHP expert and have been using Filemaker for 20 years. That being said, my issue is the following: I have several large databases with 20,000 plus records. All of them respond through the PHP API in less than five seconds when i do a search, or create a record - except for one. It takes 2 to 3 minutes to do a basic insert through a layout that contains only 3 of the fields in the database. We've been pouring over the permissions, logs, …

I'm working on the ground of a previous programmer and he has about 4 or 5 files for the login to work. Also, he has a web layout on his database. I'm trying to work around that and make it more simple. Is there a way to connect directly into the list of accounts of a database without requiring a layout with username and password fields? Thanks a lot! EDIT : I guess what I want to know is how to verifiy the validity of the FileMaker object without an additional layout. Right now I pass my database and login info in it and it goes through no matter what username/password I use.

I'm trying to echo a an href tag along with some images and the result I'm getting is simply a string of text. I'm not sure of how or why the result isn't being interpreted properly. Leaving out the FM API and declaration portions, here's what DOES work: [center] '> (closing php tag isn't showing up in the code here on FMForums) Here's the code I would like to have so I can simply copy the above into one field in FM... <?php echo $imageStringA; ?> [/center] But again, this results in the string being echoed back. I've tried single-quotes, escaped double-quotes, the substitute function, etc. but no luck. Any advi…

I have a client database that is using custom web publishing with PHP. I want clients to be able to "log in" using their name and client ID, which will in turn simply find their record and allow them to make changes. The problem, however, is that it's a simple Filemaker find function. So if they find "Smith" and leave the ID field blank, it will return ALL records with clients named "Smith." Worse, if they leave both fields blank and simply hit "Find," they will have access to all of the records. Anyone have thoughts on how to accomplish this, or perhaps even a more elegant log-in solution that will allow users access to only one record?

Hello, I have a older CWP site. All of the sudden my href links do not load in IE7. Whats even stranger is if I click reload then pages load fine? If I make the href links to open in a new window they open fine. The first page always loads fine but when someone clicks the next 10 records link. Then the page does not load. If I again reload it works??? All this only happens when using Internet Explorer 7

FILEMAKER_FIND_GTE = '>=' guys how to use this Api I am really sucked pls help me out.. thank you

I'm looking for recommendations on hosting and/or colocation services for an FMP solution that runs a company. Preferably the facility would have sufficient redundancy, security etc. to meet the standards for a Tier 1 or 2 Data Center. The availability of system administration services (FMP, Windows and Mac OSX) would be a plus. This isn't Angie's List ;-) but any experience that you have had with the provider is of particular interest to me. Thanks!!

Hope this is the right place. I'm trying to do a simple query to write a record from a web form. The problem is for some reason with my full field list in the query, it fails. If I cut it to about 1/3rd it works, by going down and deleting one field at a time and trying it, I was able to find out that 1/3rd + some of the fields works, but most of the time as soon as I add any of them it gives me the error trap. The fields are a mixture of radio buttons, checkboxes, dropdowns, and text fields. Here is my posted value list as well as my query. and one or two of those fields are declared in other places, if theyre not on the list. If I drop it down …

I have the PHP API working with FM9 Server. When I call my FileMaker script from PHP it works great until I get to the "Perform Find" script step. It throws error 16 in the log file and exits without returning a result. The user account has [Full Access] so it isn't a matter of permissions. Why can't you perform a find from the FileMaker script?

Helloo.. has anyone got any links to any pretty CSS ecommerce sites that use filemaker as a back end!?

We are using filemaker to support a template website that has thousands of sites built upon filemaker records and the data stored to populate the template pages. We are interested in building a system to log all the "HTTP QUERY" that searches the database and returns a record. In short, we want to 'COUNT' every time a record is returned from an online search. (basically building a COUNTER for each 'page' viewed) ANY IDEAS ANYONE? Anyway to trigger a script when a record is sent via CWP?

I Need a step by step on how to make my DataBase in my FMS9 accessable truth internet by Filamker adv. 9 Program/Client. Pls!

I am not familiar with PHP, but think I may be able to reverse engineer the solution that I need. I am using IWP for the major part of my web publishing, but I need reports. Started using PDF references in container fields, but this is getting to be a pain with the weekly update of the database. I used the report selection of PHP Site Assistant to create the foundation. I need to limit access to data to the primary log in identifier, which I have done in the privledge set. How do I move that identifier, which is Get(AccountName), to the find screen/criteria to maintain record constrain in the PHP find screen (maintain client only having access to their records). …

I want to edit FM databasein the back from front end using php code. So please tell me the FMphp ApI to use. :D

Hi All, Has anyone tested or played around with the new version of filemaker? How does it compare its capabilities on the Web? I know FX.php is faster than API, have they made any improvements on that front? Also, what would you guys prefer to use? FX.php or API? Thanks for your reply Ricky

Hello, I have read that external authentication can be used in conjunction with the PHP API. When testing this out, however, I get some unexpected results - if I enter the wrong credentials in the HTML form that sends the UN/PW to my login script, I would expect to get a FileMaker_Error object back when trying to instantiate my FileMaker connection object. However, my call to FileMaker::isError($fm) does not evaluate to TRUE, so it would seem that the bogus credentials allowed me into the file. Anybody know what's going on here? How can I tell if the authentication is/isn't working? Thanks, Jeff

I have a shared webhosting account through a hosting provider. PHP is installed on the shared web server so I have no problem creating PHP pages. However since this is a shared server (running Linux) I can't install any 3rd party software. In addition I have an in-house server running FileMaker Server. With this setup will I be able to utilize PHP custom web publishing? What's unclear to me is that the manual states that the "Filemaker Web Server Module" must be installed on the web server. What exactly is the Web Server Module. Is that nothing more than a set of PHP files, in which case I assume this would work. Or am I missing something?

I have 9.03 FMSA on mac. i am trying to get php site assistant to work, but I am unable to get the app to see the server. I am running the app on the server & I am using the IP address that FMSA indicates, so I figure it the right one. I have loads of php activated fm files, some that are already communicating with API php sites elsewhere, so I know that PHP works. I have installed a PHP from a third party rather than the PHP supplied by FMSA. Is that the reason?

Goodmorning, Is there somebody who do have some experiences with webservices. We do make our own WSDL's and are willing to use these services in combination with Filemaker Pro. Locally we did manage to have our WSDL's work in combination with Filemaker 9.xx. What we really want is: Having our WSDL's work in combination with Filemaker Server 10.xx in browser (IWP) mode. So our clients can use our webservices with or without having filemaker. Our problem is: We need to know where we have to install or place our (NEXUS) webservices plugin and our WSDL or XML files (webservices) on our server. We are working with an Windows 2003 Server Known sa…

Hello, When submitting a form to another page or itself and an error is returned (either by FM or verification code), is there an easy way to keep what the user had filled in in-tact when reloading the form page to display the error/message..besides using sessions? Thanks for your help!

Hi. I'm trying to execute a script via filemaker api via newPerformScriptCommand($layout, $scriptName, $param). Actually the script runs. I'm doing a new record and in that script I try to set a field with the $param by doing a get(scriptparameter). The field always has a different value and it's never the good one. What's wrong ? It looks like it never get my parameter.

FMS9 on Leopard X.5.5 Have been trying to track down why my new FMstudio/DWMX database select setup falls over (returns dreamweaver '959' splash). Trying to isolate if it matters which version of PHP, the FMS is configured for. I've read it shouldn't matter. In my situation it certainly seems to. in FMS 9 server deployment; have tested using PHP: yes, install FMS supported.... and also PHP; no, use existing install (5.2.4) XML is checked in both config tests, and the PHP type is the only difference. Checking the / index both PHP configs produce the list (PHP shouldn't matter) php pages show code in the browser if ' existing install PHP' is used,…

One of our programmers made some updates to an old XSLT site that we inherited. The site is being used to enter ingredients in English and in French. The changes were programmed/tested in a development server, then moved to our live server. However, the French characters are not working properly in the live server but they do work in the development server. I've checked a ton of settings in the FMP server admin console and Apache. Has anyone ever run into this? Here are server specs: Development servers: FMP Server v9.0.2.151, running on Windows 2003 server Apache v1, running on Mac 10.4.11 (not OS X server, Mac G5 Mirror tower) Live servers: FMP Server v9…

hello.. i've been looking now for 2 days on how to make a web form check to see if a record is 'in use' on the LAN (cursor in a field.. or uncommitted record). currently, if i'm accessing a record on the LAN with someone else on the web, there's nothing to prevent that form being submitted. The obvious problem being that any changes created online are simply ignored on submission. I need to be able to check for 'in use' prior to drawing/loading the form. I could do this manually (we have a 'locked' checkbox), but that's used along with a timestamp, and set AT THE TIME of submission. all i've found so far in the FM app is a function called "Get (RecordAcces…

I have a solution that uses PHP coded pages in IWP to upload a .csv file to a server and

Hello All, I have a church client that I am proposing a FMP based website to. I'd like to show them some examples of sites built in it, that look and feel a little "looser" or "less structured" than is typical. Something that makes good use of background graphics and strong graphics design for the UI would be preferable. Does anyone have any sites that come to mind that I could visit? They don't need to be church related, just visually strong. Thanks in advance.

I'm using the PHP site assistant to create the framework for my "create a new record" page, and I'd like to have a drop-down calendar for selecting a "need by" date for the new record. I know there are javascript solutions for normal HTML forms, but I'm having problems integrating them with our PHP forms. Can anyone point me in the right direction here? Thanks!

way do i get an error filemaker cannot share files over the web because internet web publishing could not be started ?

I'm not really sure where to post this, so I thought I would put it here. Some of my users are having severe performance issues using a PC with IE to access some of the sites. The problems are Intermittent, but they do not seem to happen when using Firefox or when using a Mac with any browser. I am using XSLT web pages with Version 1 of XML. Any thoughts as to what could be the cause of the problem (or the solution)?

Howdy, I am developing a php site usning FM9 server. I would like to use s for three of the fields where short answers are required. The textarea works properly for data input, but when I try to edit the record via the web, the textarea field is always empty (I can't get the data from the record to show up in the web form). I believe this is due to the TEXTAREA not having a "value=" tag. Is there a solution to this using PHP or do I have to rebuild the whole site using XLS? Thanks in advance jeff

A LONG TIME ago, I did FM on the web for an association of Refrees, providing that they were active and able to referee and at what level. I now am using V6 on a static IP http://69.89.181.83:5003/DBindex.html I want to control the access to certainf fields and there data on a webpage as you can tell on the website link above hosted in the folder on FM. I can do web pages, but I dont remember how to do the connection to the data for the field to showup on the page and FM wont help me! I bought 9.0 but dont have the time as this project is to time sensitive right now to learn it.. can SOME PLEASE HELP and give me resurces or the example on how to link a field to a webp…

Hi all, I am completely a beginner in Filemaker and PHP API. Now I am working with an unstructured FM database, contain almost 1000 records and 32 fields in each record. Image below is describe the table, just only 8 records. I need solutions 1. I want to perform a newFindAllCommand, and to make it faster (event only get 25 records), I'd like the 'find command' only load id, department and first name field. Sometimes I got: What command to use when I want only select 3 required fields rather than 32 fields ? In SQL I can do 2. If I want to get the department name only, just want to list available 'department name' in the tabl…

I feel like there is going to be a simple answer to this question but I'm not sure what to do. Is there some issue with using Filemaker objects in functions I create? Here is my issue. I have created a function in my PHP file so I can do some recursive operations. But when I try to do a new search in this function I am getting the error that my filemaker file is an undefined variable. <?php require_once ('FileMaker.php'); $fm = new FileMaker(); $fm->setProperty('database', 'flow'); $fm->setProperty('hostspec', 'http://localhost'); $fm->setProperty('username', 'admin'); $fm->setProperty('password', 'admin'); …

Hi Guys, I've not had a chance to test FM 10's functionality. Have they made any improvements to the API for PHP at all? Cheers Jalz

I have what seems like an odd case here, but there is probably a simple solution that someone new to PHP like myself has overlooked. I have a calculated text field that displays some html tags such as . I created this for the purpose of saving time when displaying information on our website. In order to get it to display properly I use html_entity_decode on the getField results. I tested this by having a copy of our website on our local server where Filemaker is hosted and everything works fine. However, when I moved the site to the external web server where our public site is hosted it stopped working. Instead of , the html source just shows br. The exte…

Hi All, I have multiple web pages that use an include to get data for a banner ad to place on the parent page. The banner ad data comes from a portal (there's more on the layout and it's a leftover from FX-PHP.) I need to change the functionality so one web page can show multiple banner ads but in different places on the page. Similar to a forum that has some topics and then a banner ad, then more topics, and then another banner ad, etc. Also, with the change, I'm hoping to have one include get the data from FM and another include echo it to the page. I can get and show a set of ads all together with a foreach loop in a single include and I tried addin…

I need to embed a find command into an A HREF format for my php FM site so people can jump to a found set from an outside site. I have one that does a Find All just fine. I just need to know what to call the find fields and find arguments. Here's the code for the Find All Find All

Hi, I'm trying to tweak an existing web form to submit data to an FM7 DB using PHP. However, not all fields on the form are required and I cannot get the submit function to post to the database when any field is left empty. Does anyone have any ideas how to get it to post a new record when one of the fields is empty? The setup of the page is pretty simple - the user populates the fields and then clicks submit. The page then posts the data to another page which runs it through a simple $_POST for each field. I've tried putting in a null (and 0) value in for the value of each field, but that doesn't seem to work. Thanks!

I am having trouble retrieving information from my Filemaker server using PHP. The problem is that my company's website is hosted externally while the Filemaker server is in house. I can get the basic Filemaker PHP interactions to work when I am testing on our server, but I cannot get it to work from our hosted website. I am trying to use an include statement for php files that are located on the Filemaker server. The idea being that these files will have functions I set up to return the necessary data to the website. But the include does not work. I get an error telling me it cannot find the file. I can access files on our in house server from and external source, I…

is it possible to set a field with a URL.. alternately, if i could call a script with a URL, that'd be fine too. i used to include "&-script=scriptName" when i was doing this in CDML.. thanks in advance! brian

Has anyone got SSO working properly with FileMakers API for PHP. If you have, can you give me some pointers please. Many Thanks

hello.. need a little help with editing a record. I have the Stark book, and the Olm book and still can't seem to make the "newEditCommand" work with $_POST. If i hardcode the the second parameter in "setField", things work fine. If i try setField('Name', $_POST['Name'].. i get an 'Undefined Index: Name' error. here's my FIND and EDIT: // FIND ATTENDEE RECORD $request = $fm->newFindCommand('a'); $request->addFindCriterion('id', $_GET['id'] ); // 'id' is a random, alphanumeric field $result = $request->execute(); if (FileMaker::isError($result)) { echo 'Error: (' . $result->getCode() . ') ' . $result->getMessage() . "n"; exit; …

hello.. i have a form with several checkboxes available for each hotel room night: Nite_1_Check Nite_2_Check ... if i submit the form WITH a box checked, no problem. If i don't select the box and submit, it errors out "Notice: Undefined index: Nite_1_Check... Here's what i started with: $edit->setField('Nite_1_Check', $_POST['Nite_1_Check']); when that didn't work (if unchecked), i tried several variations of: if ($_POST['Nite_1_Check'] != NULL) { $edit->setField('Nite_1_Check', $_POST['Nite_1_Check']); } else { $edit->setField('Nite_1_Check', NULL); } but that doesn't work. Since all of my other (non-…

Hi all, I'm in the middle of testing the upgrade of an FM3 database to FM9 and I'm running in to some web form problems. I am getting Field not Found errors with a handful of the fields in this database. There's nothing obvious to these fields - the non-working ones are similar to the working ones. All of the fields (working or not) are text and part of the same table. I tried switching to some of the other layouts in the DB, but no luck there. A couple of the non-working fields have custom value lists (yes/no), but since the web form is submitting values to match those on the lists, I'm not sure if I have to do anything or not. I'm kinda outta my element h…

hello.. (thanks for your help with related fields, prev posts) i have a calculated URL field that includes a random, alpha numeric string, uniquely identifying a meeting attendee. This URL is part of an email invitation each attendee receives. I'd like prospective attendee to click the link and be taken to 'form.php' AND looking at their record (which will have been partially completed in advance). Something like: "http://server/form.php?Attendee_ID=" & Attendee_ID i can make this work by substituting "recid" for "Attendee_ID", but that's not alphanumeric, nor is it random. I don't people trying out different recid's and viewing other records. …

I need help on passing variables. How do i get a variable into a hidden field so that when user creates new record, the variable poupulates the field. I am passing it in the URL '/name=mike'. How do i place the into a new field on another table in my db? -dbCustomers;&name=mike passed to a new table & new field ...orders::name?? thanks

forgive me if this has been answered elsewhere on the forum, but i didn't see anything mentioned.. i'm pulling a 'meeting time' field like so: echo $meeting->getField('meeting time') and the filemaker api is showing me "hh:mm:ss", regardless of how the time is stored in the database. Meaning, i can type in "3:00 PM" into filemaker.. there's no formatting on it in the database. But online, all i can get out of it is "15:00:00". now, i could make them text fields - we're not calculating anything against them (at this point), but i'd prefer to leave them as 'time' if there's an easy way to adjust how they appear online. I could also make a extra '…

hello.. so, i'm making my way (stumbling through) using the Filemaker API.. and i'd like to clarify something in my head before i get to used to the idea, in case it's the 'wrong' way. I thought i could get a related field from the "Meeting" table field by doing: define ('FM_HOST', '127.0.0.1'); define ('FM_FILE', 'rxworldwide'); define ('FM_USER', '******'); define ('FM_PASS', '******'); include ('Filemaker.php'); ###### CONNECT TO DATABASE $fm = new FileMaker (FM_FILE, FM_HOST, FM_USER, FM_PASS); ###### GET ATTENDEE RECORD $attendee = $fm->getRecordById('Attendee Setup', NULL); // i'll fix the null thing later ##### GET MEETING …

hi there.. i've been a filemaker developer for 9 years, and can write CDML as fast as i can think it.. BUT.. i have an event registration system (custom web publishing, CDML) that's being re-written in filemaker 9. I have the database built/working fine. I'm having a hard time getting started with custom web publishing (filemaker.php). here's a quick background: 1. my database has 2 main tables.. "Event" and "Attendees". 2. there's only one record in "Event", and several Attendee records in the other table. 3. each attendee has a random, unique, 9 digit number as their "Attendee_ID". 4. we email our event invitations with SMTPit.. each invi…

Hey guys, This is probably pretty simple, but I can't find it. I have a customer table with related contacts. I need to get the record ID of each contact record. I know that for the customers it is: $customerRecID = $customer->getRecordID(); but as I am going through the contact records using this: $contactList = $customerRecord->getRelatedSet('Contacts_CustID_Customers'); foreach ($contactList as $contact) { // create my table rows } I want to get the record ID for each $contact. Any help would be great ~Mark

In order to have more flexibility over pricing (different pricing for... different clients, different web sites, coupons, etc...), I plan to move pricing to a related table rather than in the same table as products. Price Codes attached to clients, orders, and invoices would relate down to the correct price. To view prices in a product list, I'd just set a global to the priceCode and base a relationship on that. but that isn't going to work with PHP since it doesn't support globals in that way (right?). So what would be my options for implementing this or another flexible pricing model using PHP?

I'm working with eBay's notification system that posts data to my script when auctions end. My script takes that data and updates our FileMaker via the PHP API so we get updates in real-time. The problem is if there's a user in the auction record at the time the auction ends I end up with error from FM that it can't update because of that. I tried adding a script into FM with nothing but a commit record step and then I added that to my PHP script at the top using a perform script step but that doesn't seem to be working either. Any information on how I might get around this problem would be greatly appreciated. Thanks!

I'm having a problem with Instant Web Publishing, where my calendar drop down box isn’t appearing on the screen, but only when I am accessing the file through IWP. I have a SQL backend database, where there are some date fields which are of a date/time data type (which means that in FileMaker these fields are automatically made to be of type timestamp). I have set up the layout so that these fields have a drop down calendar available, to make it easier for the users to enter the date in the correct format. When I am in browse mode on FileMaker I am able to use and see the drop down calendar. However if I access the file through IWP, the drop down calendar doesn't sh…

We have a Filemaker 9 database which we have published using Instant Web Piblishing. The IWP website does everything we need it to, but the limit of 100 concurrent users is too low for us. Which of the various PHP options would allow us to migrate to a PHP-driven website allowing more like 1000 concurrent users with the minimum of effort? We'd probably hire a developer to do the work. The database presents long lists of statistics, mainly in Filemaker portals and allows a small amount of user interactivity: Screens - 15, simple design Scripts - 20 Tables - 30. Alternatively, does anyone have any suggestions for getting more out of IWP?

Hello. We would like to set up a system to allow multiple users to submit data to a hosted database. That part is straightforward. Then, one central administrator needs to pull those various sets of data onto a local machine for collection, analysis and graphing in a spreadsheet. I realize that IWP cannot do this due to its non-dynamic nature. I do not know enough about PHP yet to determine its capability. QUESTION: What would be the simplest means to accomplish this? Can it be done with PHP? Does it require XML or another more advanced setup? Thank you for any guidance. DLW

Hello folks, is there a way to change the number of shown records on a list format? The default number is 25 and I need to make it bigger. Thanks and have a nice day!

I am running the php CWP for the first time, and I have the following very basic problem. when I want to test the php cwp using the filemaker sever testing page an error message comes up saying " The PHP connection to the FMServer_Sample database failed. Notice: Undefined index: message.error.fm.7 in /Library/FileMaker Server/Web Publishing/web-server-support/test/fmi-test/phptest.php on line 36 The Web Publishing Engine is refusing connections. Make sure the web server is started and try again. (Error 7; Running out of memory) " please somebody help me in solving this problem thanks in advance Fathy