PHP CODE TO STORE USER DATA ► MacroNepal

<?php
// Database connection settings
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "smile_dental_cover";

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

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Check if form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Sanitize user input
    $name = $conn->real_escape_string($_POST['name']);
    $email = $conn->real_escape_string($_POST['email']);
    $phone = $conn->real_escape_string($_POST['phone']);
    
    // Insert user data into the database
    $sql = "INSERT INTO users (name, email, phone) VALUES ('$name', '$email', '$phone')";
    
    if ($conn->query($sql) === TRUE) {
        echo "Thank you, $name! Your dental cover request has been submitted successfully.";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

// Close connection
$conn->close();
?>

<!DOCTYPE html>
<html>
<head>
    <title>Smile Dental Cover Sign-Up</title>
</head>
<body>
    <h1>Join Smile's Dental Cover</h1>
    <p>Sign up today and enjoy top-rated dental coverage with reduced fees!</p>
    
    <form method="POST" action="">
        <label for="name">Name:</label>
        <input type="text" id="name" name="name" required><br><br>
        
        <label for="email">Email:</label>
        <input type="email" id="email" name="email" required><br><br>
        
        <label for="phone">Phone:</label>
        <input type="tel" id="phone" name="phone" required><br><br>
        
        <input type="submit" value="Sign Up Now">
    </form>
</body>
</html>
PHP
Leave a Reply Cancel reply
