实现学院内部的统一身份认证系统

CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL UNIQUE,

password VARCHAR(255) NOT NULL,

email VARCHAR(100) NOT NULL UNIQUE

);

]]>

function login($username, $password) {

// 连接数据库...

$stmt = $conn->prepare("SELECT password FROM users WHERE username = ?");

$stmt->bind_param("s", $username);

$stmt->execute();

$result = $stmt->get_result();

if ($result->num_rows > 0) {

$row = $result->fetch_assoc();

if (password_verify($password, $row['password'])) {

return true;

}

}

return false;

}

迎新管理软件

]]>