$mingzi=$_POST['mingzi'];
$sql="select * from yonghu where mingzi like '$mingzi%' limit 40";
$s=$mysqli->query($sql);
while($r=$s->fetch_assoc()){
?>
<form action="index.php" method="post">
<input type="text" name="id" value="<?=$r['id']?>" size="1"> <input type="text" name="mingzi" value="<?=$r['mingzi']?>" size='4'> <input type="text" name="mima" value="<?=$r['mima']?>" size='4'>
<input type="text" name="cpu" value="<?=$r['cpu']?>"> <input type="text" name="guoqishijian" value="<?=$r['guoqishijian']?>"> <input type="submit" name="sub" value="确定"><br>
</form>
<?php
}
$s->free();可以批量读取了。可批量修改或者单个修改,没点思路,麻烦给点提示我咯咯
$sql="select * from yonghu where mingzi like '$mingzi%' limit 40";
$s=$mysqli->query($sql);
while($r=$s->fetch_assoc()){
?>
<form action="index.php" method="post">
<input type="text" name="id" value="<?=$r['id']?>" size="1"> <input type="text" name="mingzi" value="<?=$r['mingzi']?>" size='4'> <input type="text" name="mima" value="<?=$r['mima']?>" size='4'>
<input type="text" name="cpu" value="<?=$r['cpu']?>"> <input type="text" name="guoqishijian" value="<?=$r['guoqishijian']?>"> <input type="submit" name="sub" value="确定"><br>
</form>
<?php
}
$s->free();可以批量读取了。可批量修改或者单个修改,没点思路,麻烦给点提示我咯咯
然后提交后遍历修改即可
<?php
while($r=$s->fetch_assoc()){
?> <input type="text" name="id[]" value="<?=$r['id']?>" size="1"> <input type="text" name="mingzi[]" value="<?=$r['mingzi']?>" size='4'> <input type="text" name="mima" value="<?=$r['mima']?>" size='4'>
<input type="text" name="cpu[]" value="<?=$r['cpu']?>"> <input type="text" name="guoqishijian[]" value="<?=$r['guoqishijian']?>"><br>
<?php
}
?>
<input type="submit" name="sub" value="确定">
</form>index.php可以这样写:
foreach($_POST['id'] as $k=>$v){
$sql="update table set mingzi='$_POST['mingzi'][$k]' where id=$v";
mysql_query($sql);
}