« Previous Next »

Insert Data with TextBoxes

<?php
$servername = "localhost"; 
$username = "root"; 
$password = ""; 
$database = "ait"; 

// Create connection
$conn = new mysqli($servername, $username, $password, $database); 

// Insert Data
if ($_SERVER["REQUEST_METHOD"] == "POST") 
{ 
    $Id = $_POST["Id"]; 
    $Name = $_POST["Name"]; 
    $Course = $_POST["Course"]; 
    $Fees = $_POST["Fees"]; 

    // Prepare statement to insert data
    $stmt = $conn->prepare("INSERT INTO student (Id, Name, Course, Fees) VALUES (?, ?, ?, ?)"); 

    $stmt->bind_param("ssss", $Id, $Name, $Course, $Fees); 

    if ($stmt->execute()) 
    { 
        echo "Record inserted successfully!"; 
    } 
    else 
    { 
        echo "Error: " . $stmt->error; 
    } 

    $stmt->close(); 
} 
$conn->close(); 
?>

<!DOCTYPE html>
<html>
<head>
    <title>Insert Data</title>
</head>
<body>

<h2>Insert User Data</h2>

<form method="post">
ID: <input type="text" name="Id" required><br><br>
Name: <input type="text" name="Name" required><br><br>
Course: <input type="text" name="Course" required><br><br>
Fees: <input type="text" name="Fees" required><br><br>
<input type="submit" value="Submit" >
</form>

</body>
</html>

Output

Insert User Data
ID:

Name:

Course:

Fees:


Record inserted successfully!
« Previous Next »