我的代码似乎不起作用..单选按钮出现,但旁边什么也没有..似乎 mysql_fetch_array 由于某种原因无法工作,因为我已经玩过代码并反复测试它以查找代码似乎遇到的位置出现问题并停止工作..有人可以告诉我出了什么问题吗?欢呼声我是新手,最近几天才完成 w3schools 上的 php 教程。
<body>
<?php
include 'dbyear2.php';
$qnumber = $_REQUEST['uqn']; // obtain question number from URL
$find = mysql_query("SELECT * FROM Renal WHERE UQN='$qnumber'");
while($retrieve=mysql_fetch_array($find));
{
$retrieve['question'] = $question;
$retrieve['MCQ_A'] = $a;
$retrieve['MCQ_B'] = $b;
$retrieve['MCQ_C'] = $c;
$retrieve['MCQ_D'] = $d;
$retrieve['MCQ_E'] = $e;
$retrieve['answer'] = $answer;
$retrieve['MCQ_correct'] = $correct;
}
?>
<form action='check.php' method='POST'>
<table>
<tr><td></td><td></td></tr>
<tr></tr>
<tr><td><input type='radio' name='group1' value='A' /></td><td> <?php echo $a; ?></td></tr>
<tr><td><input type='radio' name='group1' value='B' /></td><td> <?php echo $b; ?></td></tr>
<tr><td><input type='radio' name='group1' value='C' /></td><td> <?php echo $c; ?></td></tr>
<tr><td><input type='radio' name='group1' value='D' /></td><td> <?php echo $d; ?></td></tr>
<tr><td><input type='radio' name='group1' value='E' /></td><td> <?php echo $e; ?></td></tr>
<tr>
<?php
// sending the retrieved information from MYSQL via POST for use in check.php file
$qnumber;
$a;
$b;
$c;
$d;
$e;
$answer;
$correct;
?></tr>
<tr><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</body>
</html>
这部分是向后的:
$retrieve['question'] = $question;
$retrieve['MCQ_A'] = $a;
$retrieve['MCQ_B'] = $b;
$retrieve['MCQ_C'] = $c;
$retrieve['MCQ_D'] = $d;
$retrieve['MCQ_E'] = $e;
$retrieve['answer'] = $answer;
$retrieve['MCQ_correct'] = $correct;
应该
$question = $retrieve['question' ;
$a = $retrieve['MCQ_A'];
$b = $retrieve['MCQ_B'];
$c = $retrieve['MCQ_C'];
$d = $retrieve['MCQ_D'];
$e = $retrieve['MCQ_E'];
$answer = $retrieve['answer'];
$correct $retrieve['MCQ_correct'];
请不要使用mysql_*新代码中的函数 https://stackoverflow.com/questions/12859942。它们不再被维护并已被正式弃用 https://wiki.php.net/rfc/mysql_deprecation。请参阅red box http://uk.php.net/manual/en/function.mysql-connect.php?学习关于准备好的陈述 https://en.wikipedia.org/wiki/Prepared_statement相反,并使用PDO http://php.net/pdo or MySQLi http://php.net/mysqli - 本文 http://php.net/manual/en/mysqlinfo.api.choosing.php将帮助您决定哪个。如果您选择PDO,这是一个很好的教程 http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers.
你也敞开心扉SQL注入 https://stackoverflow.com/q/60174
你不应该使用w3学校 http://www.w3fools.com。它不是可靠的信息来源,我们不鼓励使用它。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)