错误提示这个Notice: Undefined index: id in D:\PHPstudy\PHPTutorial\WWW\zhoukao\xiugai.php on line 2Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in D:\PHPstudy\PHPTutorial\WWW\zhoukao\xiugai.php on line 7Notice: Undefined variable: data in D:\PHPstudy\PHPTutorial\WWW\zhoukao\xiugai.php on line 15Warning: Invalid argument supplied for foreach() in D:\PHPstudy\PHPTutorial\WWW\zhoukao\xiugai.php on line 15这是我的xiugai.php代码
<?php
$id=$_GET['id'];
$link=mysqli_connect('127.0.0.1','root','root','zhoukao');
mysqli_query($link,'set names utf8');
$sql="select * from student where id=$id";
$res=mysqli_query($link,$sql);
while ($a=mysqli_fetch_assoc($res))
{
$data[]=$a;
}
?><form method="post" action="update.php">
<table>
<?php foreach ($data as $key=>$v) {?>
<tr>
<td>学生姓名</td>
<td>
<input type="text" value="<?php echo $v['name']?>">
</td>
</tr>
<tr>
<td>学生年龄</td>
<td>
<input type="text" value="<?php echo $v['age']?>">
</td>
</tr>
<tr>
<td>学生班级</td>
<td>
<select name="class_name">
<option value="<?php if ($v['class_name']=='1405phpA'){echo "selected";};?>">1405phpA</option>
<option value="<?php if ($v['class_name']=='1405phpB'){echo "selected";};?>">1405phpB</option>
<option value="<?php if ($v['class_name']=='1405phpC'){echo "selected";};?>">1405phpC</option>
<option value="<?php if ($v['class_name']=='1405phpD'){echo "selected";};?>">1405phpD</option>
</select>
</td>
</tr>
<tr>
<td>成绩</td>
<td>
<input type="text" value="<?php echo $v['score']?>">
</td>
</tr>
<tr>
<td><input type="hidden" name="id" value="<?php echo $v['id']?>"></td>
<td><input type="submit" value="修改"></td>
</tr>
<?php }?>
</table>
</form>
<?php
$id=$_GET['id'];
$link=mysqli_connect('127.0.0.1','root','root','zhoukao');
mysqli_query($link,'set names utf8');
$sql="select * from student where id=$id";
$res=mysqli_query($link,$sql);
while ($a=mysqli_fetch_assoc($res))
{
$data[]=$a;
}
?><form method="post" action="update.php">
<table>
<?php foreach ($data as $key=>$v) {?>
<tr>
<td>学生姓名</td>
<td>
<input type="text" value="<?php echo $v['name']?>">
</td>
</tr>
<tr>
<td>学生年龄</td>
<td>
<input type="text" value="<?php echo $v['age']?>">
</td>
</tr>
<tr>
<td>学生班级</td>
<td>
<select name="class_name">
<option value="<?php if ($v['class_name']=='1405phpA'){echo "selected";};?>">1405phpA</option>
<option value="<?php if ($v['class_name']=='1405phpB'){echo "selected";};?>">1405phpB</option>
<option value="<?php if ($v['class_name']=='1405phpC'){echo "selected";};?>">1405phpC</option>
<option value="<?php if ($v['class_name']=='1405phpD'){echo "selected";};?>">1405phpD</option>
</select>
</td>
</tr>
<tr>
<td>成绩</td>
<td>
<input type="text" value="<?php echo $v['score']?>">
</td>
</tr>
<tr>
<td><input type="hidden" name="id" value="<?php echo $v['id']?>"></td>
<td><input type="submit" value="修改"></td>
</tr>
<?php }?>
</table>
</form>
解决方案 »
- 【数组】array_push 函数给数组添加索引
- MYSQL语句WHERE部分这样写不对吗?
- 用什么方法提取文本中的所有<a></a>中的内容,(正则还是其它??)
- 那位大虾能给我一个关于SESSION注册的例子啊
- mysql语句
- WAMPSERVER下如何配置mysql
- php生成xml文件在firefox & opera浏览器上无法显示
- 这个登陆页面为什么不能回到前一个URL?
- gd库 不支持gif 到底如何解决啊?
- 关于字符串操作的问题,请大家讨论讨论
- 关于添加微信号带关键字
- Notice: Undefined variable: _SESSION in Z:\Apache24\htdocs\doit.php on line 10
所以 $id=$_GET['id']; 为空
从而造成 $res=mysqli_query($link,$sql); 因指令错误,查询失败
$id=$_GET['id']; $_GET 没有id索引