<?php
include "config.php";
include 'form.php';
$content = alert_m(array("WEEEEWOOOO"), array("green"));
newpage($content);
}
if (blank($lname)) {
$err = $err . "" . alert_m("Lastname field is blank", "yellow");
}
if (blank($residence)) {
$err = $err . "" . alert_m("Residence field is blank", "yellow");
}
if (count($r1) >= 1) {
$err = $err . "" . alert_m("Person already exists", "red");
}
if (count($r2) >= 1) {
//username
$err = $err . "" . alert_m("Username is already been used", "red");
}
if ($password != $repass) {
$err = $err . "" . alert_m("Password does not match", "red");
}
if (blank($err)) {
$q1 = "insert into person(fname,mname,lname,gender,residence)values('{$fname}','{$mname}','{$lname}','{$sex}','{$residence}')";
query($conn, $q1);
$q2 = "insert into employee(username,password,person_id)values('{$username}','{$password}',(select person_id from person where fname ='{$fname}' and mname='{$mname}' and lname = '{$lname}'))";
query($conn, $q2);
header('Location: create_personnel_form.php');
} else {
$title = "Register a new Personnel";
$desc = "";
$fname = input_form("Firstname", "fname", "text");
$mname = input_form("Middlename", "mname", "text");
$lname = input_form("Lastname", "lname", "text");
$sex = multi("Sex", "sex", array("Male", "Female"), array("male", "female"), "radio");
$residence = input_form("Residence", "residence", "area");
