[New to OOP - When does a Method get set?]

Thanks

[New to OOP - When does a Method get set?]

 

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;

}

}

[Would like some help with syntax]

I think I have made some progress, but still have something I cannot quite figure out.
From the code below what does this line mean?
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--] if ($row3 = $sql3 -> db_Fetch()){ [/quote]

I usually will do an echo to the page to see what is in an array, but this is not an array from what toplay said above and I cannot figure out out how to see what this holds. I am sure it would help me in figuring out my problem to know what is in there.

I plan to change the code to look for a new item that is being placed in this e107_user_extended table.

[code]
          $sql3=new db;
          $sql3 -> db_Select("e107_user_extended", "*", "online_user_id='".$user_id.".".$user_name."'");


            if ($row3 = $sql3 -> db_Fetch()){


              $text .="<img src=\"".e_PLUGIN."bf2buds_menu/images/online.png\" alt=\"online\"> ";

                                            } else {

              $text .="<img src=\"".e_PLUGIN."bf2buds_menu/images/offline.png\" alt=\"offline\" > ";

                   }
            if ($urname <> "" ) {

            $text.="<a href=\"".e_BASE."user.php?id.$user_id\">".($pref['realname']==1 && $user_login <> "" ? $user_login : $user_name)." [<a href=\"".e_SELF."?delbuddy=".$user_id."\" border=0>".BUDDYLAN_2."</a>]<br>";

                                } else {

            $text.="<a href=\"".e_BASE."user.php?id.$user_id\">".($pref['realname']==1 && $user_login <> "" ? $user_login : $user_name)." [<a href=\"".e_SELF."?delbuddy=".$user_id."\" border=0>".BUDDYLAN_2."</a>]<br>";

                 }
[/code]

[Would like some help with syntax]

Hey thanks toplay. I know I have lots to learn yet. I am using e107 and found that the define("USERID", $result['user_id']); line is located in the class2.php.

Well I am about to loose my mind trying to figure this out...so I am back for some more help.
I am trying to rewrite the following code to do something a little different than what it does as is. Right now it does as it should, gives me a list of site users and let's me know if they are on the site or not.

[code]// Populate the buddy list
    $text="";
    $sql -> db_Select("bf2buds", "bf2buds_buddy", "bf2buds_user=". USERID);
    while(list($bf2buds_id) = $sql-> db_Fetch()){
      $sql2=new db;
      $sql2 -> db_Select("user", "user_login,user_name,user_id", "user_id=".$bf2buds_id);
      if ($row = $sql2 -> db_Fetch()) {
            extract($row);



        $sql3=new db;
            $sql3 -> db_Select("online", "*", "online_user_id='".$user_id.".".$user_name."'");


            if ($row3 = $sql3 -> db_Fetch()){


              $text .="<img src=\"".e_PLUGIN."bf2buds_menu/images/online.png\" alt=\"online\"> ";
              
                                            } else {

              $text .="<img src=\"".e_PLUGIN."bf2buds_menu/images/offline.png\" alt=\"offline\" > ";

                   }
            if ($urname <> "" ) {

            $text.="<a href=\"".e_BASE."user.php?id.$user_id\">".($pref['realname']==1 && $user_login <> "" ? $user_login : $user_name)." [<a href=\"".e_SELF."?delbuddy=".$user_id."\" border=0>".BUDDYLAN_2."</a>]<br>";

                                } else {

            $text.="<a href=\"".e_BASE."user.php?id.$user_id\">".($pref['realname']==1 && $user_login <> "" ? $user_login : $user_name)." [<a href=\"".e_SELF."?delbuddy=".$user_id."\" border=0>".BUDDYLAN_2."</a>]<br>";

                 }

                                     }

                                                 }[/code]

What I am trying to have it do is let me know if a person on my list is playing BF2.

I have a DB(I'll call it BF2) outside of the DB(I'll call it e107) used by this code that as this information in it that I need.

Here is the layout:

[b]DB[/b] : [b]Table[/b] : [b]Columns[/b]
BF2 : players : playername, playerpid
e107 : user : user_id, user_name, login_name
e107 : user_extended : user_extended_id, user_pid, userbf2name
e107 : buddy : buddy_id, buddy_user, buddy_buddy

I think I need at least 2 more $sql -> lines......but have no clue on how to get them working.

I know that:
e107.user.user_id = e107.user_extended.user_extended_id
e107.user_extended.user_pid = BF2.playerpid
e107.user_extended.user_extended_id will get me the user_pid

If anyone could help I would be most grateful!

[Would like some help with syntax]

I am trying to rework someone elses code to fit my needs. Problem is I do not fully understand the way they wrote the code.

See the example:
[code]<? $sql -> db_Select("buddy", "*", "buddy_user=". USERID." AND buddy_buddy=".$_POST['buddy']);?>[/code]


The way I understand is like this...

$sql : is an array

-> : says this is how we are filling the array


db_Select : select the buddy table int the current DB

"*" : get all fields in the row (the table only has 3 columns buddy_id, buddy_user, buddy_buddy)

"buddy_user=". USERID." AND buddy_buddy=".$_POST['buddy'] : This is the part that is throwing me

Mainly the USERID, can someone explain this for me? Where does it come from? Is it just an undeclared local variable?