Question

php 批量更新代码求助

//需要读取这些信息，批量更新
$data_values .= "('1','11','111','1111','1111','11111','11111','11111','111111','1111','11111','11111'),";
$data_values .= "('2','11','111','1111','1111','11111','11111','11111','111111','1111','11111','11111'),";
$data_values .= "('3','11','111','1111','1111','11111','11111','11111','111111','1111','11111','11111'),";
$data_values .= "('4','11','111','1111','1111','11111','11111','11111','111111','1111','11111','11111'),";
$data_values .= "('5','11','111','1111','1111','11111','11111','11111','111111','1111','11111','11111'),";
$data_values .= "('6','11','111','1111','1111','11111','11111','11111','111111','1111','11111','11111'),";

$data_values = substr($data_values,0,-1);
//更新以上内容，以下代码是错误的，求正确代码
$query = mysql_query("UPDATE shuju set(字段1,字段2,字段3,字段4,字段5,字段6,字段7) values $data_values");

Answer 1

<td><input value="<?php $r[0]; ?>" name="no" type="hidden" />
<input type="text" name="sz" value="<?php echo $r[2]; ?>" /></td>
<td><input type="text" name="xz" value="<?php echo $r[3]; ?>" /></td></tr>