在PHP中使用多个表单时,不会将插入值输入到数据库中

时间:2022-09-25 16:26:09

signup.php

signup.php

   <?php
  if (isset($_POST['signup'])) {
    $con = mysqli_connect("localhost", "root", "");
    mysqli_query($con, "CREATE DATABASE dream");
    mysqli_select_db($con, "dream");
    $counter = 1;
    $uname = $_POST['uname'];
    $uemail = $_POST['uemail'];
    $upass = $_POST['upass'];
    $gender = $_POST['gender'];
    $uage = $_POST['uage'];
    $ucourse = $_POST['ucourse'];
    $uclass = $_POST['uclass'];
    $ucontact = $_POST['ucontact'];
    $uaddress = $_POST['uaddress'];

    $ct = "CREATE TABLE student(sno INTEGER(3) NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20), email VARCHAR(30), password VARCHAR(30), gender VARCHAR(30), age INTEGER(3), course VARCHAR(30), class VARCHAR(30), contact INTEGER(3), 
        address VARCHAR(100) )";
    mysqli_query($con, $ct);
    mysqli_query($con, "INSERT INTO student VALUES('$counter', '$uname','$uemail','$upass','$gender',
        '$uage','$ucourse','$uclass','$ucontact','$uaddress')");
    }

    ?>

<html>
<head></head>
<body>
    <form method = "post" action = "signup2.php"> 
    <div class = "container">

        <h2>Sign Up for Dream Media</h2>
        <table width = "550"  bordercolor = "#ffcc99" align = "center" bgcolor = "#cce5ff" cellpadding="12" border-radius = "5">
            <tr>
                <th>Name</th>
                <td><input type = "text" placeholder = "Enter your name" name = "uname" size = "30"></td>
            </tr>
            <tr>
                <th>Email</th>
                <td><input type = "email" placeholder = "Enter your email" name = "uemail"  size = "30"></td>
            </tr>
            <tr>
                <th>Password</th>
                <td><input type = "password" placeholder = "Enter your password" name = "upass"  size = "30"></td>
            </tr>
            <tr>
                <th>Gender</th>
                <td><input type = "radio"  name = "gender" value = "male">Male
                    <input type = "radio"  name = "gender" value = "female">Female</td>
            </tr>
            <tr>
                <th>Age</th>
                <td><input type = "text" placeholder = "Enter your Age" name = "uage"  size = "30"></td>
            </tr>
            <tr>
                <td colspan = "2" class="right"><input type = "submit" Value = "Next"></td>
            </tr>
        </table>
    </div>
    </form>
    <footer>

  <p>Contact information: <a href="mailto:someone@example.com">dreamsmedia@dms.com</a>.</p>
</footer>

</body>
</html>

signup2.php

signup2.php

    <?php
session_start();
$counter = 1;
$_SESSION['uname'] = $_POST['uname'];
$_SESSION['uemail'] = $_POST['uemail'];
$_SESSION['upass'] = $_POST['upass'];
$_SESSION['gender'] = $_POST['gender'];
$_SESSION['uage'] = $_POST['uage'];
print_r($_POST);
?>
<html>
<head></head>
<body>
    <form method = "post" action = "dreams.php">
    <div class = "container">

        <h2>Sign Up for Dream Media</h2>
        <table width = "550" border = "0" bordercolor = "#ffcc99" align = "center" bgcolor = "#cce5ff" cellpadding="12" border-radius = "5">
            <tr>
                <th>Course</th>
                <td><input type = "checkbox" name  = "ucourse[]" value = "php">PHP
                <input type = "checkbox" name  = "ucourse[]" value = "web">Web Designing
            <input type = "checkbox" name  = "ucourse[]" value = "js">Java Script
        <input type = "checkbox" name  = "ucourse[]" value = "ps">Photoshop
    </td>
            </tr>
            <tr>
                <th>Class Timinings</th>
                <td><input type = "text" placeholder = "Class timings" name = "uclass" size = "30"></td>
            </tr>
            <tr>
                <th>Contact</th>
                <td><input type = "text" placeholder = "1234567890" name = "ucontact" size = "30"></td>
            </tr>
            <tr>
                <th>Address</th>
                <td><textarea name = "uaddress" rows = "5" cols = "47" ></textarea></td>
            </tr>
            <tr>
                <td colspan = "2" class = "right"><input type = "submit" Value = "Finish" name = "signup"></td>
            </tr>
        </table>
    </div>
    </form>


</body>
</html>

final.php

final.php

 <?php
    session_start();


    $_SESSION['ucourse'] = $_POST['ucourse'];
    $_SESSION['uclass'] = $_POST['uclass'];
    $_SESSION['ucontact'] = $_POST['ucontact'];
    $_SESSION['uaddress'] = $_POST['uaddress'];

    print_r($_POST);
    ?>

Here I've used two forms,
1. signup.php
2. signup2.php

在这里,我使用了两种形式,1。signup.php 2. signup2.php

Enter the data by using sessions of retrieve the data from form 1 to from 2 , The entered values are not inserted in database.

使用从表单1到2检索数据的会话输入数据,输入的值不会插入数据库中。

1 个解决方案

#1


1  

is your final insert query in final.php? I think your action in signup2.php, will take you to dreams.php, not final.php Change this

是final.php中的最终插入查询?我认为你在signup2.php中的动作会带你去dreams.php,而不是final.php改变它

<form method = "post" action = "dreams.php">

to this

对此

<form method = "post" action = "final.php">

Btw, your final.php code, doesn't contain any sql insert query, add this to your final.php code

顺便说一下,你的final.php代码,不包含任何sql insert查询,将其添加到你的final.php代码中

mysqli_query($con, "INSERT INTO your_table VALUES($_SESSION['ucourse'], $_SESSION['uclass'],$_SESSION['ucontact'],$_SESSION['uaddress']");

Please modify the query to fit your table structure

请修改查询以适合您的表结构

#1


1  

is your final insert query in final.php? I think your action in signup2.php, will take you to dreams.php, not final.php Change this

是final.php中的最终插入查询?我认为你在signup2.php中的动作会带你去dreams.php,而不是final.php改变它

<form method = "post" action = "dreams.php">

to this

对此

<form method = "post" action = "final.php">

Btw, your final.php code, doesn't contain any sql insert query, add this to your final.php code

顺便说一下,你的final.php代码,不包含任何sql insert查询,将其添加到你的final.php代码中

mysqli_query($con, "INSERT INTO your_table VALUES($_SESSION['ucourse'], $_SESSION['uclass'],$_SESSION['ucontact'],$_SESSION['uaddress']");

Please modify the query to fit your table structure

请修改查询以适合您的表结构