本文整理汇总了PHP中Sql::pSelect1d方法的典型用法代码示例。如果您正苦于以下问题:PHP Sql::pSelect1d方法的具体用法?PHP Sql::pSelect1d怎么用?PHP Sql::pSelect1d使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Sql
的用法示例。
在下文中一共展示了Sql::pSelect1d方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getGroups
/** Returns a list of UserGroup objects for all groups the user is a member of */
public static function getGroups($user_id)
{
$q = 'SELECT groupId FROM ' . self::$tbl_name . ' WHERE userId = ?';
$res = Sql::pSelect1d($q, 'i', $user_id);
$groups = array();
foreach ($res as $grp_id) {
$groups[] = new UserGroup($grp_id);
}
return $groups;
}
示例2: getMembers
/**
* @return array of User objects for all group members
*/
function getMembers()
{
if (!$this->id) {
throw new \Exception('no group id set');
}
$res = array();
$q = 'SELECT userId FROM tblGroupMembers WHERE groupId = ?';
foreach (Sql::pSelect1d($q, 'i', $this->id) as $uid) {
$res[] = User::get($uid);
}
return $res;
}
示例3: getIPsByUser
/** @return array of IP's associated with user_id */
public static function getIPsByUser($user_id, $type = LOGIN_INTERNAL)
{
$q = 'SELECT DISTINCT(IP) FROM ' . self::$tbl_name . ' WHERE userId = ? AND type = ?';
return Sql::pSelect1d($q, 'ii', $user_id, $type);
}
示例4: getList
/**
* @return 1d array of owner id's matching name & value
*/
static function getList($name, $value)
{
$q = 'SELECT ownerId FROM tblSettings' . ' WHERE settingType = ? AND settingName = ? AND settingValue = ?';
return Sql::pSelect1d($q, 'iss', USER, $name, $value);
}