我正在尝试创建一个成员表,使用PHPmyadmin数据库,并在数据库中,有一个0 &1字段,我想转换复选框中的0和1,对于每个成员。是一个可编辑的表,因此该表可能在表单中。以下是我所做的:
<?php
include('../../config.php');
$result2 = mysql_query("SELECT * FROM acars_users");
echo "<table border='1'>
<tr>
<th>ID</th>
<th>Dados Pessoais</th>
<th>Origem</th>
<th>Dados de Redes</th>
<th width='220px'>Base</th>
<th>Patente</th>
<th>Horas</th>
<th>É Ativo?</th>
<th>Dinheiro</th>
<th>Senha</th>
<th>Opções</th>
</tr>";
while($row = mysql_fetch_array($result2))
{
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td width='300px'>" . "<form action=editar.php method=POST><input name=username size=7 type=text value=".$row['username']." /></br><input name=nome size=10 type=text value=".$row['nome']." /><input name=sobrenome size=20 type=text value=".$row['sobrenome']." /></br><input name=email size=25 type=text value=".$row['email']." />" . "</td>";
echo "<td>" . "<input name=datanascimento size=10 type=text value=".$row['datanascimento']." /></br><input name=pais size=10 type=text value=".$row['pais']." /></br><input name=cidade size=30 type=text value=".$row['cidade']." />" . "</td>";
echo "<td>" . "IVAO: <input name=idivao size=8 type=text value=".$row['idivao']." /></br>VATSIM: <input name=idvatsim size=8 type=text value=".$row['idvatsim']." />" . "</td>";
echo "<td>" . "<input name=base size=8 type=text value=".$row['base']." />" . "</td>";
echo "<td>" . "<input name=rank size=10 type=text value=".$row['rank']." /></br>Admin <input name=admin size=1 type=checkbox value=".$row['admin']." /></br>DOV <input name=dov size=1 type=checkbox value=".$row['dov']." /></br>Checador <input name=checador size=1 type=checkbox value=".$row['checador']." />" . "</td>";
echo "<td>" . "<input name=horas size=6 type=text value=".$row['horas']." />" . "</td>";
echo "<td>" . "<input type=checkbox name='isactive[]' value=".$row['isactive']." />" . "</td>";
echo "<td>" . "<input name=dinheiro size=10 type=text value=".$row['dinheiro']." />" . "</td>";
echo "<td>" . "<input name=password size=10 type=password value=".$row['password']." />" . "</td>";
echo "<td>" . "<input name=edit_id value=".$row['id']." type=hidden><input type=submit value=Editar ></form><form action=deletarexist.php method=POST><input name=delete_id value=".$row['id']." type=hidden><input type=submit value=Demitir></form>" . "</td>";
echo "</tr>";
}
echo "</table>";
?>
$chkd=$row['isactive']?'checked="checked"':''; // 0: false; 1: true
echo "<td><input type='checkbox' name='isactive[]' value='{$row['isactive']}' $chkd></td>";
(不过,您应该考虑使用模板系统(比如smarty),而不是回显html片段。一开始看起来有点奇怪,但一旦你习惯了,你就再也不会回头了-)
我猜您希望复选框被选中,在这种情况下,您需要将checked="checked"
属性添加到复选框。
那么你要做的就是像这样:
if($row['isactive'] == 1){
echo "<td>" . "<input type='checkbox' name='isactive[]' value=".$row['isactive']. checked='checked' />" . "</td>";
} else {
echo "<td>" . "<input type='checkbox' name='isactive[]' value=".$row['isactive']." />" . "</td>";
}
对于这个值,你可能应该有一些东西来标识复选框,比如一个成员id,这取决于你使用它的目的。