Jump to content

Search the Community

Showing results for tags 'php'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Platform
    • FileMaker Pro Advanced 17
    • FileMaker Pro 16
    • Command Line Data Migration Tool
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 75 results

  1. Hello, I am trying to convert a custom web publishing site in php, from FM Server 12 to FM Server 15. We've updated the Windows machine that hosts it (to a shared server on the recommendation of IT) and installed FM Server 15. Direct opening of the existing scripts always yields 0 results, though the database hasn't changed. Is there some setting, somewhere, that I am oblivious to? I've consulted user's manuals, IIS settings, web postings, ... Attached is a copy of the website I am running. I can point you to the existing website, though I doubt it would be useful. The beginning part of this website are script tracking errors. I've been inserting them, trying to track down where this error is creeping up. So please ignore. Please ask any additional questions, I am sure there are many. Cheers, Tony PublicPortal.zip
  2. Kara Amsinger

    EMAILING BLANK FORMS

    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 where it emails me the sumbitted info. Any ideas of where I can start looking to fix the problem? I have several files of php code for this setup that I can attach if needed. Just didn't want to clutter the post with a bunch of code.
  3. Hi, As we know that we have option to configure FileMaker Server with PHP (which is installed on IIS).. Like the way.. I have another question.. Do we able to configure FileMaker server with PHP Which is installed on Apache (with Linux machine).. Please clarify.. If you already experienced please help us to configure Filemaker 12 server with Apache.. Many Thanks ~Guru
  4. Total newbie questions about a simple PHP search using addFindCriterion to match checkbox value. I have 3 checkboxes in a field called "myChoices_field" containing the following choices - where "airport" is selected. [ ] air [x] airport [ ] air vent So that means that "myChoices_fld" contains only the value "airport". If I do a search via PHP looking for a record that matches only the choice "air" - this is what I would use: $findCommand->addFindCriterion('myChoices_field', "air"); I should expect it NOT to match anything since "air" does not equal to "airport". However - I'm getting back the record that matches "airport". Clearly - it's just doing a substring match. How can I search a checked value that actually just searches the whole checked value - not do a substring search? I'm I completely missing where to find this in the documentation? Pointing me to the documentation would help greatly. Thanks!
  5. I'm having great success with the PHP site assistant aside from one major issue. I'm not able to display images stored in Supercontainer. The code below will return a broken link. If I take the reference link and paste it into any web browser on any computer on any network, the link works fine. What obvious step am I missing? <td rowspan="8" class="field_data"> <?php echo "<img src='http://74.119.147.179:80/SuperContainer/Files/CKD_Files/PDT/2009/1035/90101463440377643/IMG_6944.jpg' title='Error' alt='Error' />";?> </td>
  6. dpistolenma

    mac PHP API Slowness

    Hey there, I'm currently building a web interface that interacts with our filemaker solution (FM Server 13) and have run into some performance issues. We have a table which has 161,000 records, and I am exposing 6 of its fields via a layout. When I run a filemaker find command via the API, looking for specific values in 3 of these fields, it takes extremely long for the results to be returned (up to a minute sometimes). The result is usually 1 or 2 records. For what its worth, I have another table with 73,000 records that does not have performance issues. I've tried to use xdebug to profile my PHP code, and the majority of the response time is this one findCommand and curl_exec, so I don't think the slowness is on the webserver. I've also looked at the statistics page on the server and when the call is made there are tens of thousands of "remote calls" for the client used by the PHP API, not sure if this is normal or not. I thought about maybe increasing the PHP memory limit on the server, but not sure which php.ini is used by FileMaker Web Services. We're running OSX mavericks and I changed the value in a php.ini file that I found in "FileMaker Server/Web Publishing/publishing-engine/php/mavericks/lib/" from 128M to 1024MB but did not see any performance increase (though I am not sure that the change took effect, nor that that is right PHP ini file). Anyone have any other ideas? The server that it is running on has 64GB of RAM, and finds are quick when using a filemaker software client.
  7. I have a php script that takes two PDF files and merges them into one file. I am using this in conjunction with the insert from URL script step. The way the script works is it takes two PDFs in container fields and base64encode each files. Then, those two base 64 strings are POSTed via insert from URL. I've tested the script forwards and backwards and it does combine the PDF files reliably. The issue is when posting from FileMaker. What typically happens is the first page is combined twice and that's my resultant PDF. My php script checks that both inputs are different and throws an error is they are identical. I don't get any errors there. Is there a way to POST a file from insert from URL?
  8. I have this same solution I'm installing to 3 separate FM servers, but on one of them I can't get passed this Communication Error 22 for some reason. The error says it's the username or password, but it is imply not. I am using as basic as it gets with a username of "php" and a password of "1111". I also tried my regular admin account, but I get the same problem. I do have the FMPHP privilege set for both of these accounts... The server is on Windows with a fresh update of Java and then a fresh install of FMS14. Deployment seems to go smoothly, and everything shows nice green lights. The CWP test page loads just fine, too, which you can see in these images... I have also forwarded all of the ports that should be open for this machine. I am able to use Open Remote and open files from this server within FM Pro, but for some reason I cannot get the PHP API connection to work on this server. Again, I have the same thing setup on multiple servers. Here is a working example that spits out the available data sources. Here is the exact same test script that is hitting my other FileMaker server at a different location, but it's returning the error. I can't think of what else to look at. Any information on how I can get this working would be greatly appreciated. Thanks!
  9. AngeloCit

    keep format input

    hi, i have a INPUT that has special format FILEMAKER 13 as might make PHP take the same format? and that save register from PHP also in FileMaker the same format display? Thanks...
  10. (Long story short.) I'm moving a complex solution from a local network to a hosted service. The solution uses (and needs to use) external authentication. In order to divorce the solution from the local network completely, we will no longer be using our active directory on the local network. Setting up security groups and users on the hosted server and configuring FM server to authenticate against it was very easy. Only one problem remains, How can users change their passwords? This isn't really a Filemaker question as the question becomes, how can you let a user change their password on windows servers if they do not have desktop access(on the server)? I have done a couple of google searches and found enough to know I could write some sort of custom solution (or likely adapt one that is already out there) but before going down that rabbit hole.... I thought I would ask the helpful people here.
  11. Hi, I'm trying to install in a drupal site the connection with Filemaker. I am developing the drupal site in my machine using MAMPRO as a web server and I have my database file hosted in a shared Filemaker server. After installing in Drupal, the Filemaker modules, and the FX folder with FX.php in the libraries folder, whenever I try to use the filemaker module I get the following notice "Can not find FX.php. Please place FX.php at sites/all/libraries/fxphp/FX." I'm sure that I've installed in that location the FX folder. So I am lost. I'd appreciate any help, thks. Armando
  12. Hi all, I'm new here so I hope I get everything right. I've done a search already, but I can not find my issue listed. Sorry if it's been covered before. OK, here goes..... VMWare Server running on HP Prolient G7 tin 2 Virtual Cores 4Gb RAM Windows Server 2012 R2 DataCenter x64 IIS v8.5 (Default for 2012 R2) FileMaker Server 12 FileMaker Pro 12 Advanced with Bonjour JRE v7 This is a brand new build specificity for this use. I've installed FileMaker Server 12 on to the above setup with Custom Web Publishing using PHP I followed the deployment wizard and deployed for a single machine setup. I allowed FMS to install the provided version of PHP with it's own configuration. There is NO SSL configuration on the server at present. The admin console shows three green ticks to indicate that everything is happy. However, when I run the PHP Custom Web Publishing Test, I get the page displayed correctly, (PHP is working) and it identifies the name of the server, but below the main information box, I get the following error message: The PHP connection to the FMServer_Sample database failed. The PHP test was not able to communicate with the Web Publishing Engine. Make sure you have PHP publishing enabled and the database has the fmphp extended privilege enabled. (Error 22; Unknown error) The sample database is installed and it is listed in the admin console, status, normal and dots across the line. I can't imagine that it wasn't installed with the correct Extended Privileges for CWP and I would not be 100% confident to know what I should check for. I am viewing the CWP Test webpage on both the server and a client and getting the same error message. Can anyone suggest any further areas that I should be looking at? Cheers in advance, Barry.
  13. Hi there,  I am having the problems in accessing the data stored in container fields using  php. The containers are not remotely stored. A screenshot is attached showing the database settings for container field. I am able to access data stored in other fields from a remote computer using php api. But when I try to access the container fields... For: $image=$record->getField('container field');     $attach=$fm->getContainerData(urlencode($image));     if (FileMaker::isError($attach)) {       echo "Error: " . $attach->getMessage() . "n";     }  I get:: Error: getContainerData() does not support remote containers  For: echo $fm->getContainerDataURL(urlencode($record->getField('containerfield')));  I get a url in response simlilar to :: http://HOSTIP/fmi/xml/cnt/Untitled.jpg?-db=DATABASENAME&-lay=LAYOUTNAME&-recid=253&-field=containerfield  When try to open the url in a browser I get a  xml in return that has ::   <error code="959"/>   My server has php and xml access enabled for the privilege set I am using.  Thanks in advance   Â
  14. My question may be as simple as how do I enter a date in DD/MM/YYYY format using a radio button? (If you can answer that, ignore the rest). I have a simple form for online Timesheets that we have been using for years (thousands have been entered without almost no work on my part since I set it up). Now we want to change the date format from MM/DD/YYYY to DD/YY/YYYY. Everything works except where I auto-enter the "Period Ending" Date. An assistant updates the global value for the "Period Ending" Date in FileMaker every two weeks- this date needs to be auto-entered in new Timesheets (but must be modifiable by workers). Since addrecord.php is creating a new record I use a valuelist that finds that date [a related, global value] in a global table that consists of one record with various global values for the Timesheets table. <?php $fieldValue = "test " . $record->getField('Period Ending', 0) ; ?> <?php getInputChoices("radiobutton", $layout->getValueListTwoFields('Timesheet Period Ending Date', (isset($master_record)) ? $master_record->getRecordId() : $record->getRecordId()), $fieldValue, getFieldFormName('Period Ending', 0, $record, true, 'RADIOBUTTONS', 'text'), 'text', $submitDateOrder);?> is the ending date for the Current Pay Period.this appears as 2-Week Period Ending (MM/DD/YYYY): [Entry field with 07/04/2015 autoentered]07/04/2015 is the ending date for the Current Pay Period.And really works well (don't ask me about 'test ', it is ignored). To change the date format I tried doing a calculation [Day ( timesheets Period Ending global ) & "/" & Month ( timesheets Period Ending global ) & "/" & Year ( timesheets Period Ending global )] to change the order but it submits it in the MM/DD/YYYY format (other date fields ARE dealt with properly!!!). <?php $fieldValue = $record->getField('Period Ending', 0) ; ?> <?php getInputChoices("radiobutton", $layout->getValueListTwoFields('Timesheet Period Ending Date calc', (isset($master_record)) ? $master_record->getRecordId() : $record->getRecordId()), $fieldValue, getFieldFormName('Period Ending', 0, $record, true, 'RADIOBUTTONS', 'text'), 'text', $submitDateOrder);?> is the ending date for the Current Pay Period.2-Week Period Ending (DD/MM/YYYY): [Entry field with 04/07/2015 autoentered]04/07/2015 is the ending date for the Current Pay Period.This is entered as April, while in the other date fields in the same form 04/07/2015 is entered as July. I am doing this with Filemaker Server 11, using PHP/Apache on a mac mini client.
  15. Hi, I am relatively new to FileMaker. I am a PHP developer currently working on a project that involves the FMS custom web publishing PHP API. I was able to successfully connect using the API, but the connection is no longer working. The error message says only "Unable to open file". My research says that this could be due to the database file not being open, or to a permissions issue. I can see in the FMS admin console that the database file is open, with "normal" status. The FMWEBDIRECT and PHP columns both have full circles, indicating that the database should be accessible through the PHP API. Both the web server and the web publishing engine are on, with green checks, and PHP is activated. I am using the same username and password that worked previously. I checked again in the database security settings and confirmed that the username and password are still correct and that the user account has the "fmphp" privelege. What else should I look for? In the web publishing error log I see entries that say: 127.0.0.1:63876 [USERNAME] - 802 563 "fmi/sml/fmresultset.xml?-db=[DB]&-lay=[LAYOUT]&-findany" Does the PHP API use the XML API? Also, here is the full var_dump() of the error object: object(FileMaker_Error)#6 (9) { ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["error_message_prefix"]=> string(0) "" ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> string(3) "802" ["message"]=> NULL ["userinfo"]=> NULL ["backtrace"]=> array(7) { [0]=> array(6) { ["file"]=> string(90) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/PEAR.php" ["line"]=> int(945) ["function"]=> string(11) "__construct" ["class"]=> string(10) "PEAR_Error" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> NULL [1]=> string(3) "802" [2]=> NULL [3]=> NULL [4]=> NULL } } [1]=> array(7) { ["file"]=> string(101) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Error.php" ["line"]=> int(52) ["function"]=> string(10) "PEAR_Error" ["class"]=> string(10) "PEAR_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> NULL [1]=> string(3) "802" } } [2]=> array(7) { ["file"]=> string(129) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Parser/FMResultSet.php" ["line"]=> int(48) ["function"]=> string(15) "FileMaker_Error" ["class"]=> string(15) "FileMaker_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } [1]=> NULL [2]=> string(3) "802" } } [3]=> array(7) { ["file"]=> string(122) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/CommandImpl.php" ["line"]=> int(84) ["function"]=> string(5) "parse" ["class"]=> string(28) "FileMaker_Parser_FMResultSet" ["object"]=> object(FileMaker_Parser_FMResultSet)#5 (17) { ["Vcb5e100e"]=> string(3) "802" ["Vf5bf48aa"]=> array(3) { ["build"]=> string(10) "10/27/2016" ["name"]=> string(31) "FileMaker Web Publishing Engine" ["version"]=> string(10) "15.0.3.308" } ["V1ea7e575"]=> array(7) { ["database"]=> string(0) "" ["date-format"]=> string(0) "" ["layout"]=> string(0) "" ["table"]=> string(0) "" ["time-format"]=> string(0) "" ["timestamp-format"]=> string(0) "" ["total-count"]=> string(1) "0" } ["V9f81f3c0"]=> array(0) { } ["Vaae0d98d"]=> array(2) { ["count"]=> string(1) "0" ["fetch-size"]=> string(1) "0" } ["Vae581270"]=> array(0) { } ["V6e52c40b"]=> array(0) { } ["Ve13f1c92"]=> NULL ["V43432a31"]=> NULL ["V51bc3e3b"]=> NULL ["V26005321"]=> NULL ["V6468d939"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["V5431b8d4"]=> resource(28) of type (Unknown) ["V6de51026"]=> bool(false) ["_result"]=> NULL ["_layout"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(563) "" } } [4]=> array(7) { ["file"]=> string(130) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Command/FindAnyImpl.php" ["line"]=> int(17) ["function"]=> string(10) "_getResult" ["class"]=> string(32) "FileMaker_Command_Implementation" ["object"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(563) "" } } [5]=> array(7) { ["file"]=> string(103) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Command.php" ["line"]=> int(137) ["function"]=> string(7) "execute" ["class"]=> string(40) "FileMaker_Command_FindAny_Implementation" ["object"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(7) { ["file"]=> string(64) "/Library/FileMaker Server/HTTPServer/htdocs/newsletter/index.php" ["line"]=> int(32) ["function"]=> string(7) "execute" ["class"]=> string(17) "FileMaker_Command" ["object"]=> object(FileMaker_Command_FindAny)#3 (1) { ["_impl"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } } ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["callback"]=> NULL } Any help would be much appreciated!
  16. Hi, we are using a little sync script via php, which allows us to store all data from a FileMaker DB into our internal MySQL-Database. The only problem iam unable to solve is how to download images from container fields and store them local on our web server. I tried something like: foreach($recordsPersons as $recordPersonsData) { //saving images to /srv/www/htdocs/ $url_orig = urlencode($recordPersonsData->getField('FotoDatei')); // Search for the extension of the file $url = substr($url_orig, 0, strpos($url_orig, "?")); $url = substr($url_orig, strrpos($url_orig, ".") + 1); // Send the correct Content-Type header if($url == "jpg"){ header('Content-type: image/jpeg'); } else if($url == "gif"){ header('Content-type: image/gif'); } else{ header('Content-type: application/octet-stream'); } // save file local. file_put_contents('/srv/www/htdocs/testfilepicture.jpg', $fm->getContainerData($url_orig)); } I was using this reference: http://blog.myfmbutler.com/?p=104 This Code-Snipped works well, but only writes "getContainerData() does not support remote containers" into testfilepicture.jpg.. We are using FileMaker Server 14. Any Ideas? Thanks in advance and Cheers
  17. I am attempting to use Filemaker as an ODBC datasource in place of MySQL. I am currently running PHP 5.5.3 and am attempting to create a PDO that will utilize the Filemaker ODBC connection. However, I am unable to successfully connect to the database as I am getting an error that says "Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /Applications/MAMP/htdocs/OMIS/core/init.php:6 Stack trace: #0 /Applications/MAMP/htdocs/OMIS/core/init.php(6): PDO->__construct('odbcriver={Fi...', 'odbc', 'odbc') #1 {main} thrown in/Applications/MAMP/htdocs/OMIS/core/init.php on line 6" I know that the both the Filemaker ODBC Driver and the DSN for the database exist but I'm still getting the error. The code I'm using to temporarily test the connection is: PHP Code: $dsn = 'odbc:Driver={FileMaker ODBC};Server=localhost;Database=cwp_data;'; $pdo = new PDO($dsn, "odbc", "odbc"); I do have some questions. First, does the 'Server' param need to be where the DSN is configured (localhost in this case) or where the database is hosted (external server). Second, is the PDO being handled correctly here? I am unable to find any resources on using a Filemaker database with the PDO class, so I'm sort of winging it here. I'm still researching the topic so it's entirely possible that I've missed something.
  18. Hi. Some years ago I used FM7 to control a large 'one table' database, but now having acquired FM13, would like to do far more. However considering what I would like to do, videos on Youtube appear suggest that knowing the language behind FM would be very advantageous. What language lends itself to FM... JS, PHP or MYSQL? A few years ago I learned HTML5 and CSS3 to build static webpages, but weighing-up the pluses and minuses of learning the more comprehensive languages of MYSQL and PHP, decided not to learn either as I would rarely use them... but now I am once again using FM, am wondering if it might be beneficial to learn at least one of these languages, but which best compliments FM? Cheers
  19. I am rewriting our 15 satellite offices to be on one web server, instead of individual FMP software solutions. I am rewriting anyway because my files are large and too much code and layouts are not used that happens from 20 years of adding on, it is just time... They will be able to share the database direct, but when it comes to iPad and iPhone, just downloading Filemaker Go and then emailing them the revised smaller designed layouts will give them the data access to the server database, correct? There is no need for webdirect. I would also like to have our customers forms update directly into our database from our website. So, my plan is to use PHP to connect the web data into the same Filemaker Server. Again, no need for webdirect and no need for those additional licenses, correct? Upgrading from Filemaker 12 to Filemaker 13 does not require us to use webdirect? Thanks
  20. jstewart30

    PHP getting blank page

    Running FMS 13 and trying to run a simple PHP page from my website to access a database, but I'm only getting a blank page. Not sure if it's a port forwarding issue or a PHP issue, or something else. If I put my .php file and the includes ("FileMaker.php" file and "FileMaker" folder from the FMS PHP .zip file) in the fmi-test folder on my FM server and access it locally (http://localhost/fmi-test/myphpfile.php), the PHP file works fine and returns data, so I don't think it has any inherent issues, and presumably my FMS is set up correctly. Putting the same .php file and includes on my web server, though, results in a blank page only. The includes are in the same directory as the php file itself. Here's the php file (I've changed the IP address and database names to protect the innocent but they're correct): <?php error_reporting(E_ALL); ini_set('display_errors', 1); include_once('FileMaker.php'); /* have also used require, include, and require_once with no change */ $fm = new FileMaker("MyDatabase", "http://myfilemakerserver:8888", "Admin", ""); /*no password*/ $findCommand = $fm->newFindCommand("MyDatabase"); $findCommand->addFindCriterion("Phone", "303-555-1234"); $findCommand->setRange(0, 1); $result = $findCommand->execute(); if (FileMaker::isError($result)) { echo($result->getMessage()); return; } $record = $result->getFirstRecord(); $name = $record->getField("Customer Name"); $status = $record->getField("Status"); echo("$name - $status"); ?> Infuriatingly I get no errors or feedback, just a blank page when I run this file from my website (but again it works fine locally on the FM server machine). I've confirmed PHP is working on my website as I can do a simple phpinfo() file in the same directory and it runs fine and displays the PHP info. If I direct a web browser to the same "http://myfilemakerserver:8888" (not the real address obviously, but it is port 8888) I get the "Filemaker Database Server Website" page, so the port forwarding seems to be correct. I have port 8888 forwarding to port 80 of my FM Server. I don't have port 443 forwarded to that machine as that's being used for another device on our network, but I assume if I'm not making "https" requests that it should work fine (but maybe that's my problem?). I assume it's just something simple but I've been beating my head against a wall for the better part of the day on this. Any help would be greatly appreciated.
  21. 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 for the custom privileges is the Prospects table then references this global field to control whether they can view/edit records, e.g. Users::gAccountGroup = Prospects:AccountGroup The issue here is that this works when accessing via the FileMaker Pro application on the desktop, but when accessing via the PHP site they cannot see any records, as I'm assuming the issue is that the Users::gAccountGroup global field is not being set and global fields work differently via the PHP site. I can use PHP session variables in place of the FileMaker global fields, but can't see how I can incorporate this into the calculation that is used for the limited access in the Privilege Sets. If anyone has suggestions or has a solution that uses limited access custom privileges I'd love to hear how you solved this problem. thanks, Steve
  22. We have a (fortunately) backup server we are trying to bring up and we testing our PHP/CWP solutions on it as the last step. Up to this point, everything seemed to be working fine: all the canned server tests (well, IWP and CWP) had worked OK; a couple of add-ons appeared to be working fine; client access was good; custom IWP solutions were good. Then we ran into a problem with the CWP solutions that we have. We have a login system where you start at an Index page, it reroutes you Login if you aren't logged in. The initial redirection and showing of the login page works OK. But when you log in, it apparently fails to authenticate you and just returns error: "XML error: Not well-formed (invalid token) at line 1" (or something like that). The failed login attempt doesn't show up in the FMS logs, either. So it is almost as if it isn't even contacting the server. These CWP pages are working fine under the live server (thankfully), which is configured very similarly: Windows 2008 R2 FMSA 12.05 SSL two plugins that run as tomcat processes IIS 7.5 (using URL re-write for HTTPS redirection) We have even had them running on an OSX based server without problems. I think that I discovered the apparent cause of the CWP problems, at least, but I would like to know WHY, and how to fix it if someone knows: I had to remove the 'hostspec' definition from the dbaccess.php file we use. remove the 'hostspec' definition from "dbaccess.php" = works define 'hostspec' in "dbaccess.php" = fails remove the 'hostspec' definition from "dbaccess.php" = works I found this because the canned FMS CWP test does not use a 'hostspec' definition. I suspect that it may have something to do with the php.ini or various other FMS configuration files around there. You see, we didn't have SSL installed at first, but installed it after FMS was setup. So during the installation of SSL, I have previously discovered that there are a few files you have to manually adjust (I posted about them here), even if you do a redeployment. But, it could also be because of some IIS redirection issue, it seems. Any ideas? Thanks, Justin
  23. 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 populated with the submitted values. This single record is returned, including additional values that must be calculated by Filemaker. If there is already an existing record with the same ID, the existing record is compared to the values submitted by the remote server to see how different they are. If the values are the same, or similar enough, then the record is considered a match. The values from the existing Filemaker record are returned. If the ID is the same, but the differences in the other values exceed a certain threshold, then the record is not a match, and an error is returned. The current script works by storing the remotely submitted values in global fields, then operating on those. But globals are session-specific, and from what I've seen, it doesn't look like the PHP API supports persistent sessions. Each transaction seems to be a separate session, so the globals are lost. I've read that it's possible to have globals persist for an entire session with XML or XLSLT, but I suck at XML, and really can't afford the time to learn. Is there a simple way to make globals persist for an entire session with the PHP API? Failing that, is there another simple way for me to use the existing script?
  24. Implementing a set of conditional value lists on a FileMaker layout is a relatively easy task. So, my question is how does one translate this to a PHP solution based on that layout? I understand that it can be done and that Jonathan Stark detailed one method for doing this in an article for the now dead Adviser magazine (an article that I can't seem to find anywhere). Can someone tell me how to get started doing this (getting the second value list field to populate correctly on a PHP created page) or point me in the direction of resources that will help me learn how to complete this task? I need this knowledge for several upcoming projects. Thank you for any and all help that you can provide B-
  25. So, We have a unix admin working on our Mac OSX server. I specifically instructed them not to break our Filemaker 13 Apache install. Well it looks like they worked on the machine but broke one thing. Does anyeone know where I should look to fix this? What works: Webserver servers files fine from the Filemaker HTTP Folders. Filemaker WebDirect works fine. PHP is working. PHP is indicated as ON in FMSA Admin. Admin pages at http://localhost:16001/admin-consolework fine. Admin screen shows green on Webserver. Indicates PHP is enabled. This is the only thing that is not working: Previous PHP pages which has successfull connection to databases no longer connect to the database. I assume that a reference to filemaker somehow got removed from one of the php config files, but I don't know where. Can anyone give me an idea where to look?
×

Important Information

By using this site, you agree to our Terms of Use.