我正在研究一个简单的用户登录系统,以在我自己的机器上进行练习。
我有一个用户名,密码和电子邮件的MySQL表用户。我能够通过以下方式注册新用户:
//short variable names:
$email = $_POST['email'];
$username = $_POST['username'];
$password = $_POST['password'];
$password2 = $_POST['password2'];
session_start();
//attempt to register
register($username, $email, $password);我创建了这个函数来输入数据库它使用以下函数:
function register($username, $email, $password){
//register new person with db
//return true or error
//connect to db
$db = db_connect();
//check if username is unique
$result = $db->query("SELECT * from user where username = '".$username."'");
if(!$result){
throw new Exception('Could not execute query');
}
if($result->