$name=$_POST['name'];
$ic=$_POST['ic'];
$un=$_POST['username'];
$ps=$_POST['pass'];

$insert_query=mysqli_query($connect_homis,"INSERT INTO warden (WARDEN_NAME,WARDEN_IC,WARDEN_USERNAME,WARDEN_PASSWORD,STATUS_AKAUN,POSITION)values ('$name','$ic','$un','$ps', 'AKTIF','WARDEN ASRAMA')");


if ($insert_query)
{echo "<script> alert('success');</script>";

 header('Location: home_admin.php');`enter code here`
}


else
{
  echo "fail;";
}

try
{
    $conn = new PDO("mysql:host=$servername;dbname=homis", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


$stmt = $conn->prepare("INSERT INTO warden (WARDEN_NAME,WARDEN_IC,WARDEN_USERNAME,WARDEN_PASSWORD,STATUS_AKAUN,POSITION)
VALUES (:name, :ic, :username, :pass, :aktif, :warden_asrama)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':ic', $ic);
$stmt->bindParam(':username', $username);
$stmt->bindParam(':pass', $pass);
$stmt->bindParam(':AKTIF', $AKTIF);
$stmt->bindParam(':WARDEN_ASRAMA', $WARDEN_ASRAMA);

// insert a row
$name = $_POST['name'];
$ic = $_POST['ic'];
$username = $_POST['username'];
$pass = $_POST['pass'];


$stmt->execute();


// use exec() because no results are returned


echo "New records created successfully";
}


catch(PDOException $e)
{
    echo "Error: " . $e->getMessage();
}

$conn = null;