Home

get_row($wpdb->prepare(
”
SELECT *
FROM wp_employee
WHERE EmpID = %s
“,
$thisUser
));

if($users != null){
echo “

Welcome “.$users->Name.”!

“;
}

$ActiveEmployers = $wpdb->get_var($wpdb->prepare(
”
SELECT COUNT(*)
FROM wp_useraccount
WHERE Status = %s
“,
“Active”
));

echo “Registered and Active Employers: “.$ActiveEmployers.”
“;

$InactiveEmployers = $wpdb->get_var($wpdb->prepare(
”
SELECT COUNT(*)
FROM wp_useraccount
WHERE Status = %s
“,
“Inactive”
));

echo “Employers waiting for approval: “.$InactiveEmployers.”
“;
}

?>