/** * @covers \airmoi\FileMaker\FileMaker::newAddCommand */ public function testNewAddCommand() { $command = $this->fm->newAddCommand('sample', ['text_field' => 'Test 1']); if (!$GLOBALS['OFFICIAL_API']) { $this->assertInstanceOf(Command\Add::class, $command); } else { $this->assertInstanceOf(\FileMaker_Command_Add::class, $command); } $command->setField('date_field', date('m/d/Y')); $result = $command->execute(); if (!$GLOBALS['OFFICIAL_API']) { $this->assertInstanceOf(Object\Result::class, $result); } else { $this->assertInstanceOf(\FileMaker_Result::class, $result); } $record = $result->getFirstRecord(); if (!$GLOBALS['OFFICIAL_API']) { $this->assertInstanceOf(Object\Record::class, $record); } else { $this->assertInstanceOf(\FileMaker_Record::class, $record); } $this->assertEquals('Test 1', $record->getField('text_field')); return ['recid' => $record->getRecordId(), 'tableCount' => $result->getTableRecordCount()]; }
ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); require_once 'db.php'; require_once 'vendor/FileMaker.php'; $fm_file = 'TestingMaddox'; $fm_host = '54.246.190.236'; $fm_user = '******'; $fm_pass = '******'; $layout_name = 'a.webXML'; $fm = new FileMaker($fm_file, $fm_host, $fm_user, $fm_pass); //var_dump($fm->getLayout($layout_name)->listFields()); $sql = 'select * from data where status = 0'; $query = mysql_query($sql); while ($row = mysql_fetch_assoc($query)) { $cmd = $fm->newAddCommand($layout_name); $cmd->setField('email', $row['email']); $cmd->setField('nameTitle', $row['title']); $cmd->setField('nameFirst', $row['fname']); $cmd->setField('nameSurname', $row['lname']); $cmd->setField('sourceID', $row['maddox_id']); $cmd->setField('fKeyOpener', $row['opener_id']); $cmd->setField('fKeyCampaign', 431); $cmd->setField('fKeyMailchimp', $row['web_id']); $cmd->setField('leadQualityRating', $row['lead_quality']); // $cmd->setField('userOpener.clients::fullName', $row['opener_name']); // $cmd->setField('campaignCode', $row['campaign_name']); Field cannot be modified $cmd->setField('address1', $row['address_1']); $cmd->setField('address2', $row['address_2']); $cmd->setField('addressPostcode', $row['address_postcode']); $cmd->setField('addressTown', $row['address_town']);