set_charset("utf8"); if (!$link) { echo "Error: Unable to connect to MySQL." . PHP_EOL; echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL; echo "Debugging error: " . mysqli_connect_error() . PHP_EOL; exit; } ?> query($codequery) === TRUE) { return '1'; }else{ return 'error'; } } function is_existing_user($data){ $codequery = "select count(id) cnt from xx_hr_national_day_draw where mbl = '$data'"; //echo $codequery; $result = $GLOBALS["link"]->query($codequery); while($row = $result->fetch_assoc()) { $id = $row['cnt']; } return $id; } function get_draw_users($data){ $codequery = "select * from xx_hr_national_day_draw where is_win = 'N'"; //echo $codequery; $result = $GLOBALS["link"]->query($codequery); while($row = $result->fetch_assoc()) { $id[] = $row; } foreach($id as $idv) { $drawusn[] = $idv['name']."|".$idv['mbl']; } //$drawusn[] = '123'; //$arr = array('Hello','World!','Beautiful','Day!'); return '"'.implode('","',$drawusn).'"'; //return $id; } function get_winner_by_id($data){ $codequery = "select * from xx_hr_national_day_draw where is_win = 'Y' and natid = '$data'"; //echo $codequery; $result = $GLOBALS["link"]->query($codequery); while($row = $result->fetch_assoc()) { $id[] = $row; } return $id; } function add_winner($name,$empid,$mobile){ $codequery = "insert into xx_winners (name, emp_id, mobile, winning_date ) value ('$name', '$empid', '$mobile', now() )"; //echo $codequery; if ($GLOBALS["link"]->query($codequery) === TRUE) { return '1'; }else{ return 'error'; } } function remove_winner_from_draw($data){ $codequery = "update xx_hr_national_day_draw set is_win = 'Y' where mbl = '$data' "; //echo $codequery; if ($GLOBALS["link"]->query($codequery) === TRUE) { return '1'; }else{ return 'error'; } } function redeem_gift_draw($data,$data2,$user){ $user = $_SESSION["user_id"]; $codequery = "update xx_hr_national_day_draw set is_prize_redeem = 'Y', prize_redeem_date = now(), prize_redeem_by_id = '$user', receiveing_letter = '$data2' where id = '$data' "; //echo $codequery; if ($GLOBALS["link"]->query($codequery) === TRUE) { return '1'; }else{ return 'error'; } } ?>