首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >由于循环而重复结果

问由于循环而重复结果
EN

Stack Overflow用户
提问于 2014-03-06 17:11:50
回答 2查看 40关注 0票数 0

因此,我的代码从上一页获得一个值,将其与数据库中的一个表字段进行比较,并显示成功或失败。这是原始代码:

代码语言:javascript
复制
<?php
if ($_GET['q'] !='')
{
    include('config.inc');
    $foo = $_GET['q'];
    $query= "INSERT INTO register(name) VALUES('$foo')";

    $result = mysql_query("SELECT * FROM user_student");
    while($row = mysql_fetch_array($result))
    {
        $id= $row['sid'];
        if($id==$foo)
        {
            $res = mysql_query($query);
            if ($res)
            {
                echo 'Insertion ok';
            }
            else
            {
                echo " ";
                echo "Attendance already taken for $foo";
            }
        }
        else
        {
            echo " ";
            echo "Student $foo does not exist!!";
        }
    }

}
else echo "Invalid Command";
?>

我有重复的结果,例如学生1124不存在!!10次。我已经将代码修改为:

代码语言:javascript
复制
while($row = mysql_fetch_array($result))
{
    $id= $row['sid'];
    if($id==$foo)
    {
        $res = mysql_query($query);
    }
    else
    {
        echo " ";
        echo "Student $foo does not exist!!";
    }
}
if ($res)
{
    echo 'Insertion ok';
}
else
{
    echo " ";
    echo "Attendance already taken for $foo";
}

因此,为了避免重复结果,我将$res放在循环之外,但是现在它说:变量不能被解析,有什么建议吗?

EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2014-03-06 17:26:49

也许就像

代码语言:javascript
复制
<?php
if ($_GET['q'] !='')
{
    include('config.inc');
    $foo = $_GET['q'];

    $result = mysql_query("SELECT * FROM user_student");
    $bRecordExists = false;
    while($row = mysql_fetch_array($result))
    {
        $id= $row['sid'];
        if($id==$foo)
        {
            $bRecordExists = true;
            break;
        }
    }
    if($bRecordExists)
    {
            $res = mysql_query("INSERT INTO register(name) VALUES('$foo')");
            if ($res)
            {
                echo 'Insertion ok';
            }
            else
            {
                    echo " ";
                    echo "Attendance already taken for $foo";
            }
    }
    else
    {
        echo " ";
        echo "Student $foo does not exist!!";
    }

}
else
{
    echo "Invalid Command";
}
?>
票数 0
EN

Stack Overflow用户

发布于 2014-03-06 17:37:38

修改后的CaldasGSM版本:

代码语言:javascript
复制
<?php
if (!empty($_GET['q']))
{
    include('config.inc');
    $foo = mysql_real_escape_string($_GET['q']);

    $result = mysql_query("SELECT * FROM user_student WHERE sid = '{$foo}'");
    $num_rows = mysql_num_rows($result);
    if($num_rows > 0)
    {
        $res = mysql_query("INSERT INTO register(name) VALUES('$foo')");
        if ($res)
        {
            echo 'Insertion ok';
        }
        else
        {
            echo " ";
            echo "Attendance already taken for $foo";
        }
    }
    else
    {
        echo " ";
        echo "Student $foo does not exist!!";
    }
}
else
{
 echo "Invalid Command";
}
?>
票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/22231312

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档