$msg = "Incomplete Parameters";
$data = array();
} else {
$user_ids = json_decode($uid);
foreach ($user_ids as $k => $val) {
$sql = "SELECT * from buddyup where user_id=:user_id and kid_id=:kid_id";
$sth = $conn->prepare($sql);
$sth->bindValue('kid_id', $kid_id);
$sth->bindValue('user_id', $val);
try {
$sth->execute();
} catch (Exception $e) {
}
$res[$k] = $sth->fetchAll(PDO::FETCH_ASSOC);
if (!count($res[$k])) {
$user = DataClass::getUserIds($val);
$email = $user[0]['email'];
$sql = "INSERT INTO `buddyup` (`id`, `user_id`, `kid_id`,`buddy_code`,`created_on`) VALUES (DEFAULT, :user_id, :kid_id,:buddy_code,NOW())";
$sth = $conn->prepare($sql);
$sth->bindValue('buddy_code', $code);
$sth->bindValue('kid_id', $kid_id);
$sth->bindValue('user_id', $val);
try {
$sth->execute();
$success = '1';
$msg = 'Buddy Code sent.';
$msg1 = "Buddy Code for Jobstars";
//DataClass::sendEmail($email,$msg1,$code,SMTP_EMAIL);
} catch (Exception $e) {
}
} else {
