private static function getIdByEmail($email) { $what = "id"; $tblName = "user"; $attributes = array("email"); $values = array($email); $sql = Request::select($what, $tblName, $attributes, $values); $data = mysqli_query(Database::$link, $sql); $row = mysqli_fetch_assoc($data); mysqli_free_result($data); return $row[$what]; }
public static function getAll() { $what = "*"; $tblName = "question"; $attributes = array(); $values = array(); $sql = Request::select($what, $tblName, $attributes, $values); $data = mysqli_query(Database::$link, $sql); $ret = array(); while ($row = mysqli_fetch_assoc($data)) { $ret[] = $row; } return $ret; }
/** * @transaction * * @param User $aUser * * @return Logics_Result */ public function updateSettings(User $aUser) { $result = new Logics_Result(); $result->aUser = $aUser; if ($errors = $this->validateModel($aUser)) { return $result->setErrors($errors); } $aUser->save(); if (!$aUser->private_flag) { $request = new Request(); if ($requests = $request->select("request_id", $aUser->id)) { foreach ($requests as $aRequest) { $aFollower = new Follower(); $aFollower->save(array("user_id" => $aRequest->user_id, "follow_id" => $aRequest->request_id, "created_at" => now())); $aRequest->delete(); } } } return $result; }