1 / 4
Computer Service
2 / 4
Networking Service
3 / 4
Web Development Service
4 / 4
Software Development Service
TNW - ICT Solutions
  • Home
  • Available Courses 
  • Available Services 
  • Website Samples 
  • Search Log In
  •  This step is a litter bit complex. But, not too difficult. I hope you will be ok.

    1. Create html form.

    2. Connect to server.

    3. Check form is filled or not.

    4. Insert data into table.

    <?php
    @$server = 'localhost';
    @$username = 'root';
    @$password = ' ';
    @$db = 'TNW';
    @$conn = mysqli_connect($server, $username, $password, $db);
    
    if($conn){
    if(isset($_POST['UserId']) && isset($_POST['FirstName']) && isset($_POST['LastName']) && isset($_POST['UserName']) && isset($_POST['Password'])){
           $userid = $_POST['UserId'];
           $firstname = $_POST['FirstName'];
           $lastname = $_POST['LastName'];
           $username = $_POST['UserName'];
           $password = $_POST['Password'];
           
           if(!empty($userid) && !empty($firstname) && !empty($lastname) && !empty($username) && !empty($password)){
               $query = "INSERT INTO `username` VALUES('".$userid."', '".$firstname."', '".$lastname."',
                        '".$username."', '".$password."')";
               $query_run = mysqli_query($conn, $query);
               if($query_run){
                   echo 'Data is successfully inserted into table.';
               }else{
                   echo 'Inserting Error!';
               }    
           }else{
               echo 'Please fill all fields.';
           }
       }
    }else{
        echo 'Error in Server connection!';
    }
    ?>
    
    <html>
    <head>
    <title>Inserting Data into table</title>
    <style>
        .tnwform{
            padding: 20px;
        }
    </style>
    </head>
    <body>
    <form action="inserting_data_into_tabel_2.php" method="POST" class="tnwform">
        <label for="UserId">User Id</label>
        <input type="text" name="UserId"><br /><br />
        
        <label for="FirstName">First Name</label>
        <input type="text" name="FirstName"><br /><br />
        
        <label for="LastName">Last Name</label>
        <input type="text" name="LastName"><br /><br />
        
        <label for="UserName">User Name</label>
        <input type="text" name="UserName"><br /><br />
        
        <label for="Password">Password</label>
        <input type="password" name="Password"><br /><br />
        
        <input type="submit" value="Submit">
    </form>
    </body>
    </html>