oo*hiJ&A'; $fm = new FileMaker(); //$fm->setProperty('hostspec', $config_host); $fm->setProperty('database', $config_db); $fm->setProperty('username', $config_username); $fm->setProperty('password', $config_password); // Grab the Waiver text from the Settings Layout $waiver =& $fm->newFindAnyCommand('Settings')->execute()->getFirstRecord(); $findCommand =& $fm->newFindCommand('CWP_CourseDetail'); $findCommand->addFindCriterion('pk', '==' . $record_key); // $findCommand->addFindCriterion('OnlineRegistration', '==1'); //$findCommand->addFindCriterion('CWP_Teachers::Active_Teacher_2', '==Active'); //$findCommand->addFindCriterion(-maxrecords, 'All'); $result = $findCommand->execute(); if (FileMaker::isError($result)) { print '

Error: ' . $result->getMessage() . '

'; } else { $record = $result->getFirstRecord(); $record_info = array ( 'id' => $record->getField('pk'), 'course_subject' => $record->getField('CWP_Courses::CourseSubject'), 'course_name' => trim($record->getField('CourseName_ScheduleInternetRegistration')), 'days' => $record->getField('c_Days_Scheduled_Title'), 'start_date' => $record->getField('Start_Date'), 'stop_date' => $record->getField('Stop_Date'), ##8.04.20cg - I tried adding the min/max, but I can't seem to make it work. //'MinMax' => $record->getField('MinMax'), 'start_time' => date('g:i a', strtotime($record->getField('StartTime'))), 'stop_time' => date('g:i a', strtotime($record->getField('StopTime'))), 'district' => trim(mb_convert_case($record->getField('c_District'), MB_CASE_TITLE, "UTF-8")), 'school' => trim(mb_convert_case($record->getField('CWP_School::School'), MB_CASE_TITLE, "UTF-8")), 'teacher' => $record->getField('CWP_Teachers::cFirstLast'), 'course_description' => $record->getField('CWP_Courses::CourseDescriptionInternet'), 'logo' => $record->getField('CWP_Courses::CourseLogo'), 'currently_enrolled' => $record->getField('CWP_DailyScheduleDisplay::Student_Count_Enrolled'), 'address' => trim(mb_convert_case($record->getField('CWP_School::Address'), MB_CASE_TITLE, "UTF-8")), 'city' => trim(mb_convert_case($record->getField('CWP_School::City'), MB_CASE_TITLE, "UTF-8")), 'state' => trim(mb_convert_case($record->getField('CWP_School::State'), MB_CASE_UPPER, "UTF-8")), 'zip' => $record->getField('CWP_School::Zip'), 'grade_levels' => $record->getField('Grade Levels'), 'cost' => money_format('%n', $record->getField('Flyerfee_Total')), 'cost_num' => $record->getField('Flyerfee_Total'), 'other_reg_note' => $record->getField('CourseOtherRegistration'), 'redir_url' => $record->getField('CourseURL'), ); #2/8/22cg - I changed the text from 'tournaments: chess' to 'Chess Tournaments'; 'tournaments: lego' to 'Brick Builders Decathlon'; and 'tournaments: fencing' to 'Fencing Tournaments'. I did this to match the nomenclature change within the database. if (strtolower($record_info['course_subject']) == 'chess tournaments' || strtolower($record_info['course_subject']) == 'brick builders decathlon' || strtolower($record_info['course_subject']) == 'fencing tournaments') { $record_info['school_required'] = 'y'; } else { $record_info['school_required'] = 'n'; } } if ($record_info['redir_url'] != '') { header('Location: ' . $record_info['redir_url']); exit; } ?>

| Fee:

Grade/Age Levels:

From: to ; - ; Location:

Currently Enrolled:

'; print ''; print $record_info['other_reg_note']; print '

'; } else { ?>

Fill out student and payment information below to register for this course. Required information is indicated with a (*).

After you click the ENROLL button, you will receive an email confirming your registration.

'; } ?>

Enrollment Information

Student First Name

Last Name

Grade

School Name'; print ''; print '

'; } ?>

Current Teacher

Parent First Name

Last Name

Phone

Email Address

Special Needs or Notes

Payment Information

Name on Credit Card

Address 1

Address 2

City

State

Zip Code

Credit Card Number

Credit Card Exp

CSV Code

Your card will be charged

By enrolling you agree with the {YEL!} Waiver and Release Form. CLICK HERE to view the waiver.

getField('WaiverForm'); ?>