I had a look at the tutorial and was not impressed. Also the comments were not fully answered.
I managed to get the demo to work after amending numerous errors.
Here is the users table structure that does save, validate, display members, etc.
Copy and paste the SQL into your "http://localhost/phpMyAdmin" and at least your user table will be good.
DROP TABLE IF EXISTS users;
CREATE TABLE IF NOT EXISTS users (
id int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
username varchar(18) NOT NULL,
`password` varchar(512) NOT NULL,
email varchar(64) NOT NULL,
email_code varchar(64) NOT NULL,
`time` int(11) NOT NULL,
confirmed int(4) NOT NULL,
ip varchar(32) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;