PHP Da_Wrapper::getOne Beispiele

Beispiel #1

Datei: Regist.php Projekt: ahmatjan/Scene-Editor-for-mobile

 /**
  * 检查是否存在指定的记录
  *
  * @param string $value
  * @param string $colname
  * @return void
  */
 public static function getUid($value, $colname = 'userid')
 {
     $field = array('userid', 'email', 'mobile');
     if (!in_array($colname, $field)) {
         $colname = 'userid';
     }
     $id = Da_Wrapper::getOne(self::DB_NS, "SELECT id FROM ht_users WHERE {$colname} = ?", array($value));
     return $id;
 }

Beispiel #2

Datei: Active.php Projekt: ahmatjan/Scene-Editor-for-mobile

 /**
  * 得到用户数据条数
  * @param int $userid 用户id
  */
 public static function getUserActiveCount($userid, $condition = '1=1')
 {
     $count = Da_Wrapper::getOne(self::DB_TABLE_ACTIVE, "select count(*) as c from {active} where user_id = {$userid} and {$condition}");
     return $count;
 }