从数据库检查PHP回显 [英] php echo checked from database

问题描述

我试图根据已经输入数据库的用户值添加一个已检查的语句。

I'm trying to add a "checked statement" based upon the users value already entered into the database.

我已将数据库端设计为q1， q2等，并且有一个带有 a， b或 c的varchar。

I've designed the database side as q1,q2 etc and have a single varchar with an "a","b", or "c".

我基本上希望代码检索答案并将其放入

I basically want the code to retrieve the answer and put it into the checkbox as "checked", for some reason I just can't get it to work.

到目前为止，我的代码是：

my code so far is:

<?php
//retreive questions from database and put into question box

$query2 = "SELECT `QuestionId`, `Question`, `Opt1`, `Opt2`, `Opt3`, `Opt4`,`Answer` FROM `pf_questions`";

$question2 = mysql_query($query2);

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

    $id         = $row['QuestionId'];
    $question   = $row['Question'];
    $opt1       = $row['Opt1'];
    $opt2       = $row['Opt2'];
    $opt3       = $row['Opt3'];
    $opt4       = $row['Opt4'];
    $answer     = $row["Answer"];

?>
<div id="ContainerQuestion">
    <span class="Question">Question <?php echo $id; ?>. <?php echo $question; ?></span>

        <p><input type=radio name='q<?php echo $id; ?>' value="a"> <?php echo $opt1; ?> </p>
        <p><input type=radio name='q<?php echo $id; ?>' value="b"> <?php echo $opt2; ?> </p>
        <p><input type=radio name='q<?php echo $id; ?>' value="c"> <?php echo $opt3; ?> </p>

        <p><input type=radio name='q<?php echo $id; ?>' value="d"> <?php echo $opt4; ?> </p>


</div>
<?php
}

?>

我可以在while函数中进行查询，只是让每种输入类型都说if（$ row [ '1'] ='a'）echo checked ='checked';还是我错了？

Can I do the query inside the while function and just have each input type say if($row['1'] = 'a') echo "checked='checked'"; or am I wrong?

任何帮助都会很棒。
谢谢

Any help will be awesome. thanks

推荐答案

<p><input type=radio name='q<?php echo $id; ?>' <?php echo $answer == 'a'?'checked="checked"':'' ?> value="a"> <?php echo $opt1; ?> </p>
<p><input type=radio name='q<?php echo $id; ?>' <?php echo $answer == 'b'?'checked="checked"':'' ? value="b"> <?php echo $opt2; ?> </p>
<p><input type=radio name='q<?php echo $id; ?>' <?php echo $answer == 'c'?'checked="checked"':'' ? value="c"> <?php echo $opt3; ?> </p>
<p><input type=radio name='q<?php echo $id; ?>' <?php echo $answer == 'd'?'checked="checked"':'' ? value="d"> <?php echo $opt4; ?> </p>

这篇关于从数据库检查PHP回显的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！