PHP UserStore::getIDFromName Examples

Example #1

File: DebtStore.class.php Project: nacho/tareas

 public function addDebt($user1, $user2, $amount, $description)
 {
     $userStore = new UserStore($this->db);
     $idUser1 = $userStore->getIDFromName($user1);
     $idUser2 = $userStore->getIDFromName($user2);
     $this->dbQuery("INSERT INTO `tareas`.`debt` (`idDebt`, `idUser1`, `idUser2`, `amount`, `description`) VALUES (NULL, '" . $idUser1 . "', '" . $idUser2 . "', '" . $amount . "', '" . $description . "')");
     return $this->getInsertID();
 }

Example #2

File: TaskStore.class.php Project: nacho/tareas

 public function modifyTask($user, $week, $task)
 {
     $userStore = new UserStore($this->db);
     $id = $userStore->getIDFromName($user);
     $this->dbQuery("UPDATE task SET `IdUser` = '" . $id . "' WHERE week='" . $week . "' AND name='" . $task . "'");
 }