public function update($id, $name) { $query = new MysqlQuery("UPDATE groups\n SET name = \$2\n WHERE id = \$1"); $query->addParam($id); $query->addParam($name); return $query->exec(); }
$query->addParam("admin"); $query->addParam("users"); echo "Info for admin user:\n"; echo "username: "******"firstname: "; $firstname = trim(fgets(STDIN)); echo "lastname: "; $lastname = trim(fgets(STDIN)); echo "password: "******"sha256", trim(fgets(STDIN))); $rand_bits = strongRand(32); $rand_bits = preg_replace('/[\\/=+]/', '', $rand_bits); $rand_bits = substr($rand_bits, 0, 22); $salt = '$2a$07$' . $rand_bits . '$'; $hash = crypt($password, $salt); $query = new MysqlQuery(' INSERT INTO users VALUES (username, firstname, lastname, salt, password) VALUES ($1, $2, $3, $4, $5) '); $query->addParam($username); $query->addParam($firstname); $query->addParam($lastname); $query->addParam($salt); $query->addParam($password);
public function updatePassword($user_id, $new_password) { $salt = $this->genBcryptSalt(); $pass_hash = $this->bcrypt($new_password, $salt); $query = new MysqlQuery('UPDATE users SET salt = $1 , password = $2 WHERE id = $3'); $query->addParam($salt); $query->addParam($pass_hash); $query->addParam($user_id); return $query->exec(); }