在进入这道题目之前,有提示说是SQL约束,这是什么鬼,,,,于是就有以下的。。。。。
什么是SQL约束:
这是注册页面代码:
<?php
// Checking whether a user with the same username exists
$username = mysql_real_escape_string($_GET['username']);
$password = mysql_real_escape_string($_GET['password']);
$query = "SELECT *
FROM users
WHERE username='$username'";
$res = mysql_query($query, $database);
if($res) {
if(mysql_num_rows($res) > 0) {
// User exists, exit gracefully
.
.
}
else {
// If not, only then insert a new entry
$query = "INSERT INTO users(username, password)
VALUES ('$username','$password')";
.
.
}
}
这是登陆页面的代码:
<?php
$username = mysql_real_escape_string($_GET['username']);
$password = mysql_real_escape_string($_