我创建了简单的表单来插入多个带有选项的复选框,用户可以在选项中写入这些值,这些值将插入到 mysql 中。
这是我的代码:
索引.php
<a href="add.html">+ ADD PEOPLE</a>
<br/>
<br/>
<table border="1">
<tr>
<th>ID</th>
<th>Name</th>
<th>Hobby</th>
<th>Action</th>
</tr>
<?php
include 'conn.php';
$no = 1;
$query = mysqli_query($conn,"select * from checkbox ");
while($data = mysqli_fetch_array($query)){
?>
<tr>
<td><?php echo ($data['id']); ?></td>
<td><?php echo nl2br($data['name']); ?></td>
<td><?php echo nl2br ($data['hobby']); ?></td>
<td>
<a href="edit.php?id=<?php echo $data['id']; ?>">EDIT</a>
<a href="remove.php?id=<?php echo $data['id']; ?>" onclick="return checkDelete()">REMOVE</a>
</td>
</tr>
<?php
}
?>
</table>
添加.html
<p><a href="index.php">Back</a>
<form action="add.php" method="post">
<table cellpadding="3" cellspacing="0">
<tr>
<td>ID</td>
<td><input type="text" name="id" required></td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="name" size="30" required></td>
</tr>
<tr>
<td width="60px" valign="top">Hobby</td>
<td valign="top">
<label><input type="checkbox" name="hobby[]" value="Reading">Reading</label><br>
<label><input type="checkbox" name="hobby[]" value="Video Gaming">Video Gaming</label><br>
<label><input type="checkbox" name="hobby[]" value="other">Other</label>
<input type="text" id="otherValue" name="other">
</td>
</tr>
<tr>
千万里不及你