/** * 获取列表 */ public function get_list($where = '', $filed = '') { $db = DbConnecter::connectMysql('share_story'); $sql = "select * from {$this->table} where {$where}"; $st = $db->query($sql); $st->setFetchMode(PDO::FETCH_ASSOC); $r = $st->fetchAll(); if ($filed) { $arr = array(); foreach ($r as $k => $v) { $arr[] = $v[$filed]; } return $arr; } else { return $r; } }
/** * 插入记录 */ public function insert($data = '') { if (!$data) { return 0; } $tmp_filed = array(); $tmp_value = array(); foreach ($data as $k => $v) { $tmp_filed[] .= "`{$k}`"; $tmp_value[] .= "'{$v}'"; } $tmp_filed = implode(",", $tmp_filed); $tmp_value = implode(",", $tmp_value); $db = DbConnecter::connectMysql('share_story'); $sql = "INSERT INTO {$this->table}(\n\t\t\t\t\t{$tmp_filed}\n\t\t\t\t) VALUES({$tmp_value})"; $st = $db->query($sql); unset($tmp_value, $tmp_filed); return $db->lastInsertId(); }
public function getMaxUidWithTime($day) { $day = $day + 0; if ($day == 0) { $day = 1; } $db = DbConnecter::connectMysql('share_passport'); $sql = "select * from passport where addtime>? order by uid asc limit 1"; $st = $db->prepare($sql); $st->execute(array(date('Y-m-d H:i:s', time() - 86400 * $day))); $maxuid = $st->fetch(PDO::FETCH_COLUMN); return $maxuid; }
private function writeDataToDb($uid, $action, $beactionid, $actionid, $ua, $addtime) { $actionvalue = $this->actionNameToId($action); if (is_numeric($addtime)) { $addtime = date('Y-m-d H:i:s'); } try { $db = DbConnecter::connectMysql('share_tips'); $sql = "insert into useractionlog (uid,action,beactionid,actionid,ua,addtime) values (?,?,?,?,?,?)"; $st = $db->prepare($sql); $st->execute(array($uid, $actionvalue, $beactionid, $actionid, $ua, $addtime)); } catch (Exception $e) { return false; } }
public function setUserNickname($uid, $nickname) { $NicknameMd5Obj = new NicknameMd5(); $existnicknameuid = $NicknameMd5Obj->checkNameIsExist($nickname); if ($existnicknameuid > 0 && $existnicknameuid != $uid) { $this->setError(ErrorConf::nickNameIsExist()); return false; } else { $NicknameMd5Obj->addOne($nickname, $uid); } $db = DbConnecter::connectMysql('share_user'); $sql = "update `userinfo` set nickname=? where uid={$uid} "; $st = $db->prepare($sql); $st->execute(array($nickname)); $this->clearUserCache($uid); QueueManager::pushUserInfoToSearch($uid); // 添加到审核队列 QueueManager::pushAuditTextAction($uid, 1); QueueManager::pushUserToUpdateUserSysFriendLog($uid); return true; }