PHPackages                             cschmitz/l5simplefm - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [File & Storage](/categories/file-storage)
4. /
5. cschmitz/l5simplefm

ActiveLibrary[File & Storage](/categories/file-storage)

cschmitz/l5simplefm
===================

A Laravel 5 wrapper for Soliant Consulting's SimpleFM package.

1.0.3(9y ago)105452[1 issues](https://github.com/chris-schmitz/L5SimpleFM/issues)MITPHP

Since Aug 22Pushed 9y ago5 watchersCompare

[ Source](https://github.com/chris-schmitz/L5SimpleFM)[ Packagist](https://packagist.org/packages/cschmitz/l5simplefm)[ Docs](https://github.com/chris-schmitz/L5SimpleFM)[ RSS](/packages/cschmitz-l5simplefm/feed)WikiDiscussions master Synced 3w ago

READMEChangelog (9)Dependencies (1)Versions (12)Used By (0)

L5SimpleFM
==========

[](#l5simplefm)

L5SimpleFM is a tool wrapped around the [Soliant Consulting's SimpleFM package](https://github.com/soliantconsulting/SimpleFM). L5SimpleFM allows you to make declarative queries against a hosted FileMaker database.

This tool has been made specifically for Laravel 5 integration and can be installed via composer from the [packagist repository](https://packagist.org/packages/cschmitz/l5simplefm).

An example Task project built using L5SimpleFM can be found [here on github](https://github.com/chris-schmitz/TaskWithL5SimpleFM).

Readme Contents:

- [Quick Examples](#quick-examples)
- [Required tools](#required-tools)
- [Installation](#installation)
- [Configuration](#configuration)
- [Important Notes](#important-notes)
- [Demo FileMaker Database](#demo-filemaker-database)
- [L5SimpleFM Models](#l5simplefm-model)
- [Commands](#commands)
- [Exceptions](#exceptions)

Quick Examples
==============

[](#quick-examples)

Performing a find on the `web_Users` layout in a FileMaker database for a user with the `web_Users::username` value of **chris.schmitz** and the `web_Users::status` of **active** would look like this:

```
try {
	$searchFields = ['username' => 'chris.schmitz', 'status' => 'active'];
	$result = $fm->setLayout('web_Users')->findByFields($searchFields)->executeCommand();
	$records = $result->getRows();
} catch (\Exception $e) {
	return $e->getMessage();
}
return compact('records');

```

L5SimpleFM also allows you to define Model classes for individual Entities within your FileMaker file. Using the same `web_Users` example above, defining a L5SimpleFM FileMaker model would look like this:

```