connect_error) {
die("❌ Connection failed: " . $conn->connect_error);
} else {
echo "✅ Connected successfully
";
}
// Insert name (SECURE)
if (isset($_POST['name'])) {
$name = $_POST['name'];
$stmt = $conn->prepare("INSERT INTO users (name) VALUES (?)");
if ($stmt) {
$stmt->bind_param("s", $name);
$stmt->execute();
echo "✅ Name saved successfully
";
} else {
echo "❌ Prepare failed: " . $conn->error;
}
}
?>
MySQL Test
Enter Your Name
Saved Names:
query("SELECT name FROM users");
if ($result && $result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "👉 My name is: " . htmlspecialchars($row['name']) . "
";
}
} else {
echo "No names found.";
}
$conn->close();
?>