SOCIALENGINE:获取用户性别

Question

SocialEngine4:如何使用sql query获取用户性别？

Answer 1

$subject = Engine_Api::_()->core()->getSubject(); //Get user

$fields = $subject->fields()->getFieldsValuesByAlias();
$gender = $fields['gender'];

$this->view->gender = $gender;

Answer 2

使用下面列出的代码：

<?php
$currentUserID=Engine_Api::_()->user()->getViewer()->getIdentity();
$sSqlInviter="select gender from engine4_user_fields_search where item_id=".$currentUserID;
$dbInviterSqli=Zend_Db_Table_Abstract::getDefaultAdapter();
$stmtInviter=$dbInviterSqli->query($sSqlInviter);
$rowInviter=$stmtInviter->fetch();
$gender=$rowInviter['gender'];
if($gender==2) 
  echo "<b> Male</b>";
else
  echo "<b> Female</b>";
?>

Answer 3

$viewer = Engine_Api::_()->user()->getViewer();
$fields = Engine_Api::_()->fields()->getFieldsValuesByAlias($viewer);
echo $fields['gender'];