PHP sqlRow Examples

Example #1

File: funcoesSQL.php Project: tacira-tech/tacops-portal

function sqlTop($tp, $st, $ps = array(), $logIt = false)
{
    $busca = sqlQuery($tp, $st, $ps, $logIt);
    if ($busca['error'][2]) {
        echo $busca['error'][2];
    }
    return $busca['count'] >= 1 ? sqlRow($busca['rows'][0]) : false;
}

Example #2

File: m.class.php Project: lincong1987/lanbowang

 public function ModiPassword()
 {
     if (!$this->isLogin()) {
         $this->addActionError("ModiPassword", "用户没有登录");
         return parent::ERROR;
     }
     $oldPwd = isset($_REQUEST['oldPwd']) ? $_REQUEST['oldPwd'] : "";
     if (empty($oldPwd)) {
         $this->addActionError("ModiPassword", "旧密码没有填写");
         return parent::ERROR;
     }
     $newPwd = isset($_REQUEST['newPwd']) ? $_REQUEST['newPwd'] : "";
     $newPwd_1 = isset($_REQUEST['newPwd_1']) ? $_REQUEST['newPwd_1'] : "";
     if (empty($newPwd_1) || empty($newPwd) || $newPwd_1 != $newPwd) {
         $this->addActionError("ModiPassword", "新密码可能没有填写");
         $this->addActionError("ModiPassword", "两次填写的新密码可能不一致");
         return parent::ERROR;
     }
     if ($oldPwd == $newPwd) {
         $this->addActionError("ModiPassword", "你填写的新密码与就密码一致");
         return parent::ERROR;
     }
     $sql = "select id, pwd from " . $this->mysqlConfig["db_perfix"] . "user where id = '{$_SESSION["user_arr"]["id"]}'";
     $rs = sqlRow($sql);
     if ($rs["pwd"] != md5($oldPwd)) {
         $this->addActionError("ModiPassword", "旧密码填写错误");
         return parent::ERROR;
     }
     $sql = "update " . $this->mysqlConfig["db_perfix"] . "user set pwd = '" . md5($newPwd) . "' where id = '{$rs["id"]}'";
     $rs = sqlExecute($sql);
     return $rs ? parent::SUCCESS : parent::ERROR;
 }