如何连接两个具有相同 id 的 php 样式文件，并将它们的数据一起保存在数据库中: - How to Connect two php form files, with the same id and save their data together in the database:

我有一个只有两个事务的系统，注册.php和req.php。这两个交易数据保存在我的数据库中的新表中。注册.php是我的第一个交易，然后是要求.php。这个php文件是表单，两者都有一个提交按钮链接到add.php。我的新表的字段分为两种形式。流程是第一个注册.php将执行然后请求.php。我的表 new 有一个名为 new_id 的主键及其自动增量。我的问题是，在执行两种表单后，只有 Registration.php 的数据保存在数据库表中 new，而 req.php 是空白的。问题出在哪里？我需要你的帮助。

这是注册.php代码：

<html>
<head>
<link rel="stylesheet" href="bootstrap/css/bootstrap.css"/>
<script type="text/javascript" src="jquery.js">
</script>
<script type="text/javascript" src="bootstrap/js/bootstrap.js">
</script>
<TITLE>
        New Registration Form
    </TITLE></head>
<body>
<center>
<br>
<p style="font-weight: bold; font-size: 30">Please Fill Out Your Information Sheet</p><p><?php                      
                        echo date('F j, Y, g:i a', time()+25200);
                        ?></p>
<form method="POST" action="add.php">
<!--<input type="text" name="new_fname" class="Form-Control" placeholder="First Name" id="fname" required>-->
<input type="text" name="new_fname" class="Form-Control" placeholder="First Name" id="fname" required>
<input type="text" name="new_mname" class="Form-Control" placeholder="Middle Initial" id="mname" required>
<input type="text" name="new_lname" class="Form-Control" placeholder="Last Name" id="lname" required><br><br>
Select Your gender
<select name="new_gender">
    <option value=""></option>
    <option value="Male">Male</option>
    <option value="Female">Female</option>
</select>
Select Your Status
<select name="new_status">
    <option value=""></option>
    <option value="New">New</option>
    <option value="Old">Old</option>
    <option value="Transferee">Transferee</option>
    <option value="Shiftee">Shiftee</option>
</select>
Select Your Course
<select name="new_course">
    <option value=""></option>
    <option value="BSINFOTECH">BSINFOTECH</option>
    <option value="BSIS">BSIS</option>
    <option value="BSCOMTECH">BSCOMTECH</option>
</select>
<br><br>
<input type="text" name="new_age" class="Form-Control" placeholder="Age" id="age" required><br><br>
<input type="text" name="new_bp" class="Form-Control"  placeholder="Birth Place" id="bp" required><br><br>
<input type="text" name="new_add" class="Form-Control" placeholder="Address" id="add" required><br><br>
<input type="text" name="new_nat" class="Form-Control" placeholder="Nationality" id="nat" required><br><br>
<input type="text" name="new_rel" class="Form-Control" placeholder="Religion" id="rel" required><br><br>
<input type="text" name="new_tel" class="Form-Control" placeholder="Tel. No." id="tel" required><br><br>
<input type="text" name="new_cel" class="Form-Control" placeholder="Cel. No." id="cel" required><br><br>
<input type="text" name="new_mail" class="Form-Control" placeholder="E-mail Address" id="mail" required><br><br>
    <button onclick="parent.location='req.php'" type="submit" name="next">Next</button>
<button type="submit" class="btn" name="save" value="save">Save</button>

</form>
</body>
</html>

以下是要求.php代码：

<html>
<head>
<link rel="stylesheet" href="bootstrap/css/bootstrap.css"/>
<script type="text/javascript" src="jquery.js">
</script>
<script type="text/javascript" src="bootstrap/js/bootstrap.js">
</script>
<title>
REQUIRMENTS FORM    
</title>
<br>
<p align="center" style="font-size: 50">REQUIRMENTS FORM</p> 
</head>
<body>
<center>
<br>
<p align="center" style="font-size: 30">Registrar</p>
<form style="font-size: 20" action="add.php" method='post'>
 Form 138
<br>
<select name="form1">
<option value=""</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
<br>
Form 137A
<br>
<select name="form2">
<option value=""</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
<br>
2 X 2 ID
<br>
<select name="picture">
<option value=""</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
<br>
NSO Birth Certificate
<br>
<select name="nso">
<option value=""</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
<br>
Good Moral Certificate
<br>
<select name="gmc">
<option value=""</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
<p align="center" style="font-size: 30">Library</p>
Library Card
<br>
<select name="lc">
<option value=""</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
<br>
<br>
<p align="center" style="font-size: 30">Cashier</p>
<p><h4>You should have paid minimum of P2000.00-2500.00</h4></p>
<input type="text" name="cashier" class="Form-Control" width="100px" placeholder="Enter amount" id="cashier" required></input>
<button type="submit" style="font-size: 20" class="btn btn-primary btn-block" name="submit" value="save">SUBMIT</button>
<button  type="button" style="font-size: 20" class="btn btn-primary btn-block"><a href="newform.php?id=<?php echo $data->new_id ?>">Process Student Copy</button>
<input type="hidden" value="<?php echo $data->new_id ?>" name="id" >
</form>
</body>
</html>

下面是 add.php 代码：

<?php
mysql_connect("localhost","root");
mysql_select_db("enrollee");
$course=$_POST['new_course'];
$gender=$_POST['new_gender'];
$gender=$_POST['new_gender'];
$status=$_POST['new_status'];
$fname=$_POST['new_fname'];
$mname=$_POST['new_mname'];
$lname=$_POST['new_lname'];
$age=$_POST['new_age'];
$bp=$_POST['new_bp'];
$add=$_POST['new_add'];
$nat=$_POST['new_nat'];
$rel=$_POST['new_rel'];
$tel=$_POST['new_tel'];
$cel=$_POST['new_cel'];
$mail=$_POST['new_mail'];
form1=$_POST['form1'];
$form2=$_POST['form2'];
$picture=$_POST['picture'];
$nso=$_POST['nso'];
$gmc=$_POST['gmc'];
$lc=$_POST['lc'];
$cashier=$_POST['cashier'];
mysql_query("INSERT INTO new(new_id,new_course,new_gender,new_status,new_fname,new_mname,new_lname,new_age,new_bp,new_add,new_nat,new_rel,new_tel,new_cel,new_mail,form1,form2,picture,nso,gmc,lc,cashier))
                VALUES(NULL, '$course','$gender', '$status', '$fname','$mname','$lname','$age','$bp','$add','$nat','$rel','$tel','$cel','$mail','$form1','$form2','$picture','$nso','$gmc','$lc','$cashier')");         
    header("Location: read.php");
    ?>

当您将数据保存到数据库中时，您可能有一个字段是primary key和auto increment，对吧？（如果没有，你应该 - 将其标记为ID或registration_id或类似的东西）

在req.php页面上，您应该首先读取数据库 - 如下所示：

$result = mysql_query("SELECT * FROM new");

这将为您提供一个包含所有行中所有字段的MySQL资源。然后，您必须获取每一行，如下所示：

while ($row = mysql_fetch_array($result){
    echo $row['first_name'];
}

使用上述方法构建req.php页面，其中包含您从页面存储的数据registration.php。

在

codecourse.com 做Registration and Login教程，或者在newboston做一些PHP教程可能对你有所帮助

。

它可能会帮助您知道您可以获取最后插入行的 ID。

然后，您可以使用该 ID UPDATE（而不是INSERT）req.php 文件中的数据。

UPDATE `new` SET `fieldname` = '$value', `nuthername` = '$nextval' WHERE `new_id` = '$last_inserted_id'