Untitled

<?php
// Database credentials
$servername = "localhost"; // Change this if needed
$username = "root";        // Default XAMPP username
$password = "";            // Default XAMPP password (empty)
$dbname = "rezervimi";     // Your database name

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

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

// Get form data
$emri = $_POST['emri'];
$email = $_POST['email'];
$cel = $_POST['cel'];
$subject = $_POST['subject'];
$klinika = $_POST['klinika'];
$simptomat = $_POST['simptomat'];

// Prepare SQL query
$sql = "INSERT INTO detaje (emri, email, cel, mesazhi, klinika, simptomat) 
        VALUES ('$emri', '$email', '$cel', '$subject', '$klinika', '$simptomat')";

// Execute query and check for errors
if ($conn->query($sql) === TRUE) {
    echo "Mesazhi u dergua me sukses!";
} else {
    echo "Gabim: " . $sql . "<br>" . $conn->error;
}

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