从数据库不工作获取值 - get value from database not working

get value from database not working

本文关键字：获取工作数据库 | 更新日期: 2023-09-26

我试图从我的本地数据库获得一个特定的值，但似乎它不工作，这是我的代码:

$acceptance = " SELECT acceptance_status FROM teams_0517 WHERE team_id=$team_id"; 
$acceptancex = mysql_query($acceptance);
mysql_close($connection);
if($acceptancex == 0)
{
    ob_clean();
    header('Location: index.php');
    ob_flush();
}
else
{
    ob_clean();
    header('Location: signup.php');
    ob_flush();
}

当我运行代码时，php将跳过if条件并继续执行其他语句，因此看起来$acceptance没有值。

您需要在执行查询后获取结果。查看如何获取

试试:

$acceptance = " SELECT acceptance_status FROM teams_0517 WHERE team_id=$team_id limit 1"; 
$result = mysql_query($acceptance);
$acceptancex = mysql_fetch_object($result); // fetch object

if($acceptancex->acceptance_status == 0)
{
    ob_clean();
    mysql_close($connection);
    header('Location: index.php');
    ob_flush();
}
else
{
    ob_clean();
    mysql_close($connection);
    header('Location: signup.php');
    ob_flush();
}

试试这个:-

$acceptance = " SELECT acceptance_status FROM teams_0517 WHERE team_id=$team_id limit 1"; 
$result = mysql_query($acceptance);
$acceptancex = mysql_fetch_object($result); // fetch object
if($acceptancex->acceptance_status == 0)
{
    $redirect = "index.php";
}
else
{
    $redirect = "signup.php";
}
mysql_close($connection);
ob_clean();
header('Location: '.$redirect);
ob_flush();