php - 如何将多个复选框及其文本字段插入 MySQL 数据库

Question

我是 PHP 领域的新手。 我正在制作一份表格，以从患者那里获取有关特定疾病的信息。在这种形式中，我有多个复选框和每个复选框的文本字段。如果选中一项复选框，则其文本字段的值和复选框值必须插入数据库中。请告诉我将检查值与文本字段一起插入数据库的代码。

<form>
<table>
<tr>
<td colspan="4">Past Medical History:</td>
</tr>
<tr valign="top">
<td colspan="4" height="290"><table border="0" width="100%">
<tbody>
<tr>
<td width="26%"><div align="center">Problem</div></td>
<td width="18%"><div align="center">From (Year)</div></td>
<td width="56%"><div align="center">Details</div></td>
</tr>
<tr>
<td><input name="chkBP" id="chkBP" value="BP" type="checkbox" />
 Blood Pressure</td>
 <td><div align="center">
 <input name="txtBPfrom" id="txtBPfrom" size="15" value="" type="text" />
 </div></td>
 <td><input name="txtBPDetail" id="txtBPDetail" size="40" value="" type="text" /></td>
 </tr>
 <tr>
 <td><input name="chkDiabetes" id="chkDiabetes" value="Diabetes" type="checkbox" />
 Diabetes</td>
 <td><div align="center">
 <input name="txtDiabetesfrom" id="txtDiabetesfrom" size="15" value="" type="text" />
 </div></td>
 <td><input name="txtDiabetesDetail" id="txtDiabetesDetail" size="40" value=""   type="text" /></td>
 </tr>
 <tr>
 <td><input name="chkHighCholes" id="chkHighCholes" value="HighCholesterol" type="checkbox" />
 High Cholesterol</td>
 <td><div align="center">
 <input name="txtHighCholesfrom" id="txtHighCholesfrom" size="15" value="" type="text"/>
 </div></td>
 <td><input name="txtHighCholesDetail" id="txtHighCholesDetail" size="40" value="" type="text" /></td>
 </tr>
 <tr>
 <td><input name="chkArthritis" id="chkArthritis" value="Arthritis" type="checkbox" />
 Arthritis</td>
 <td><div align="center">
 <input name="txtArthritisfrom" id="txtArthritisfrom" size="15" value="" type="text" />
 </div></td>
 <td><input name="txtArthritisDetail" id="txtArthritisDetail" size="40" value="" type="text" /></td>
 </tr>
 <tr>
 <td><input name="chkAsthma" id="chkAsthma" value="Asthma" type="checkbox" />
 Asthma</td>
 <td><div align="center">
 <input name="txtAsthmafrom" id="txtAsthmafrom" size="15" value="" type="text" />
 </div></td>
 <td><input name="txtAsthmaDetail" id="txtAsthmaDetail" size="40" value="" type="text" /></td>
 </tr>
 <tr>
 <td><input name="chkCirculation" id="chkCirculation" value="Circulation" type="checkbox" />
Circulation</td>
<td><div align="center">
<input name="txtCirculationfrom" id="txtCirculationfrom" size="15" value="" type="text" />
</div></td>
<td><input name="txtCirculationDetail" id="txtCirculationDetail" size="40" value="" type="text" /></td>
</tr>   
</table></td>
</tr>
</form>

Answer 1

您需要建立与数据库的连接。

发布表单后，收集此数据并使用 $_POST 相应地将其插入到数据库中。

可以在此处找到有用的示例 connect

并插入数据

$link = mysqli_connect("localhost","root","","web_table");

mysqli_query($link,"INSERT INTO web_formitem (`ID`, `formID`, `caption`, `key`,    `sortorder`, `type`, `enabled`, `mandatory`, `data`)
VALUES (105, 7, 'Tip izdelka (6)', 'producttype_6', 42, 5, 1, 0, 0)") 
or die(mysqli_error($link));