如何使用数据库中的用户名和密码验证用户名和密码，如果是，则从ajax重定向？ [英] How do I validate the username and password with the ones from database and then redirect from ajax if they are?
问题描述
您好！所以我有一个登录表单，包含用户，密码和登录按钮。在这个按钮上，我想放置一个JavaScript监听器，当点击时触发$ .ajax（）函数，该函数将
a请求发送到登录页面，然后返回带有2个字段的json响应：error（failed ）和msg（用户/传递确定）。当ajax结束时，success函数必须在页面上显示来自msg的值，如果没有错误重定向到主页。
i假设在某种程度上我需要验证用户/传递我在数据库中有什么，我只是不知道该怎么做。
i目前使用会话进行我的身份验证，它运行得很好，但现在我的新任务是更改它。
i尝试下面的问题是我不知道如何使用数据库进行验证，看看用户和密码是否正确。
请帮我一些想法。
谢谢
我尝试过：
Hello! So i have a login form with user, pass and a button for login. On this button i want to put a JavaScript listener and when clicked to fire a $.ajax() function who sends
a request to the login page and then return a json response with 2 fields: error(failed) and msg(user/pass ok). When the ajax ends, the success function must display on the page the value from msg and if there is no error redirect to home page.
i suppose that in some way i need to verify the user/pass with what i have in the database, i just don't know how to do it.
i currently use sessions for my authentications and it works just fine but now my new task is to change it.
i tried something below the problem is i don't know how to do the validation with the database to see if the user and password are correct.
please help me with some ideas.
Thank you
What I have tried:
This is my table
<table style="background-color:#f1f1f1">
<tr>
<td><asp:Label runat="server" ID="lbl1" Font-Bold="true" ForeColor="Red"/></td>
</tr>
<tr>
<td><asp:Label runat="server">Username</asp:Label></td>
<td><asp:TextBox runat="server" ID="txtUser" placeholder="Username"/></td>
<td><asp:RequiredFieldValidator ID="rfvUser" runat="server" ControlToValidate="txtUser" ErrorMessage="*" ForeColor="Red" Font-Bold="true" ValidationGroup="LoginInfo"/></td>
</tr>
<tr>
<td><asp:Label runat="server">Password</asp:Label></td>
<td><asp:TextBox runat="server" ID="txtPass" TextMode="Password" placeholder="Password"/></td>
<td><asp:RequiredFieldValidator ID="rfvPass" runat="server" ControlToValidate="txtPass" ErrorMessage="*" ForeColor="Red" Font-Bold="true" ValidationGroup="LoginInfo"/></td>
</tr>
<tr >
<td></td>
<td><asp:Button runat="server" Text="Login" ID="btnLogin" CssClass="button" Width="210" OnClick="btnLogin_Click" ValidationGroup="LoginInfo"/></td>
</tr>
</table>
这里我一直在尝试：
Here what i have been trying :
<script>
$(document).ready(function myfunction () {
$('#btnLogin').click(function () {
var user = $('#txtUser').val();
var pass = $('#txtPass').val();
if (user != '' && pass != '') {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Login.aspx/InsertData",
data: {user: txtUser, pass: txtPass},
dataType: "json",
success: function (data) {
var obj = data.d;
if (obj == 'true') {
$('#txtUser').val('');
$('#txtPass').val('');
$('#lbl1').html("Login Successfully");
// window.location = "Default.aspx";??
}
},
error: function (result) {
$('#lbl1').html("Wrong username or password");
}
});
}
else {
$('#lbl1').html("Please fill all fields");
return false;
}
});
});
</script>
和我的aspx.cs可能类似：
and in my aspx.cs maybe something like :
[WebMethod]
public static string InsertData(string user, string pass)
{
string msg = string.Empty;
using (MySqlConnection conn = new MySqlConnection(WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString))
{
using (MySqlCommand cmd = new MySqlCommand("select * from useri where Username=@Username and Password=@Password", conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@Username", user);
cmd.Parameters.AddWithValue("@Password", pass);
int i = cmd.ExecuteNonQuery();
conn.Close();
if(i==1)
{
msg = "true";
}
else
{
msg = "false";
}
}
}
return msg;
}
推荐答案
.ajax（）函数发送
a请求登录页面然后返回带有2个字段的json响应：错误（失败）和msg（用户/传递确定）。当ajax结束时，success函数必须在页面上显示来自msg的值，如果没有错误重定向到主页。
i假设在某种程度上我需要验证用户/传递我在数据库中有什么，我只是不知道该怎么做。
i目前使用会话进行我的身份验证，它运行得很好，但现在我的新任务是更改它。
i尝试下面的问题是我不知道如何使用数据库进行验证，看看用户和密码是否正确。
请帮我一些想法。
谢谢
我尝试过：
.ajax() function who sends
a request to the login page and then return a json response with 2 fields: error(failed) and msg(user/pass ok). When the ajax ends, the success function must display on the page the value from msg and if there is no error redirect to home page.
i suppose that in some way i need to verify the user/pass with what i have in the database, i just don't know how to do it.
i currently use sessions for my authentications and it works just fine but now my new task is to change it.
i tried something below the problem is i don't know how to do the validation with the database to see if the user and password are correct.
please help me with some ideas.
Thank you
What I have tried:
This is my table
<table style="background-color:#f1f1f1">
<tr>
<td><asp:Label runat="server" ID="lbl1" Font-Bold="true" ForeColor="Red"/></td>
</tr>
<tr>
<td><asp:Label runat="server">Username</asp:Label></td>
<td><asp:TextBox runat="server" ID="txtUser" placeholder="Username"/></td>
<td><asp:RequiredFieldValidator ID="rfvUser" runat="server" ControlToValidate="txtUser" ErrorMessage="*" ForeColor="Red" Font-Bold="true" ValidationGroup="LoginInfo"/></td>
</tr>
<tr>
<td><asp:Label runat="server">Password</asp:Label></td>
<td><asp:TextBox runat="server" ID="txtPass" TextMode="Password" placeholder="Password"/></td>
<td><asp:RequiredFieldValidator ID="rfvPass" runat="server" ControlToValidate="txtPass" ErrorMessage="*" ForeColor="Red" Font-Bold="true" ValidationGroup="LoginInfo"/></td>
</tr>
<tr >
<td></td>
<td><asp:Button runat="server" Text="Login" ID="btnLogin" CssClass="button" Width="210" OnClick="btnLogin_Click" ValidationGroup="LoginInfo"/></td>
</tr>
</table>
这里我一直在尝试：
Here what i have been trying :
<script>
（document）.ready（function myfunction（）{
(document).ready(function myfunction () {
（' #btLogin'）。click（function（）{
var user =
('#btnLogin').click(function () { var user =
这篇关于如何使用数据库中的用户名和密码验证用户名和密码，如果是，则从ajax重定向？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
