Insert values are not entered into the Database while using multiple forms in PHP

Question

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:[email protected]">[email protected]</a>.</p>
</footer>

</body>
</html>

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

 <?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

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

$_POST['ucourse'] should be an array, you can't concatenate it you would have to implode it first. — kurt
– kurt, Commented Jan 3, 2016 at 7:34
Are you running CREATE TABLE students Every time? Or did you just shown it to make us understand the Table Structure? — TipuZaynSultan
– TipuZaynSultan, Commented Jan 3, 2016 at 7:57
When I form is created I will submit with create table students — Kiran
– Kiran, Commented Jan 3, 2016 at 8:41

Webster · Accepted Answer · 2016-01-03 09:32:37Z

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

<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

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

edited Jan 3, 2016 at 9:32

answered Jan 3, 2016 at 7:35

Webster

1,1433 gold badges21 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Webster Over a year ago

is that all your final.php code? because i can't see any query for inserting to DB. Let me see all your final.php code

Webster Over a year ago

your final.php code doesn't contain any sql insert query dude. So the values won't be inserted to DB. See my edited post

Collectives™ on Stack Overflow

Insert values are not entered into the Database while using multiple forms in PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related