gpt4 book ai didi

PHP Mysql 登录

转载 作者:行者123 更新时间:2023-11-29 11:33:54 25 4
gpt4 key购买 nike

我创建了两个名为login和gotest的表。在gotest表中,我存储了用户详细信息,该表中唯一的是ID。在登录表中,我存储refid、用户名和密码。refid是包含相同值的主键gotest 表中的 ID。当它通过 URl 时,我从一个表单中获取 ID。但是当我尝试登录时,它给我这个错误“用户名或密码不正确!”。

这是我的 php 代码

    <?php

include_once 'dbconnect.php';

$renewid = $_GET['ID'];



$query = "SELECT refid, username, password FROM ipay_login WHERE refid = '$renewid'";

$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {

$renewid = $row['refid'];
$uname = $row['username'];
$upass = $row['password'];

echo $renewid . '<br />';
echo $uname . '<br />';
echo $upass . '<br />';

}

if(isset($_POST['btn-signup'])) {


$uname = $_POST['username'];
$upass = $_POST['password'];


/*echo $uname,$upass,$renewid;*/

$result1 = mysql_query("SELECT * FROM ipay_login WHERE username = '$uname' AND password = '$upass'");

if(mysql_num_rows($result1) > 0 )
{
echo "sucesss";
}
else
{
echo 'The Username or password are incorrect!';
}


}
?>

<html>
<head></head>
<body>
<form id="convertion" method="post">


<!--<input type="hidden" id="refid" name="refid" value="<?php /*$_GET['refid']; */?>" /><br/>-->
<input type="text" id="username" name="username" /><br/>
<input type="text" id="password" name="password" /><br/>

<button type="submit" id="btn-signup" name="btn-signup">SUBMIT</button>
</form>
</body>
</html>

我的登录页面的 URL

http://xxx.yyy.example?ID=1000

最佳答案

尝试这个..首先将登录中的 refid 列更改为 ID。然后运行以下代码

<?php

include_once 'dbconnect.php';


$renewid = $_GET['ID'];

$query = "SELECT * FROM login WHERE ID = '$renewid'";

$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {


$uname = $row['username'];
$upass = $row['password'];

echo $uname . '<br />';
echo $upass . '<br />';

}

if(isset($_POST['btn-signup'])) {


$uname = $_POST['username'];
$upass= $_POST['password'];


$result1 = mysql_query("SELECT * FROM login WHERE username = '$uname' AND password = '$upass'");

if(mysql_num_rows($result1) > 0 )
{

echo "sucess";

}
else
{
echo 'The username or password are incorrect!';
}
}
?>

<html>
<head></head>
<body>
<form id="convertion" method="post">

<input type="text" id="username" name="username" /><br/>
<input type="text" id="password" name="password" /><br/>

<button type="submit" id="btn-signup" name="btn-signup">SUBMIT</button>
</form>
</body>
</html>

关于PHP Mysql 登录,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/36932561/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com