create table user (
username varchar(16) primary key,
passwd char(40) not null,
email varchar(100) not null
);
create table bookmark (
username varchar(16) not null,
bm_URL varchar(255) not null,
index (username),
index (bm_URL)
);
grant select, insert, update, delete
on bookmarks.*
to bm_user@localhost identified by 'password'; 4、实现基本的网站 4.1 login.php
4.2 bookmark_fns.php
5、实现用户身份验证 5.1 register_form.php
5.2 register_new.php
16))
{
throw new exception('Your password must be between 6 and 16 characters Please go back and try again.');
}
//尝试注册
register($username,$email,$passwd);
//注册会话变量
$_SESSION['valid_user'] = $username;
//提供成员页面链接
do_html_header('Registration successful'); //HTML标题
echo 'Your registration was successful.Go to the members page to start setting up your bookmarks!'; //输出URL
do_html_URL('member.php','Go to members page'); //HTML页脚
do_html_footer(); //HTML页脚
}
catch(exception $e)
{
do_html_header('Problem:');
echo $e->getMessage();
do_html_footer();
exit;
}
?>
5.3 member.php