个回答

• 哥很傻

  2018-11-25 14:16:32

  字段 createdAt 改成 created_at

  0

• 雨Qi无声

  2017-04-17 11:11:24

        if (empty($username)) {

              throw new Exception('用户名不能为空', ErrorCode::PASSWORD_CANNOT_EMPTY);

          }

          if (empty($password)) {

              throw new Exception('密码不能为空', ErrorCode::PASSWORD_CANNOT_EMPTY);

          }

          if ($this->isUsernameExists($username)) {

              throw new Exception('用户名已经存在', ErrorCode::USERNAME_EXISTS);

          }

          // 写入数据库

          $sql = 'INSERT INTO `user`(`username`, `password`, `createdAt`) VALUES(:username,:password,:ceatedAt)';

          $ceatedAt = time();

          $password = $this->_md5($password);

          

          $stmt = $this->_db->prepare($sql); // 解析sql语句

          

          $stmt->bindParam(':username', $username);

          $stmt->bindParam(':password', $password);

          $stmt->bindParam(':ceatedAt', $ceatedAt);

          

          if (! $stmt->execute()) {

              print $this->_db->errorCode();

              print_r($this->_db->errorInfo());

              throw new Exception('注册失败', ErrorCode::REGISTER_FAIL);

          }

          

          return [

              'id' => $this->_db->lastInsertId(),

              'username' => $username,

              'ceatedAt' => $ceatedAt

          ];

  
  

  0

• 慕莱坞0625554

  2017-04-16 20:02:36

  是不是没commit

  0