New to OOP - When does a Method get set?

[cybertick]

 

I am trying to insert the current Date/Time into mysql database using the following code.

 

I do not understand how $submitDate &  $submitTime are to be set.

 

Will this work as coded?

 

 
<?php

class SubmitDateRecord {

  const DB_TABLE = 'timesheet';
const DB_FIELD_SUBMIT_TIME = 'submit_time';


private $submitDate;
private $submitTime;


public function setSubmitDate($submitDate) {
    $this->submitDate = $submitDate;
}

public function getSubmitDate() {
    return $this->submitDate;
}

public function setSubmitTime($submitTime) {
    $this->submitTime = $submitTime;
}

public function getSubmitTime() {
    return $this->submitTime;
}



public function addRecord() {

   	$insertTable = "`".self::DB_TABLE."`";
       
	$insertFields[] = "`".self::DB_FIELD_SUBMIT_TIME."`";

	$insertValues[] = "'{$this->submitDate} {$this->submitTime}'";
           

	$sqlBuilder = new SQLQBuilder();
	$query = $sqlBuilder->simpleInsert($insertTable, $insertValues, $insertFields);

	$dbConnection = new DMLFunctions();
	$result = $dbConnection->executeQuery($query);

	if ($result) {
	    return true;
	} else {
	    return false;
	}

}


private function _buildRecordObjects($result) {

	while ($row = mysql_fetch_array($result)) {

		$submitdateObj = new SubmitDateRecord();

		$submitdateObj->setAttendanceId($row['attendance_id']);
		$submitdateObj->setEmployeeId($row['employee_id']);

		/* $row['submit_time'] comes in '0000-00-00 00:00:00' format.
		 * We want date in '0000-00-00' format and time in '00:00' format.
		 */
		$tmpArr = explode(' ', $row['submit_time']);
		$submitdateObj->setSubmitDate($tmpArr[0]);
		$submitdateObj->setSubmitTime(substr($tmpArr[1], 0, 5)); // Omiting 'seconds' part is ok since it is always zero








		$submitdateObj->setStatus($row['status']);



		$submitdateArr[] = $submitdateObj;

	}

	return $submitdateArr;

}

}

[Stooney]

<?php
$sdr=new SubmitDateRecord();
$sdr->setSubmitDate('the date');
$sdr->setSubmitTime('the time');
$sdr->addRecord();
?>

[cybertick]

Thanks