php+MySQL實現(xiàn)登錄時驗證登錄名和密碼是否正確，mysql登錄名_PHP教程
Jul 12, 2016 am 08:52 AM
php+MySQL實現(xiàn)登錄時驗證登錄名和密碼是否正確，mysql登錄名
直入主題，先看php校驗登錄名和密碼是否正確的代碼：
<?php
$servername = "服務(wù)器名";
$username = "賬戶名";
$password = "密碼";
$dbname = "數(shù)據(jù)庫名";
?>
<?php
// Session需要先啟動。
session_start();
//判斷uname和pwd是否賦值
if(isset($_POST['uname']) && isset($_POST['pwd'])){
$name = $_POST['uname'];
$pwd = $_POST['pwd'];
//連接數(shù)據(jù)庫
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
//驗證內(nèi)容是否與數(shù)據(jù)庫的記錄吻合。
$sql = "SELECT * FROM test_students_all WHERE (student_name='$name') AND (password='$pwd')";
//執(zhí)行上面的sql語句并將結(jié)果集賦給result。
$result = $conn->query($sql);
//判斷結(jié)果集的記錄數(shù)是否大于0
if ($result->num_rows > 0) {
$_SESSION['user_account'] = $name;
// 輸出每行數(shù)據(jù)
while($row = $result->fetch_assoc()) {
echo '<p>' . $row['student_nbr'] . '<br/>' . $row['student_name'] . '(' . $row['sex'] . ')' . '<br/>' . $row['class'] . '<br/>' . $row['major'].'</p>';
// <p><img src="/static/imghw/default1.png" data-src="student_images/CLASS/STUDENT_NBR.jpg" class="lazy" / alt="php+MySQL實現(xiàn)登錄時驗證登錄名和密碼是否正確，mysql登錄名_PHP教程" ></p>
echo '<p><img src="/static/imghw/default1.png" data-src="http://www.bkjia.com/uploads/allimg/160513/0109564S6-0.jpg?2016410141257" class="lazy" . $row['class'] . '/' . $row['student_nbr'] . '.jpg" / alt="php+MySQL實現(xiàn)登錄時驗證登錄名和密碼是否正確，mysql登錄名_PHP教程" ></p>';
}
} else {
echo "沒有您要的信息";
}
$conn->close();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>登錄校驗</title>
</head>
<body>
<p>
<?php
// isset(xx) 測試xx是否設(shè)置了
if(isset($_SESSION['user_account'])){
echo '你好，' . $_SESSION['user_account'];
}
else{
echo '游客';
}
//$conn->close();
?>
</p>
<form method="POST">
<input type="text" name="uname" placeholder="用戶名" />
<br />
<input type="password" name="pwd" placeholder="密碼" />
<br />
<input type="submit">
</form>
</body>
</html>
效果圖：
以上就是本文的全部內(nèi)容，希望對大家學(xué)習(xí)php程序設(shè)計有所幫助。
? AI ??
Undress AI Tool
??? ???? ??
Undresser.AI Undress
???? ?? ??? ??? ?? AI ?? ?
AI Clothes Remover
???? ?? ???? ??? AI ?????.
Clothoff.io
AI ? ???
Video Face Swap
??? ??? AI ?? ?? ??? ???? ?? ???? ??? ?? ????!
?? ??
??? ??
???++7.3.1
???? ?? ?? ?? ???
SublimeText3 ??? ??
??? ??, ???? ?? ????.
???? 13.0.1 ???
??? PHP ?? ?? ??
???? CS6
??? ? ?? ??
SublimeText3 Mac ??
? ??? ?? ?? ?????(SublimeText3)
PHP? ?? ?? ?? (ORM) ?? ??
Jul 29, 2025 am 05:00 AM
N 1 ?? ??? ??? ?? ???? ?????? ?????? ?? ?? ????. 2. ???? ???? ???? ?? ??? ???????? ??? ??? ?? ? ??????. 3. ??? 2 ? ?? ?? Redis ?? ??? ?? ??? ?? ?? ??? ????? ??????. 4. ??? ????? ????? ????? Clear ()? ???? ???? ?????? ??? ????? ?????. 5. ?????? ??? ????? ???? ???? ? ??? ??? ?? ?? ? SQL ?? ??????. 6. ?? ??? ???? ?? ?????? ?? ?? ??? ?????? ?? ?? ?? ??? ???? ??? ??????. ORM? ???? ????? ?? ??? ????? ?? ???? ??? ???? ?? SQL ????, ??, ?? ?? ? ??? ???? ???????.
vscode settings.json ??
Aug 01, 2025 am 06:12 AM
settings.json ??? ??? ?? ?? ?? ?? ?? ??? ??? VSCODE ??? ??? ???? ? ?????. 1. ??? ?? ?? : Windows? C : \ Users \\ AppData \ Roaming \ Code \ User \ Settings.json, MacOS IS /users//library/applicationsupport/code/user/settings.json, linux? /home//.config/code/user/settings.json; 2. Workspace ?? ?? : .vscode/settings project root ????
PHP? ?? ??? ?? ????? ?? ?? ???
Jul 28, 2025 am 04:44 AM
PHP? ??? ?? ????? ?? ??? ??????????? ?? ??? ???? ?? ?? ??? ????????. 1. ?? ??? ??? ?? ??? ?? ? ?? ???? ?????. 2. ?? ???? ???? ???? ?? ? ? ???? GC? ?? ????? ???? ?????. 3. "??? ??"zval? ?? ?? ????? ???? GC_COLLECT_CYCLES ()? ?? ? ? GC? ??????. 4. ?? ?? PHP ?? ????? ??? ??? ??? ?? GC_STATUS ()? ?????? GC_COLLECT_CYCLES ()? ? ??? ???????. 5. ?? ???? ?? ??? ??? GC_DISABLE ()? ???? ?? ? ??? ????? ORM? CLER () ???? ?? DeReeference ??? ?????.
Serverless Revolution : BREF? ???? ?? ??? PHP ?? ????? ?????
Jul 28, 2025 am 04:39 AM
BREF? ?? PHP ???? ??? ???? ?? ?? ???? ?? ???? ?? ????? ?? ? ? ????. 1. Bref? ??? ? PHP ??? ???? ???? PHP8.3 ? ?? ??? ???? Laravel ? Symfony? ?? ??? ??? ???? ???? PHP? Awslambda? ?????. 2. ?? ???? ??? ????? : Composer? ???? BREF ??, HTTP ?? ??? ? ?? ??? ?? ?? ? ???? ???? ?? Serverless.yml ??; 3. ServerlessDeploy ??? ???? ??? ???? APIGINGWARE? ???? ???? ??? URL? ?????. 4. Lambda ??? ?? Bref? ???? ?????.
Readonly ???? PHP? ??? ??? ?????
Jul 30, 2025 am 05:40 AM
readOnlyPropertiesInphp8.2CanonlyBeassignedOnedOneDonceIntheConstructorAratDeclarationandCannotBemodififificificificifified
?? ?? ??? PHP? ?????
Jul 28, 2025 am 04:37 AM
usearestapitobridgephpandmlmodelsbyrunningthemodelinpythonviaflaskorfastapiandcallingitffuspusingcurlorguzz.2.runpythonscriptsdirectlyfromphpusingexec () orshell_exec () orshell_exec () orshell_exec ()???, ??? ??? ?? ??? hassecurity and somancelitat
CSS ?? ?? ?? ?
Jul 30, 2025 am 05:28 AM
?? JavaScript? ???? ??? ??? ?? ??? ??? ??? ?? ??? ?? ??? ??? ???????. 1. HTML ???? ?? ???? ????? ??? ???? ????. 2. CSS ?? : ??? ?? ?? ??? ???? ?? ??, .dark-mode ???? ??? ?? ??? ???? var ()? ?? ??? ??? ?????. 3. JavaScript? ??? ???? ?? ???? ?? ??? ???? ?? LocalStorage? ????. 4. ??? ?? ? ? HTML ???? Dark-Mode ???? ???? ?? ??? LocalStorage? ?????. 5. ?? ?? ?? ??? 0.3 ? ?? ?????? ???? ???? ??????.
Java ?? ??? ? ???? ? ??
Jul 31, 2025 am 03:58 AM
?? ?? ??? ???? ?? ??? ?? ?? ? ??? ???? VisualVM ?? JProfiler? ???? ?? ???? Async-Profiler? ?? ??? ?????. 2. ?? ??? ???, ??? ?????, StringBuilder? ???? ??? ? ??? ?? ????, ??? GC ??? ??????. 3. ??? ?? ?? ??? ????? ?? ??? ???? ?? ?????. 4. ??? ???, ?? ???? ????, ?? ???? ???, ??? ?? ????? ??????. 5. JVM ?? ?? ??, ???? ? ?? ? ?? ??? ???? ???? GC ??? ??????. 6. ?? ???? ??? ???, ?? ???? ?? ???? ???, ???? ?????, ?? ? ??? ??????. 7. JMH? ?? ? ???? ?? ??? ? ????
