php - 带有 php 的 HTML 表单不能使用单个提交按钮。
问题描述
我正在用 html 和 php 开发一个表单，一个页面中有多个部分，我希望每个部分都有一个提交按钮。但我无法做到。使用多个提交按钮，它可以工作。谁能帮我解决这个问题。我需要创建一个带有单个提交按钮的表单。这是示例代码..
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Add Records Form</title>
</head>
<body>
<table style="width:100%">
<tr>
<th rowspan="2">
<div class="container">
<div class="row">
<div class="col-md-8 col-md-offset-2">
<form action="insert1.php" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label">NCBI Accession number</label>
<input type="text" name="Gene_NCBI_Accession_number" placeholder="NCBI Accession number" class="form-control">
</div>
<div class="form-group">
<label class="control-label">locus tag</label>
<input type="text" name="Gene_name_locus_tag" placeholder="locus tag" class="form-control">
</div>
</th>
<td>
<div class="container">
<div class="row">
<div class="col-md-8 col-md-offset-2">
<form action="insert1.php" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label"><b>Antibiotic</label>
<input type="text" name="Antibiotic_name" placeholder="Antibiotic name" class="form-control">
</div>
</td>
<td>
<div class="form-group">
<label class="control-label"><b>Name</label>
<input type="text" name="Name" placeholder="Name" class="form-control" required>
</div>
</td>
</tr>
<tr>
<td rowspan="2">
<h4> Please fill in information for other related data or give your comments if any</h4>
<br>
<textarea rows="7" cols="100" name="comment" form="usrform">
Enter text here...</textarea>
</td>
<td>
</div>
<div class="form-group">
<label class="control-label"><b>Protein function</label>
<input type="text" name="Protein_function" placeholder="Protein_function" class="form-control">
</div>
<div class="form-group">
<label class="control-label">Biological process</label>
<input type="text" name="Biological_process" placeholder="Biological process" class="form-control">
</div>
</td>
</tr><br>
<br>
<br>
<br>
<br>
<br>
</form></table>
<input type="submit" value="Add Records">
<?php include 'footer.php'; ?>
</body>
</html>
<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("abc", "abc", "abc", "abc");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$Gene_NCBI_Accession_number = mysqli_real_escape_string($link, $_REQUEST['Gene_NCBI_Accession_number']);
$Gene_name_locus_tag = mysqli_real_escape_string($link, $_REQUEST['Gene_name_locus_tag']);
$Antibiotic_name = mysqli_real_escape_string($link, $_REQUEST['Antibiotic_name']);
$Name = mysqli_real_escape_string($link, $_REQUEST['Name']);
$Protein_function = mysqli_real_escape_string($link, $_REQUEST['Protein_function']);
$Biological_process= mysqli_real_escape_string($link, $_REQUEST['Biological_process']);
// attempt insert query execution
$sql = "INSERT INTO contact_form_info (Gene_NCBI_Accession_number, Gene_name_locus_tag, Antibiotic_name, Name, Protein_function, Biological_process) VALUES ('$Gene_NCBI_Accession_number', '$Gene_name_locus_tag', '$Antibiotic_name', '$Name','$Protein_function', '$Biological_process' )";
if(mysqli_query($link, $sql)){
#echo "Records added successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_close($link);
?>
解决方案
您的提交按钮在表单之外，这就是它不起作用的原因。请参阅下面的代码来解决您的问题。
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Add Records Form</title>
</head>
<body>
<table style="width:100%">
<tr>
<th rowspan="2">
<div class="container">
<div class="row">
<div class="col-md-8 col-md-offset-2">
<form action="insert1.php" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label">NCBI Accession number</label>
<input type="text" name="Gene_NCBI_Accession_number" placeholder="NCBI Accession number" class="form-control">
</div>
<div class="form-group">
<label class="control-label">locus tag</label>
<input type="text" name="Gene_name_locus_tag" placeholder="locus tag" class="form-control">
</div>
</th>
<td>
<div class="container">
<div class="row">
<div class="col-md-8 col-md-offset-2">
<form action="insert1.php" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label"><b>Antibiotic</label>
<input type="text" name="Antibiotic_name" placeholder="Antibiotic name" class="form-control">
</div>
</td>
<td>
<div class="form-group">
<label class="control-label"><b>Name</label>
<input type="text" name="Name" placeholder="Name" class="form-control" required>
</div>
</td>
</tr>
<tr>
<td rowspan="2">
<h4> Please fill in information for other related data or give your comments if any</h4>
<br>
<textarea rows="7" cols="100" name="comment" form="usrform">
Enter text here...</textarea>
</td>
<td>
</div>
<div class="form-group">
<label class="control-label"><b>Protein function</label>
<input type="text" name="Protein_function" placeholder="Protein_function" class="form-control">
</div>
<div class="form-group">
<label class="control-label">Biological process</label>
<input type="text" name="Biological_process" placeholder="Biological process" class="form-control">
</div>
</td>
</tr><br>
<br>
<br>
<br>
<br>
<br><input type="submit" value="Add Records">
</form></table>
<?php include 'footer.php'; ?>
</body>
</html>
<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("abc", "abc", "abc", "abc");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$Gene_NCBI_Accession_number = mysqli_real_escape_string($link, $_REQUEST['Gene_NCBI_Accession_number']);
$Gene_name_locus_tag = mysqli_real_escape_string($link, $_REQUEST['Gene_name_locus_tag']);
$Antibiotic_name = mysqli_real_escape_string($link, $_REQUEST['Antibiotic_name']);
$Name = mysqli_real_escape_string($link, $_REQUEST['Name']);
$Protein_function = mysqli_real_escape_string($link, $_REQUEST['Protein_function']);
$Biological_process= mysqli_real_escape_string($link, $_REQUEST['Biological_process']);
// attempt insert query execution
$sql = "INSERT INTO contact_form_info (Gene_NCBI_Accession_number, Gene_name_locus_tag, Antibiotic_name, Name, Protein_function, Biological_process) VALUES ('$Gene_NCBI_Accession_number', '$Gene_name_locus_tag', '$Antibiotic_name', '$Name','$Protein_function', '$Biological_process' )";
if(mysqli_query($link, $sql)){
#echo "Records added successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_close($link);
?>
推荐阅读
- python - 当我尝试从表中抓取数据时没有数据出现
- eloquent - 雄辩的具有挑战性的嵌套查询
- python - 使用请求时如何打印发布数据？
- amazon-web-services - 使用 for 循环从 s3 复制 Redshift
- node.js - 使用 Node.Js Express 连接两个表
- c - 可能最终在共享库中的所有内容是否总是需要使用 -fPIC 进行编译？
- python - 具有多种输出形状的 TensorFlow 子类 keras
- amazon-s3 - 如何在 AWS amplify 中向无服务器容器授予额外权限？
- html - 添加卡片时，部分内容超出页面
- linux - Linux 高可用性和 DRBD、心跳