我制作了一個(gè)帶有注冊/登錄系統(tǒng)的網(wǎng)站，我也想制作一個(gè)管理面板。我給了我的帳戶管理員用戶類型 (mysql)，但我不知道如何在登錄時(shí)檢查用戶類型。這是我檢查登錄的身份驗(yàn)證代碼（echos 有匈牙利語文本不關(guān)心）：session_start();$DATABASE_HOST = 'sql305.epizy.com';$DATABASE_USER = 'epiz_25331636';$DATABASE_PASS = 'q1SI3G8B0s';$DATABASE_NAME = 'epiz_25331636_accounts';$con = mysqli_connect($DATABASE_HOST, $DATABASE_USER, $DATABASE_PASS, $DATABASE_NAME);if ( mysqli_connect_errno() ) { exit('Failed to connect to MySQL: ' . mysqli_connect_error());}if ( !isset($_POST['username'], $_POST['password']) ) { exit('Felhasználónév és jelszó is szükséges!');}if ($stmt = $con->prepare('SELECT id, password FROM accounts WHERE username = ?')) { $stmt->bind_param('s', $_POST['username']); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 0) { $stmt->bind_result($id, $password); $stmt->fetch(); if (password_verify($_POST['password'], $password)) { session_regenerate_id(); $_SESSION['loggedin'] = TRUE; $_SESSION['name'] = $_POST['username']; $_SESSION['id'] = $id; header('Location: home.php'); } else { echo "<script type='text/javascript'>alert('Helytelen jelszó');window.location='index.html';</script>"; }} else { echo "<script type='text/javascript'>alert('Helytelen felhasználónév');window.location='index.html';</script>"; } $stmt->close();}?>
1 回答
炎炎設(shè)計(jì)
TA貢獻(xiàn)1808條經(jīng)驗(yàn) 獲得超4個(gè)贊
假設(shè)每個(gè)用戶都有一個(gè)usertype字段，其中包含管理員的“admin”，您可以執(zhí)行以下操作：
if ($stmt = $con->prepare('SELECT id, password, usertype FROM accounts WHERE username = ?')) {
$stmt->bind_param('s', $_POST['username']);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
$stmt->bind_result($id, $password, $usertype);
$stmt->fetch();
if (password_verify($_POST['password'], $password)) {
session_regenerate_id();
$_SESSION['loggedin'] = TRUE;
$_SESSION['name'] = $_POST['username'];
$_SESSION['id'] = $id;
if($usertype == "admin"){
header('Location: adminpanel.html')
} else {
header('Location: home.php');
}
} else {
echo "<script type='text/javascript'>alert('Helytelen jelszó');
window.location='index.html';
</script>";
}
}
就像已經(jīng)提到的那樣，如果正在使用，請盡快更改憑據(jù)。
- 1 回答
- 0 關(guān)注
- 129 瀏覽
添加回答
舉報(bào)
0/150
提交
取消