Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


FileMaker and PHP Foundations


FileMaker and PHP Foundations, Singapore SKillsFuture elarning online course

Course Description

PHP is the most widely used scripting language on the web. It's accessible, well documented, and easy to learn. When FileMaker Inc. released their API for PHP a new door was opened to build rich web applications that interact with FileMaker Pro databases. This VTC course will introduce you to the PHP language, FileMaker's API for PHP, and best practices for Custom Web Publishing with PHP.

Discover how data can be managed efficiently with PHP.

- Find out how you can manage your database
- Learn ways to fully utilize your data's potential
- Know how PHP can be implemented to run the data better
- Understand how PHP is an effective solution to optimizing your database's productivity

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Understand how FileMaker and PHP work hand in hand 
2. Understand the foundations of PHP 
3. Know how to apply codes to retrieve data 
4. Know how to apply codes such as - performing finds, working with records, custom functions 


Related Courses

  • Microsoft Visual Basic for Applications (VBA)

    Microsoft Visual Basic for Applications (VBA)

    SGD $45.00

    Course Description

    The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.

    Read more...

  • Learn about Digital Audio with Steinberg Nuendo 5

    Learn about Digital Audio with Steinberg Nuendo 5

    SGD $49.00

    Course Description

    Steinberg's Nuendo 5 is the latest update to the popular professional digital audio post-production software. In this VTC course, author Mark Struthers will demonstrate the program's system requirements before looking at how to make initial input and output connections that allow Nuendo to communicate with microphones, synths, and soundcard hardware. He intentionally declutters Nuendo's project window so that you can focus on the track in hand instead of getting distracted by large complex projects. As the course progresses, Mark will guide you through specific tasks and functions, such as creating projects, archiving, audio editing, using markers and much more, so that techniques and tips can be absorbed quickly. Be able to produce music recording, arranging and editing with Steinberg. - Learn how to work with audio files using Steinberg- Know how Steinberg works as an audio editing software- Enable yourself to be able to produce your own music with Steinberg - Learn about the different techniques used in Steinberg to achieve quality audioThis course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft Visual Basic for Access 2010

    Microsoft Visual Basic for Access 2010

    SGD $40.00

    Course Description

    Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course 

    Read more...


Content

Introduction

Preview Available

+

Welcome

The Development Environment

Static Web Publishing

Dynamic Web Publishing with PHP

PHP Basics

Preview Available

+

Code Basics

Variable Basics

Working with Text

PHP Settings

Include and Require

Redirects and Resources

PHP Flow Control

+

Selection with IF

Selection with SWITCH

While Loop

For Loop

Foreach Loop

Continue and Break

Exiting Scripts

Logging Errors

FileMaker and PHP

+

Ready Your Files

Ready Your Server

Ready Your HTML Skills

Ready Your FileMaker API for PHP

Talking to FileMaker pt. 1

Talking to FileMaker pt. 2

PHP Arrays

+

Numeric Arrays

Associative Arrays

Explode and Implode

Multidimensional Arrays

Arrays from FileMaker

Traversing Arrays pt. 1

Traversing Arrays pt. 2

Array Reference

Performing Finds

+

Data Lists and Tables

Command Functions

Find Commands

Building Your Layout

Adding Find Criteria

Working with Results

Working with Records

Trapping for Errors

Building Your Form

Form Processing pt. 1

Form Processing pt. 2

HTML Formatting

Intermediate Find Techniques

+

Displaying Select Menus

FileMaker Value Lists

Select List Triggered Finds

Drill Down Finds pt. 1

Drill Down Finds pt. 2

Drill Down Finds pt. 3

Sorts / Scripts / Results

+

Sorting Records

Limiting Results

Result Layout

Perform Script pt. 1

Perform Script pt. 2

Script Parameters pt. 1

Script Parameters pt. 2

Script Results pt. 1

Script Results pt. 2

Script Results pt. 3

Related Records and Compound Finds

+

Related Fields

Displaying Portals pt. 1

Displaying Portals pt. 2

Compound Finds pt. 1

Compound Finds pt. 2

Compound Finds pt. 3

Compound Find with Omit

Custom Functions

+

Format and Declaration

Passing Variables

GOBAL Scope and Results

Work with Records

+

Creating the Form

Creating Records pt. 1

Creating Records pt. 2

Editing Records pt. 1

Editing Records pt. 2

Creating Related Records

Deleting Related Records

Deleting Records

Working with Container Data

+

Displaying Container Data

Exporting Container Data

Formatting Output Data

+

Formatting Text

Formatting Numbers

Formatting Date and Time

Summarizing Data

+

Intro to Sub Summary Design

Build Layouts and Finds

Multi-Dimensional pt. 1

Multi-Dimensional pt. 2

Sub Summary Totals

Grand Totals

Record Formatting pt. 1

Record Formatting pt. 2

Dynamic Data

Dynamic Value List

Dynamic Sort

Dynamic Summary

Conclusion

+
Resource Files

Course Wrap Up

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $45.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.