<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "mycms";
$uname = $_POST['user'];
$pword = $_POST['password'];
$fname = $_POST['firstname'];
$lname = $_POST['lastname'];
$gender = $_POST['gender'];
$agegroup = $_POST['ageGroup'];
$province = $_POST['province'];

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO users (user, password, firstname, lastname, gender, ageGroup, province)
VALUES ('$uname', '$pword', '$fname', '$lname', '$gender', '$agegroup', '$province')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

?>