e-mail : customdataservicesinfo@gmail.com
Claris FileMaker, Microsoft Excel, and Adobe Acrobat can all utilize PHP, PDO, and cURL to enable asynchronous interactions with SQL databases or REST APIs.
Forms created with these applications can use calculations to format and native functions to send user-supplied query parameters to PHP scripts that use the parameters to look-up information, execute Create-Read-Update-Delete transactions, call stored procedures, or interact with combinations of REST APIs, and then filter and return query results to the form in real-time.
Efficient 2-way interactions, triggered as users insert, update, select or click; calculating, querying, filtering, and recalculating as the form is completed.
Each type of form provides different features, capabilities, and functionalities. Forms can work independently or communicate with other forms in processes. Any form can interact with any mixture of databases or APIs in any sequence.
Claris FileMaker provides advanced form generation and hosting capabilities, with integrated authentication, calculation and script engines, process automation tools, and multi-user session management. FileMaker forms can be securely shared with up to 1,000 users via Windows or Apple desktop app or WebDirect forms. FileMaker forms can be extended with PHP, PDO, cURL to enable real-time data exchanges with SQL databases or APIs.
Microsoft Excel spreadsheets can use the WEBSERVICE() function to dynamically execute queries on SQL databases or REST APIs, returning filtered results to active cells without requiring local ETL processes. PHP scripts can return scalar or aggregate results as text, JSON, or XML, updating dynamic arrays and linked spreadsheet calculations in the process. Spreadsheets can optionally be converted to dynamic HTML forms with SpreadsheetConverter.
Adobe Acrobat Reader forms can be used as programmable interaction runtimes. Documents converted to PDF forms can send query parameters to PHP scripts that interact with databases or APIs and return filtered results to designated form fields in real-time. Acrobat Reader forms are more securable than HTML forms because they are not susceptible to XSS, CSRF, or session attacks and can be password protected, encrypted, flattened, and digitally signed.
PHP is a popular general purpose server scripting language, currently used on approximately 75% of websites globally. PHP Data Objects and cURL code libraries provide simple, scriptable, securable methods for dynamically performing or scheduling SQL or REST API interactions. PHP is open-source technology, meaning no licensing costs, transaction fees, or subscriptions are required to own and use simple, reliable, industrial strength code.
PHP Data Objects (PDO) provide securable and comparatively injection-resistant methods for managing user interactions with MySQL, Oracle, PostgreSQL, or SQL Server databases. The PDO data-access abstraction layer maps filtered and typed query input parameters to placeholders in SQL prepared statement templates, executes queries or transactions based on the parameters, processing and returning formatted query results in real-time.
PHP incorporates libcurl, a versatile code library that simplifies connections and real-time interactions with REST APIs, among a wide variety of other things. Like a digital Swiss Army knife, libcurl provides scriptable methods for connection and interaction tasks involving http, https, ftp, gopher, telnet, dict, file, or ldap protocols, HTTPS certificates, HTTP POST, HTTP PUT, FTP or HTTP file uploads, proxies, cookies, or resource or directory user authentication.
