本文整理匯總了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);
}