我是jQuery和AJAX的新手，我正在將登錄頁面作為項(xiàng)目進(jìn)行處理，我需要使用AJAX從數(shù)據(jù)庫中檢索數(shù)據(jù)。我不是100%流利的英語，所以我會盡我所能解釋這個問題（在谷歌翻譯的幫助下）。以下是我正在使用的代碼：索引.html<!DOCTYPE html><html> <head> <title>Login</title> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script> </head> <body> <form validate=""> <input type="text" placeholder="Username" id="username" required/><br /> <input type="password" placeholder="Password" id="password" required/><br /> <input type="submit" id="submit" value="Login" /> </form> <script type="text/javascript"> // when document is loaded $(document).ready ( // when submit is clicked $("#submit").click ( // sets test to null var test = null; // sets username to value of username input var username = document.getElementById("username").value; // AJAX request $.ajax({ type: "POST", async: true, url: test.php, data: {username: username}, success: function (data) { test = data; console.log(test); return test; } }); ); ); </script> </body></html>測試.php<?php// connects to database$conn = mysqli_connect('server', 'username', 'password', 'database');// sets var username to POST username value$username = $_POST['username'];// SQL Query$sql = "SELECT * FROM users WHERE username='" . $username . "'";$result = mysqli_query($conn, $sql);// sets result to mysqli_fetch_assoc()$result = mysqli_fetch_assoc( $result );// echos $resultecho $result['password'];// closes database connectionmysqli_close( $conn );?>控制臺日志控制臺輸出：“”[DOM] 輸入元素應(yīng)具有自動完成屬性（建議：“當(dāng)前密碼”）：（更多信息：https://www.googlesite.com）未捕獲的語法錯誤：意外的令牌 var ajax.html：19I've looked at the code and I can't seem to find an error.Thanks in advance! ;)>P.S.>It's probably going to end up being some stupid typo.>Other than that, have a great day!
如何使用AJAX從數(shù)據(jù)庫中檢索數(shù)據(jù)并將結(jié)果保存在變量中？
慕運(yùn)維8079593
2022-08-05 10:20:41
