insert(
‘wp_employernew’,
array(
‘Name’ => $name,
‘EmailAdd’ => $email,
‘Location’ => $location,
‘POEANo’ => $poea,
‘Company’ => $company,
‘CompanyAdd’ => $address,
‘ContactNo’ => $contactNum
),
array(
‘%s’,
‘%s’,
‘%s’,
‘%s’,
‘%s’,
‘%s’,
‘%s’
)
);

// Insert to table wp_useraccount

$newUserID = $wpdb->get_row($wpdb->prepare(

SELECT EmpID
FROM wp_employernew
WHERE Name = %s
AND EmailAdd = %s
AND Company = %s
“,
$name,
$email,
$company
));

$wpdb->insert(
‘wp_useraccount’,
array(
‘EmpID’ => $newUserID->EmpID,
‘UserName’ => $username,
‘UserPassword’ => $password
),
array(
‘%d’,
‘%s’,
‘%s’
)
);

echo “Thank you. The Administrator will email your username and password after verification of your registration.”;
?>