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(); }
users_id INT NOT NULL, groups_id INT NOT NULL, INDEX users_groups_users_in (users_id), INDEX users_groups_groups_in (groups_id) ) '); $query->exec(); $query = new MysqlQuery(' CREATE TABLE session ( id CHAR(40) NOT NULL PRIMARY KEY, data VARCHAR(8192), last_access DATETIME NOT NULL, INDEX session_access_in (last_access) ) '); $query->exec(); $query = new MysqlQuery(' INSERT INTO groups (name) VALUES ($1), ($2) '); $query->addParam("admin"); $query->addParam("users"); echo "Info for admin user:\n"; echo "username: "******"firstname: "; $firstname = trim(fgets(STDIN)); echo "lastname: ";
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(); }