database تعرض البيانات فارغة والكود ادناه :
<?php include 'register.php'; ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="styles.css"> <!-- Make sure to link your CSS file -->
<title>User Registration</title>
</head>
<body>
<div>
<h1>User Registration Form</h1>
<form action="register.php" method="POST">
<input type="text" name="Firstname" placeholder="Firstname"> <br> <br>
<input type="text" name="Lastname" placeholder="Lastname"> <br> <br>
<input type="number" name="Age" placeholder="Age"> <br> <br>
<input type="submit" name="save_btn" value="Save Data"> <!-- Name attribute added -->
</form>
</div>
<?php
// Ensure this script runs only when the form is submitted
if (isset($_POST['save_btn'])) {
// Assuming $connect is your database connection object
include 'register.php'; // Include your database connection file
// Sanitize user inputs (consider using prepared statements for better security)
$fname = mysqli_real_escape_string($connect, $_POST['Firstname']);
$lname = mysqli_real_escape_string($connect, $_POST['Lastname']);
$age = mysqli_real_escape_string($connect, $_POST['Age']);
// SQL query to insert data into your database
$query = "INSERT INTO students (Firstname, Lastname, Age) VALUES ('$fname', '$lname', '$age')";
// Execute the query
$result = mysqli_query($connect, $query);
if ($result) {
echo "Record inserted successfully!";
} else {
echo "Error: " . mysqli_error($connect);
}
// Close the database connection
mysqli_close($connect);
}
?>
</body>
</html>
