Inserting data into table (eg.2)

ICT Solutions 2021-06-08 18:00:27

Category : php tutorials

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>

Comments:

No comment to show.

Please login to start chat

Comments: